How to connect Square with SharePoint

This documentation describes how to set up your Layer2 Cloud Connector to synchronize data stored in Square with a SharePoint online list in Office 365.


1. Configuring Square

Go to your Square developer account https://squareup.com and create an app.

 

Square app creation

 

Give your application a name:

 

Square app name

 

Square app id and token

 

Copy your Personal Access Token. We are going to use it in the Layer2 Cloud Connector. You can also use the OAuth to generate a client id in order to use the OAuth flow to authenticate.


2. Configuring the Layer2 Cloud Connector

2.1. Creating a new connection

We are going so synchronize our Square to a custom SharePoint list. 

Your initial synchronization should always be uni-directional to assure that both data entities are identical before switching to bi-directional syncs.

Create a new connection in the Layer2 Cloud Connector, name it and set the direction to uni-directional. 

 

Step 1 Square connection setup uni

 

 

2.2. Configuring the start system

Select the provider for Square.

Select the source system and name it.

 

Source setup for Square integration in the Layer2 Cloud Connector

 

Set the connection string with the parameters from your Square app.

 

Connection string setup for Square data integration in the Layer2 Cloud Connector

 

Connection String:

 

OAuthAccessToken=your_token;InitiateOAuth=GETANDREFRESH;

 

The Select statement:

 

SELECT * FROM Items;

 

Set your primary key too. 

If everything runs fine you will be prompted to login and your data will be visible after.

 

Preview data of Square integration in the Layer2 Cloud Connector

 

2.3. Configuring the end system

We are going to send the data to a custom SharePoint list. Create the list first with the desired columns and copy the URL.

For more information about the SharePoint provider visit:

https://www.layer2solutions.com/support/cloud-connector-faqs/layer2-csom-sharepoint-ado-net-provider.

 

Target setup for Square integration in the Layer2 Cloud Connector

 

Connection string:

 

URL=https://your_custom_sharepoint_list_url/AllItems.aspx;Authentication=Office365;User=User@domain.com;

 

Enter your password in the dedicated field and a primary key.

If the fields from SharePoint are named identical to the fields from the source system, the auto-mapping function will match appropriate columns. We mapped our fields manually in this case.

 

Mapping in the Layer2 Cloud Connector for Square data integration

 

2.4. Running your connection

You can now run your connection.

 

Start the data integration of Square

 

Data overview on the Square entity.

 

Data of Square ready for integration with SharePoint

 

And the transferred data to our custom SharePoint list.

 

Finished data integration of Square.

3. Hints and known issues

3.1. Data model

To see all the tables and views you can access with the Square provider, use these queries in the Select statement:


SELECT * FROM sys_tables

 

SELECT * FROM sys_views

 

If there are more tables or views available, you can load them with the option "load more" in the popup window.

3.2. Connection direction

As far as tested, the connection direction supports uni-directional as well as be bi-directional synchronizations. 


3.3. Batch operations

If you try to make multiple operations at the same time, you can get the error batch operations not allowed. Set the parameter Other=’BatchSize=1’ in your connection string to avoid this error. 

↑Top

Search for more data integration & synchronization solutions

Icon of Contact us - Chat - Layer2 leading solutions

Questions?

Contact us directly to discuss your specific requirements, help you with purchasing, or with any other questions.

 

Icon for Layer2 Solutions Finder- Layer2 leading solutions

About the Layer2 Cloud Connector

Get more information about the Layer2 Cloud Connector on the product page.

 

 

Icon for Layer2 Solutions Finder- Layer2 leading solutions

Try it out for 15 days

Get a free trial of the Layer2 Cloud Connector after a short registration.