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?