Skip to content
+1-888-319-3663
Tech Tuesday

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

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

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

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]

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

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]

RECENT POSTS


2022 Q2 Partner All Hands Call - Recording Now Available!
Embed External Data on Any Dynamics 365 Business Central Window Without Code.
Tech Tuesday: Executing SmartConnect 2018 Maps from SQL
Best Practices of Integrating Salesforce and D365 Business Central - Part Three: Integration Strategy
Best Practices of Integrating Salesforce and D365 Business Central - Part Two: Data Strategy in Integrations

POPULAR POSTS


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

CATEGORIES

TAGS

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 partners Popdock promotions release SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training