Forum Discussion

reuben's avatar
reuben
New Contributor
2 years ago

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...
endor_force's avatar
endor_force
New Contributor III
2 years ago

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 :  ''

 

  • reuben's avatar
    reuben
    New Contributor
    2 years ago

    How are $PickListItems and PickListItem defined?  Would that need to be done in separate mapper?

    if $CustomFields is defined as the array above, I had to use two mappers:

    One to get the value and one to get the field itself (item in the custom fields array):

    $servicesizefield: jsonPath($, "CustomFields[*]").find(x=>x.FieldName=="ServiceTypeSize")

$servicesizevalueid: jsonPath($, "CustomFields[*]").find(x=>x.FieldName=="ServiceTypeSize").Value

    then 

    jsonPath($,"$servicesizefield.PickListItems[*]").find(x=>x.CustomFieldPickListItemID==$servicesizevalueid).Value

     to get the actual value at that id.

    How would I adapt that to expression library as jsonpath doesn't seem to work at all?