Posts by Jared Dux
Tech Tuesday: Using Power Query to Merge Worksheets for the Excel Addin
If you have multiple sheets in an Excel file that need to be integrated with the SmartConnect Excel Addin, this process will help to get all the data into one sheet for the addin.In Excel, the first step is to create a data connection for each sheet containing the data we need. Select any cell in…
[Read More]
Tech Tuesday: Filtering Columns in SmartView
With the latest release of SmartView (18.0.6) we now have the option to filter columns more precisely. In the past, the filter was done using only a contains operation. This release allows you to filter columns as you already have been doing on your SmartView data so you will likely be familiar with how they…
[Read More]
Tech Tuesday: How to Handle Paging with Shopify in SmartConnect
The paging method shown in this article was removed by Shopify. Instead the new REST Connector in SmartConnect.com and SmartConnect 21 will need to be used with built-in paging. A sample Shopify connector can be downloaded here. If you have connected to Shopify with SmartConnect and have more than 250 records to query (Customers, Products,…
[Read More]
Tech Thursday : Save an Excel File From a REST Service Response
Since SmartConnect 2015 we’ve been able to connect to a variety of REST services using the REST connector. This requires the service to provide a JSON or XML payload. I recently came across a service that doesn’t use JSON or XML. The GoToWebinar Admin API will only give back an Excel file, so I could…
[Read More]
Tech Tuesday : Setting up Xero Connector in SmartConnect
To use Xero with SmartConnect there are a few things that need to be setup before you can enter any information in the Xero Connector setup window.The first thing that is required for Xero is a public/private key-pair. You will need to download OpenSSL to create this. Download OpenSSL here. Install OpenSSL and leave all the default…
[Read More]
Tech Tuesday: Connecting to Shopify with SmartConnect
A newer version of the SmartConnect REST connector is now available on SmartConnect.com and SmartConnect 21 and newer. A sample Shopify connector can be downloaded here. This week we are going to take a look at Shopify and how we can use SmartConnect’s REST Connector to integrate with Shopify. To get started you will need…
[Read More]Tech Tuesday: Using the Correct NAV Service With SmartConnect
The current release of SmartConnect can integrate to Dynamics NAV using the SOAP services available within Dynamics NAV. If you have not used the NAV web services or are new to NAV this tip will make it a little easier to find the data that you need quickly. To get started you will need to…
[Read More]
TechTuesday : Connecting to Spark Pay using the REST Connector
This week we are going to take a look at using SmartConnect to integrate to Spark Pay using the REST connector. SmartConnect can be used to get data from Spark Pay and create or update data in Spark Pay. This will not go through completely setting up the connector from scratch as there will be…
[Read More]
Previewing Data on a Folder Data Source Map
This week I’m going to point out a quick feature that is often overlooked because it functions slightly different from the normal process. Typically when you setup a data source you can click the Preview button on the Data Source section of the map setup window to preview your source data. On a Folder Data…
[Read More]
Tech Tuesday: Setup SmartConnect to use a Production and Test Database
A new feature on SmartConnect 2016 is the option to connect your SmartConnect install to two databases. During the initial install of SmartConnect the first database and SmartConnect user will be created for you. This article is not going to go through installing SmartConnect. Please refer to the installation documentation for these steps if needed.…
[Read More]