Azure Data Factory Shopify connector not working

Question

Hello,

I am trying to use the Shopify connector ( preview ), but is not working. It gives the following error: ERROR [HY000] [Microsoft][Shopify] (60) API Connection Failed (Unauthorized Access). Check credentials. HTTP Response code: 403 .Everything is working fine in Postman. Anyone that encountered this issue?
How can we confirm that the header (X-Shopify-Access-Token) that corresponds to the access token is sent?

Thank you
Christian

Answer 1

I'm having the same issue, and I have used an access token from my Shopify's private app. Both the Admin API and the Storefront API access keys result in a 403 when used with Azure's connector. Both access keys I've confirmed do work normally. There is no information available about what the Azure connector is connecting to.

https://learn.microsoft.com/en-us/azure/data-factory/connector-shopify?tabs=data-factory#linked-service-properties

The azure data connector does not state which API it uses to connect to Shopify. The lack of basic info is egregious. Please find the L4 developer who deployed this halfbaked crap, contact his manager, and let the manager know that their incompetent subordinate should be placed on a performance improvement plan.

Answer 2

how do you have the shopify linked service configured?

I currently use the shopify connector with adf to replicate order data from multiple websites and it works fine.

Below is the configuration I use on the linked service where I parametrize the uri and the shopify access token and pass those values into the linked service from the shopify dataset. The only other thing that might be a gotcha is that I set the shopify access token as a variable of type securestring when passing it to the linked service. IIRC it failed when I did not identify the access token as a secure string.

{  
    "properties": {  
        "type": "Shopify",  
        "description": "Parameterized Shopify Linked Service",  
        "parameters": {  
            "hosturi": {  
                "type": "string"  
            },  
            "access_token": {  
                "type": "string"  
            }  
        },  
        "annotations": [],  
        "typeProperties": {  
            "host": "@{linkedService().hosturi}",  
            "accessToken": {  
                "type": "SecureString",  
                "value": "@{linkedService().access_token}"  
            },  
            "useEncryptedEndpoints": true,  
            "useHostVerification": false,  
            "usePeerVerification": false  
        }  
    }  
}  

Hope this helps!