topic Create a conditional (ie: If value includes to this) function against an array in Workato Pros Discussion Board

Create a conditional (ie: If value includes to this) function against an array

mlodge — Fri, 01 Apr 2022 01:39:07 GMT

New to Workat and I am working with a schema that has some nested arrays and I cant seem to figure out how to create a if condition that will be triggered if any option in the nested array contains the specific value.

Example:

create a if condition where "Interests" contains "swimming" so that the data in the schema below is picked up

{

"deliveryContext": {

"camper": {

"demographics": {

"address": "string",

"city": "string",

"state": "string",

"country": "string",

"phone": "string",

"postalCode": "string",

"email": "string",

"firstName": "string",

"lastName": "string",

}

"Interests": [

{

"id": "34",

"value": "biking"},

{id": "27",

"value": "biking"}.]

}

Re: Create a conditional (ie: If value includes to this) function against an array

dcornwell — Fri, 01 Apr 2022 01:59:09 GMT

It looks like the JSON has some errors in it but my guess is that the correct JSON is:

{"deliveryContext": {"camper": {"demographics": {"address": "string","city": "string","state": "string","country": "string","phone": "string","postalCode": "string","email": "string","firstName": "string","lastName": "string","Interests": [{"id": "34","value": "biking"},{"id": "27","value": "biking"}]}}}}

And the formula based on that would be:

["deliveryContext"]["camper"]["demographics"]["Interests"].pluck("value")

Re: Create a conditional (ie: If value includes to this) function against an array

mlodge — Fri, 01 Apr 2022 02:00:26 GMT

David Cornwell - thanks, I quickly copied and modified the json to act as an illustrative example. thanks for the assist.

Re: Create a conditional (ie: If value includes to this) function against an array

rayudu_addagarl — Fri, 01 Apr 2022 02:41:20 GMT

I think this works, Sample i tried.

https://app.workato.com/recipes/2239282?st=157230

Re: Create a conditional (ie: If value includes to this) function against an array

rayudu_addagarl — Fri, 01 Apr 2022 02:45:06 GMT

workato's "parse json" does not work with complex json unfortunatley

Re: Create a conditional (ie: If value includes to this) function against an array

james-ng — Fri, 01 Apr 2022 18:29:16 GMT

hey RAYUDU ADDAGRALA the recipe worked with David Cornwell's json

correctly picked up the second id "22" with value "swimming"

Re: Create a conditional (ie: If value includes to this) function against an array

jgold — Fri, 01 Apr 2022 19:32:27 GMT

In the input field of the if step enter:

deliveryContext[‘camper’][‘Intrests’].pluck(‘value’).include?(‘swimming’) and then setup the condition as “is true”.

Notes:

make sure to use formula mode
deliveryContext is a datapill from a previous step.
Make sure to use actual single quotes (my phone doesn’t put proper single quotes in an email)
You need to handle cases where deliverContext is a nil object since using [‘camper’][‘Intrests’] on a nil object will throw an error.

Joel Gold

Principal

Doliotech

801-613-1115

Jgold@doliotech.com