Display products pull in Google Sheets

Hi,

I’m trying to pull simple data through to display our in stock products, in a specfic warehouse? Then use a API conntector to put the data in Google sheets every day so I can then make some kind of price list for our customers. Also only some entries load and not the full product catalog.

https://api.veeqo.com/products?warehouse_id=25694&page_size=50&page=1

Also it’s asked for JMESPath which is the variables -

[
“sellables”: [ “stock_entries”: [{“warehouse_id”: 25694}]
]

Any ideas? Any API developers out there? Happy to explain more over Skype and also pay if required?

Joe