#Querying Collection in Flow produces empty array instead of failing.

2 messages · Page 1 of 1 (latest)

crude sun
#

Hey there,

I'm using the Read Data operation in a data flow, in which I am querying for items in the Query box not in IDs box. When searching for items that match, it produces an array of items (as expected). When searching for items, purposely attempting to not find a match, instead of the Read Data operation failing, it simply produces an empty array and considers it a success. While I know I could write a Run Script after this operation that checks for an empty array result and then throws an error, I was hoping to keep this simple.

Is there a way to query a Read Data operation and cause it to fail instead of having it produce an empty array?

restive hull
#

When Querying there is not really the concept of "failing" as an empty result is perfectly valid response when querying dynamically (think of querying all archived items just because there are none doesnt mean the request failed).

Only way to have it fail im afraid is to check the result afterwards in a condition or script operation.