Expression Library - navigating JSON arrays

Question

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 "LateralSize" in one parameter and the following in the second parameter:&nbsp;&nbsp;[{
"CustomFieldId": "68f40528-4d63-6a70-60d6-0797407c53d7",
"CustomFieldLayoutControlType": 2,
"FieldName": "LateralSize",
"Label": "Lateral Size",
"PickListItems": [
{
"CustomFieldPickListItemID": "28bd8b11-dfd5-f514-a694-320be7078e59",
"Value": "5",
"Order": 1
},
{
"CustomFieldPickListItemID": "2b58d501-5584-bfbb-a622-54778262cf3f",
"Value": "6",
"Order": 2
}
],
"Value": "2b58d501-5584-bfbb-a622-54778262cf3f",
},
{
"CustomFieldId": "09a0e02d-ae97-431e-74b6-4ea9ecdd742d",
"FieldName": "StreetofConnection",
"Label": "Street of Connection",
"Value": "asdf"
}
] &nbsp;I would like to get the 6 in the value field.&nbsp; Each value of the custom field has a guid.&nbsp; I need to match the actual value in the custom field guid to the CustomFieldPickListItemID.In other words, I find the guid found in&nbsp;"Value": "2b58d501-5584-bfbb-a622-54778262cf3f",and then match it up to the&nbsp;"CustomFieldPickListItemID": "2b58d501-5584-bfbb-a622-54778262cf3f"Then, I would like to return what is in the value field in that item - 6.Any ideas will be appreciated.

endor_force · Answer

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.&nbsp;If the document has PickListItemsThen Filter out the element where CustomFieldPickListItemID is = to $Value of the document, returns the first found value of $PickListItems.Value found.&nbsp;If it does not have PickListItems it returns empty string$.hasPath("PickListItems") ? ($PickListItems.filter((PickListItem) =&gt; PickListItem.CustomFieldPickListItemID== $Value ))[0].Value :  ''&nbsp;

reuben · Answer

How are $PickListItems and PickListItem defined?&nbsp; Would that need to be done in separate mapper?if $CustomFields is defined as the array above,&nbsp;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=&gt;x.FieldName=="ServiceTypeSize")

$servicesizevalueid: jsonPath($, "CustomFields[*]").find(x=&gt;x.FieldName=="ServiceTypeSize").Valuethen&nbsp;jsonPath($,"$servicesizefield.PickListItems[*]").find(x=&gt;x.CustomFieldPickListItemID==$servicesizevalueid).Value&nbsp;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?

Forum Discussion

Expression Library - navigating JSON arrays

Recent Discussions

How to get filename from file reader

Generate expression file from database query

Can we generate XML file in pretty print format using native snapLogic snaps?

401 error with HTTP Client and NTLM

Pagination and nextCursor in header