how to filter specific element value from a name/value pair array

[Jaganath Baskaran]

Hi Team ,

Product : Tibco Cloud integration - FLOGO

We have a requriement to filter specific element value from a name/value pair array . But seems to be not possible with the array functions or filter conditions . We have tried multiple ways and not able to achieve it . Could you please help and provide your inputs here .

Description : we have an array with name/value pair as input .

{

"sf_return_rows":

[

{

"attr_name": "Email",

"value": "cj1-drv-dev-1421@mailinator.com"

},

{

"attr_name": "FirstName",

"value": "Fernando"

},

{

"attr_name": "Id",

"value": "0030r00000iacWyAAI"

},

{

"attr_name": "LP_CountryCode__c",

"value": "LPIE"

},

{

"attr_name": "LP_MainContact__c",

"value": false

},

{

"attr_name": "LastName",

"value": "Test"

}

]

 

}

 

We need to map the value of specific elements to the , string element in the output schema . Index will change at anytime . So we cant use the index number here to filter out . We supposed to filter out based on the attr_name .

example :

first_name ---> (this needs to be value of the attr_name:FirstName) - Note : this is a primitive string element

last_name --->(this needs to be value of the attr_name:LastName)- Note : this is a primitive string element