Skip to content


Tech Tuesday: Setting up a Basic Authentication Service in

A while back, I wrote an article about connecting to Shopify with the REST Connector using SmartConnect on-prem. With, this process has been simplified and also has some additional features that make working with an API easier. Currently, REST Services are available as sources in Destinations for these services will be released at a later date.

I will use Shopify in this example today. The Shopify setup will be the same as it was for the on-prem version of SmartConnect. If you’ve already done that, you can skip the Shopify Setup section.

Shopify Setup

To start, we need to setup a Shopify app that will give us access to the Shopify API. Login to your Shopify account with a user that has permissions to create an App. Once logged in to Shopify, you will need to navigate to Apps>>Manage private apps.

Authentication Service in

Enter a Private app name of your choice and then set the permissions appropriately for what you need to do with an integration.  Since this connector will be for sources, you’ll only need to set Read access for all the endpoints.  

Authentication Service in

Make sure to save your App settings so an API Key and Password will be generated. We will need to use these values when setting up the service in

Authentication Service in

Setup for the REST Definition

In, navigate to Maintenance>>REST Services>> Create Rest Service to begin the setup. Setup the connector as below.

Authentication Service in

Setting up a Service Entity

Click on Service Entities to setup the first endpoint. I am creating a customers endpoint, so I will name it Customers and then click the edit pencil.

Authentication Service in

Set the Endpoint to customers.json and then click on Fields. You can manually enter all the fields that you want in your source, or you can click Load from file to import all the fields from a json file. To load from file, you will need to copy out the json response from the api documentation for your particular endpoint and save it as json file.

Authentication Service in

Add Paging

Paging is a new feature in that simplifies the ability to get all the records you need. Navigate to the Paging and set the options as below. The default page size for Shopify is 50, and the max is 250, so you need to set it no higher than 250.

Authentication Service in

Setup a Connector to use your Shopify service definition

Navigate to Connections>>Create Connection and choose your Shopify rest definition. Name the connection and then enter the Username and Password. These were given in the app setup from within Shopify that we setup in the beginning of the article. The Username is the API Key and the Password is the password. Save the connection.

Setup a Data Source

The last step to get some data is to navigate to Data Sources>>Bulk Sources>>Query>>Create Bulk Query. Select your Shopify source, enter a description for the data source, choose your Shopify connector, and then choose the Customers Entity that we defined earlier. Click Validate to enable the Save and Preview buttons.

After you save your data source, you can use the source on as many integrations as needed. Once you have this basic setup working, you can add additional Service Entities to get more data that you need.

If you have any questions, comments, or want to learn more, feel free to email us at

Leave a Comment


Q1 2023 All Hands Call
2023 Advanced SmartConnect Bootcamp: REST Web Services Integration
Accessing Your Historical Dynamics NAV Data in D365 Business Central - Part 1: Getting Started
2023 Migration from Dynamics GP to D365 Business Central Training
eOne Welcomes Incremental Group as a New eOne iPaaS Integration Partner


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
2017 SmartConnect Integration Bootcamps
New Releases of Extender and SmartList Builder



Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships Partner All Hands Call Popdock promotions release SalesForce SmartConnect SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.