Jump to content

API import data changing order?

Recommended Posts

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
  • Replies 0
  • Views 519
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

×
×
  • Create New...

Squarespace Webinars

Free online sessions where you’ll learn the basics and refine your Squarespace skills.

Hire a Designer

Stand out online with the help of an experienced designer or developer.