Expression Library - navigating JSON arrays
I would like to create an expression library that traverses a JSON array, but I am unsure of the syntax as it does not seem to match what I usually use in a pipeline (JSONPath). Say I have "LateralS...
Forum Discussion
You can do it in mapper by using this code, which probably can be partially or fully moved in to an expression library function also with some tinkering.
If the document has PickListItems
Then Filter out the element where CustomFieldPickListItemID is = to $Value of the document, returns the first found value of $PickListItems.Value found.
If it does not have PickListItems it returns empty string
$.hasPath("PickListItems") ? ($PickListItems.filter((PickListItem) => PickListItem.CustomFieldPickListItemID== $Value ))[0].Value : ''
