The length function is not working correctly without using flatten

Question

Here, the integrationResponse.result.body is an array of dictionaries. However, the length function returns 1 if not using flatten. Not sure why this is happening. Please share comments/reasons if any.

Mike Schmitt · Answer

Length is one of the primitive functions and as such, its use is constrained by some picky (and sometimes unintuitive) back-end stuff. I'm not sure exactly what's going on here of course but as Stefan mentioned, it might help to see some of the raw JSON data being returned. My first guess is that it's being confused by the exact data type of the ".body" result, perhaps interpreting it as an array of 1 item consisting of an array of the 5000 items we see - or something like that. a!flatten() will of course smoothe this out, explaining why the result you see with that is coming out better. That doesn't indicate a "problem" with length(), per se, as much as the fact that there are weird corner cases where its (correct) behavior is unintuitive.

Mike Schmitt · Answer

your integration call is probably returning a nested list. you didn't post the expanded version of the data structure it's returning so it's hard to know for sure. either way, wrap "rule!ABC_getOrders()" in a "a!flatten()" call and see what happens.

The length function is not working correctly without using flatten

Top Replies