Apologies for the delay, @Martin_M! I'm going to DM you in order to confirm some account details.
A few additional questions:
- Is this behavior sporadic or deterministic?
- Do all queries against this resource have the same issue or just some?
Additional screenshots of the relevant resource configuration and failing query blocks could be helpful! I'd be interested in jumping on a call, as well, if you're able to join Office Hours.
Hi Darren,
its deterministic, all queries in two workflows, other workflows dont have that issue with the resource, I also use the resource within apps, without issues.
The resource configuration i will send to you via PM. Regarding the Call i will also reply to you via PM.
To anybody following along - I believe we've finally resolved this issue, even if the exact cause is still a little bit murky.
There's a code execution path in our workflow backend that detects and reformats columnar data - JSON objects where all the values are arrays. It so happens that the Directus API response is formatted as { data: [{...}, {...}, {...}] }.
There are several reasons that this response should be excluded from said execution path - and I was never able to reproduce the faulty behavior myself - but forcing the response to include a non-array value via the meta=* query param concretely prevents any reformatting.