DiceyNova Posted July 20 Share Posted July 20 Hello! I'm using Apipheny to import some data from Squarespace into a google sheet that I'm then referencing in another sheet to do accounting math. The problem is, every time my API call runs (once an hour), it seems like the order of the data is changing? I have to keep going in and changing the columns being pulled in order to keep the calculations working correctly. API call:https://api.squarespace.com/1.0/commerce/orders This pulls all data for all orders into a sheet. Query I'm using to pull data to another sheet:=QUERY((Data!B2:BA), "Select Col1,Col28,Col36,Col37 WHERE (Col28 like '%HFM')") The columns I select keep moving around, usually 1 or 2 values bot last night I had to move them about 8. Sometimes, Columns 36 and 37 just switch. Any help would be great! I'm not well-versed in API stuff and kinda figuring this out as I go, but I've been unable to find any info about this online. Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment