Mapping¶
Map data from one format to another, or query the input data using JMESPath or JSONPath expressions. http://jmespath.org/tutorial.html
Default config¶
{
"type": "mapping",
"mapping": "data"
}
Supported properties¶
- mapping - a JMESPath expression
Handy JMESPath patterns¶
Filtering data¶
Filter by the existence of a flag
data[?tags[?@ == 'deleted']]
This will keep any item that has a “deleted” flag in the “tags” array. More useful in this instance would be it’s inverse.
data[?!(tags[?@ == 'deleted'])]
Adding a new key to an object¶
If you’re wrangling data from one form to another, you may need to add new keys.
data[*].merge(@, { key: value })
Setting a value based on a flag¶
If you want to add a new value to your object based on whether or not another flag is set in an array, you can do something like this.
data[*].merge(@,{deleted: @.tags[?@ == `deleted`]})
This will look through the tags attribute to see whether or not a “deleted” tag is set, and set the new attribute accordingly.
Accessing context from within a merge¶
When using a merge, or similar function, paths become relative to your current item. If you need to access a value from beyond this context, you need to use the “$” operator to access the root of the data.
data[*].merge(@,{
exists:contains($.context.flowsExisting || [''], join('-',[@.adapterName,@.workflowId]))
})
Finding a specific key in an array¶
A more advanced version of the object merge can involve looking up a specific entry in an existing array of objects.
In this example, we merge two object arrays, and look up a unique key from a list, and then add that key so that we can create a reference.
data && merge(data, {track: uniqBy(data.track, 'key')})
find($.data.licensor, ‘name’, “LICENSOR NAME”).id,
Merging two arrays¶
If you have two arrays, and want to combine them, you can use the flatten operator “[]”. For example, if you want to combine information from a form with data you’ve previously saved to context, you can merge the two arrays like this.
[context.saved, [data]][]
Kendraio Mapping extensions¶
Kendraio is using a version of JMESPath that supports extensions to provide additional functionality. You can find these in our repository:
https://github.com/kendraio/kendraio-app/blob/develop/src/app/blocks/mapping-block/mapping-util.ts