Configure a Connection Profile

From the CData ribbon, click Get Data and select From Shopify connection/s to launch the CData Query window. To setup a new connection, you will have to click the New Shopify Connection button. Here you can set the connection settings, test the connection, and save the connection profile.

Connecting to Shopify

This section describes how to connect to Shopify from the web, a desktop application, or a headless application. The supported authentication methods are OAuth and OAuthClient.

OAuth Authentication

Shopify supports OAuth authentication. In all cases, AuthScheme must be set to OAuth, and you must create a custom OAuth application. See Creating a Custom OAuth Application for more information.

Desktop Applications

Follow the steps below to authenticate with the credentials for a custom OAuth application.

Get and Refresh the OAuth Access Token

After setting the following, you are ready to connect:

• OAuthClientId: Set this to the client Id assigned when you registered your application.
• OAuthClientSecret: Set this to the client secret assigned when you registered your application.
• CallbackURL: Set this to the redirect URI defined when you registered your application.

When you connect, the add-in opens Shopify's OAuth endpoint in your default browser. Log in and grant permissions to the application. The add-in refreshes the access token automatically when it expires.

OAuth Client Authentication

Shopify supports OAuth authentication using the Client Credentials grant flow. You must create a custom OAuth application, define the required scopes, and install the application on the store where you want to retrieve data. See Creating a Custom OAuth Application for more information.

Note: The Client Credentials flow is available only for apps developed by your own organization and installed on stores that you own.

To connect, set the following properties:

• AuthScheme: Set to OAuthClient to perform authentication using the Client Credentials grant type.
• OAuthClientId: Set this to the client Id assigned when you registered your application.
• OAuthClientSecret: Set this to the client secret assigned when you registered your application.

Connection Properties

The Connection properties describe the various options that can be used to establish a connection.

Managing Connections

After successfully authenticating to Shopify you will be able to customize the data you are importing. To learn more about this, see Managing Connections.

See Also

• Querying Data: Use the data selection wizard to pull data into a spreadsheet. You can also configure scheduled data refresh here.
• Using the Excel Add-In: Find other ways to interact with Shopify data, such as using the available CData Excel Functions.