Question:
I want to get some Information about an Order in the Wix-shop to Excel.
Product:
WixStore
I code in VBA.
It looks good, if I make query to
wixapis.com/site-folders/v2/folders/query
I get information
I get some correct Information.
If I send:
“https://www.wixapis.com/stores/v1/products/query”
I give also an APIKey, wix-site-id,wix-account-id to the query.
The APIKey has all permissions.
but the Answer is:
{“message”:“Permission WIX_STORES.READ_PRODUCTS is required”,“details”:{}}
What is wrong?
Is it not possible to connect Excel with the APIKey to the WixStore?
you can add the read products permission needed in your dashboard. The docs here will explain more About Permissions
the permissions required for the API are listed in the docs here https://dev.wix.com/docs/rest/business-solutions/stores/catalog/query-products
thx, for your answer.
..I looked to your Links, but now I’m not sure that I take the correct function / strategie to connect to the orders on my Wix shop.
I read in the doc that for third party APPs it is necessary to use OAuth 2 authentication.
Is a connection with https commands a third party APP? In my case I work on Excel with VBA to send the http requests to WIX.
Is in this case the autentification via App-Key to less and not posible? thx
You are attempting to query stores so in this case the “app” is Stores.
In the docs here - it shows all the permissions you need to configure to communicate with the stores app on your site (including read products) https://dev.wix.com/docs/rest/business-solutions/stores/catalog/query-products
So- you are setting a permission for an app - but not an app you’ve created, a Wix App.
Hello!
thx for answering…
If I follow your link and query “products” with a generated test-key, it works fine.
If I take a API-KEY form my account it gives an error.
… and i don’t want to connect my homepage to wix. I want to connect Microsoft Excel (local on my PC installed) to the products of my Wix-Store.
Thx for your kindly support
Your authorizations are likely incorrect in you key setup. I would check through here. API Keys
If you are still having trouble, we have a dedicated channel in Discord for headless questions where you may find more help from the community.
If you believe you have configured everything correctly for the proper permissions and may be facing a bug, you can open a ticket here for further investigation Wix Studio - How to report a bug