Hi, I'm receiving two different results when querying Google Sheets in my workflows. One gives me the column structure, other is json. Screenshot attached. Any ideas?
They technically aren't two different results. It's just that one (the first one) is displayed to you in a tabular format, while the second one is displayed in raw form (a list of json objects). This is probably because of the # of rows being greater in the second query. Programatically both will be in the form of a list of json objects and you would access/use them the same way.
I'm running a simple SQL afterwards but with differently presented results, it doesn't work.
Below query works fine for "Purchase_Orders.data" but for "Transfer_Orders" returns an empty array.
What would be the best way to approach it? I'm exploring myself in the meantime
SELECT SKU, column1, column2, etc...
FROM {{ Purchase_Orders.data }}
WHERE SKU IN ({{startTrigger.data.text}})
For anyone having a similar problem, I used "return formatDataAsObject(query13.data)" in JAVASCRIPT and it helped with having desired formatting