JSON Path used for mapping data is used from library JSONPath.
JSON Path | Documentation |
---|---|
book[2] |
Returns third element of book |
$.[book1,book2] |
Returns values of fields book1 and book2. If field is not marked as multiple, only first value will be stored. |
[?(@.date !== "0000-00-00")] |
Returns only valid dates. |
$.emails.[?(@.type=="work")].email |
Returns email of type ‘work’ |
Expression
${$root.incoming === true ? $root.value : ($root.value * -1) }
${$root.INDI == ‘C’ ? $root.CASTKA : ($root.INDI == ‘D’ ? $root.CASTKA * -1 : ”)}
Date formats
For formats we are using library momentjs
. See moment.js documentation.
X | Unix timestamp |
---|---|
x | Unix ms timestamp |
MM-DD-YYYY HH:mm Z | 02-20-2017 23:58 UTC |
DD-MM-YYYY HH:mm Z | 20-02-2017 23:58 UTC |