topic Re: Checking for the presence of an array in Workato Pros Discussion Board

Checking for the presence of an array

dcornwell — Fri, 09 Apr 2021 03:33:09 GMT

Hi Folks,

So to check for the presence of an array (i.e. that there is at least 1 item in the array), as far as I'm aware you need to do a formula to check the length of it. i.e.

array.length (<-formula)

greater than (<-condition)

0 (<-value)

Doing just an 'is present' condition doesn't work. Is there something else simple like this that I'm missing?

(and Hi - first post on the Community!)

Regards, David.

Re: Checking for the presence of an array

ekta-saxena — Fri, 09 Apr 2021 03:41:46 GMT

We can check the size of an array in the 'If condition'.

Re: Checking for the presence of an array

rob-lucian — Fri, 09 Apr 2021 03:44:54 GMT

Hi David,

I normally use the "List Size" datapill when I do my conditions, but I set them up very similar to what you posted.

.present? might help you depending on your desired output.

Re: Checking for the presence of an array

dcornwell — Fri, 09 Apr 2021 03:45:18 GMT

Thanks - I should have elaborated that I'm doing that in an 'if conditon'. Main question was really whether there is another way other than looking at the list size/length. Another platform I use can check arrays with an 'exists' condition (equivalent to the 'is present' in Workato).

Re: Checking for the presence of an array

dcornwell — Fri, 09 Apr 2021 03:45:55 GMT

Ah, OK - thank you Rob (my previous post was not in reply to yours)

Re: Checking for the presence of an array

rob-lucian — Fri, 09 Apr 2021 03:48:15 GMT

No problem! I'm not sure if you've seen this, but there is a section that sort of showcases the .present? formula in an array format

Re: Checking for the presence of an array

rob-lucian — Fri, 09 Apr 2021 03:48:47 GMT

https://docs.workato.com/formulas/array-list-formulas.html#present forgot the link