Connecting to Admin API with Power Query in Excel

Connecting to Admin API with Power Query in Excel

TurningTides
Visitor
1 0 0

Hi,
Is anybody connecting from Excel to the Shopify Admin app successfully? I have a URL that works directly in a browser as below (I have changed the  API user/password below, but this works okay with the real values.)

https://99999999:999999999a@turning-tides-unit.myshopify.com/admin/api/2022-04/orders.json

 

However, when I try to establish a web connection to this in Excel Power Query, I cannot get this to work.

I have seen on other forums that a basic connection, specifying the user and password as the first parts of the URL above should work, but it fails to authenticate for me.

 

Any tips very welcome.

Thank you,

Steve

Replies 0 (0)