Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,310 questions
Shopify Connector Failed in Azure Synapse
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 11%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMN%3C/text%3E%3C/svg%3E)
Malshini Nissanka
0
Reputation points
I am trying to pull data from Shopify to an Azure data lake using the Synapse pipeline. For that, I am using the Shopify connector in Synapse. I have created an app in Shopify and generated the access token, but when I test the connection from Synapse it gives this error.
"ERROR [HY000] [Microsoft][Shopify] (60) API Connection Failed (Unauthorized Access). Check credentials. HTTP Response code: 403
ERROR [HY000] [Microsoft][Shopify] (60) API Connection Failed (Unauthorized Access). Check credentials. HTTP Response code: 403
Activity ID: b9a3dc61-a3ef-4022-919a-8abfaf37f166."
I can't find where it has gone wrong. How can I resolve this error?
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 38%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQ%3C/text%3E%3C/svg%3E)
QuantumCache 20,356 Reputation points2023-08-21T16:28:03.3033333+00:00 Hello @Malshini Nissanka Welcome to QnA forum.
This error could be due to a number of reasons, such as incorrect credentials or permissions.
Could you please add more info on the Synapse pipeline ? Any Screenshots of the sample pipeline which is failing ? so that we try to repro that from our side?
Could you please try the Connectivity test from POSTMAN ? if the Authentication is working from POSTMAN, then it should not be an issue from Synapse pipeline!!!
Other factors may be like: credentials, API rate limits or App Permissions
-
QuantumCache 20,356 Reputation points
2023-08-29T07:17:36.59+00:00 Hello @Malshini Nissanka Just checking if we are still connected on this discussion?
Sign in to comment
Sign in to answer