Integration Studio - Filtering a JSON (SMAX 24.1)

Question

In Integration Studio I'm having a syntax issue trying to filter a json to extract an element. In the sample json below, abbreviated for simplicity, I need to extract the endDate where the entitlementType=='INITIAL' && serviceLevelCode=='ND'. 
 I had thought this would work (and tried quite a few other variations): filter(json_parser(response.data,'$.result.entitlements'),'item.entitlementType=="EXTENDED" && item.ServiceLevelCode=="ND"','{"EndDt":item.endDate}',0) 
 But it does not extract the element. Other, unfiltered elements are coming out fine. What's wrong with my syntax? 
 Thanks in advance, 
 Lyn 
 { 
 "code": 0, "originalCode": 200, "localChannel": "47", "countryCode":"US", 
 "result": [ { "id": 2137399848, "entitlements": [ { 
 "itemNumber": "1gj", "endDate": "2025-07-24T04:59:59.000001Z", "entitlementType": "INITIAL", "serviceLevelCode": "ND" }, { "itemNumber": "2rb", "endDate": "2025-07-24T04:59:59.000001Z", "entitlementType": "INITIAL", "serviceLevelCode": "RR" }, { "itemNumber": "3a", "endDate": "2028-07-24T04:59:59.000001Z", "entitlementType": "EXTENDED", "serviceLevelCode": "ND" } ] } ] }

Pandrangi Vishnu Teja · Accepted Answer

Hi ckomada 
 
 Here, the entities is an array and this loaded into field Arr 
 field Number is used to get the length of the Array 
 So I'm loading the first element of the array Arr into fields Brr and Crr 
 The value in fields Brr and Crr is same 
 You can use either of these methods to get the value outside of the Array 
 I couldn't find a direct method to extract the value directly while using filter method. So this is an alternative 
 We can use the values of other fields to recreate a new field. 
 If you have loaded your endDt into field result 
 then create another filed in the output object named as date and set the value as if(Output?.result != []) (Output.result[0]) else {null} 
 You can set null or any other default value for else condition based on your requirement 
 This above method is a work around by creating another field. I will check if there is any direct method we can use outside filter method to achieve this.

Pandrangi Vishnu Teja · Answer

Hi ckomada 
 According to the JSON item you provided 
 the result and entitlements both are arrays 
 Which element of the result array to use is not specified 
 filter(json_parser(response.data,'$.result.entitlements'),'item.entitlementType=="EXTENDED" && item.ServiceLevelCode=="ND"','{"EndDt":item.endDate}',0) 
 Could you please replace it with the below text and test it? 
 filter(json_parser(response.data,'$.result [0] .entitlements'),'item.entitlementType=="EXTENDED" && item.ServiceLevelCode=="ND"','{"EndDt":item.endDate}',0)

Menu

Service Management Automation X Discussions

Verified Answers

Integration Studio - Filtering a JSON (SMAX 24.1)

Tags:

Top Replies

Verified Answer

Verified Answer

Resources