Tech Tuesday: Setting up a Basic Authentication Service in SmartConnect.com

A while back, I wrote an article about connecting to Shopify with the REST Connector using SmartConnect on-prem. With SmartConnect.com, 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 SmartConnect.com. 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 SC.com

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 SC.com

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 SmartConnect.com.

Authentication Service in SC.com

Setup for the REST Definition

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

Authentication Service in SC.com

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 SC.com

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 SC.com

Add Paging

Paging is a new feature in SmartConnect.com 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 SC.com

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 sales@eonesolutions.com

Leave a Comment


2020 Q3 Promotions
Last Chance! Dynamics GP Integration Bootcamp in July 2020!
Happy Fourth of July from eOne Solutions!
Throwback Thursday: Microsoft CSP Billing Integration Case Study
Throwback Thursday: Tips, Tricks & Gotcha Moments when Connecting


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



open all | close all


Business Central CRM Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News Events Excel Excel Report Builder Extender Extender Enterprise Flexicoder GP GPUG integration Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Office Relationships partners Popdock promotions release Reporting SalesForce SalesForce.com scripting SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Office Hours SmartList SmartList Builder SmartList Designer SmartView SQL Support Tech Tuesday Templates training Zendesk

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.