Skip to main content

Connecting to Square

Overview 

Square is a financial service, merchant services aggregator, and mobile payments company. You can use Skypoint's built-in connector for importing data from Square.

This document will guide you through the process of connecting Square to Skypoint's Modern Data Stack Platform.

Prerequisite 

You must have following details to configure and import data using Square:

imageNote

You can refer to the Square Setup Guide document to learn more about the Prerequisites.

Import data using Square connector 

Follow below steps to create a new dataflow for Square import connector:

  1. Go to Dataflow > Imports.
  2. Click New Dataflow.

The Set dataflow name page appears. 

Alt text 

  1. Enter a Name to identify your Dataflow.

imageNote

Name starts with a letter.  Use letters and numbers only. No spaces between letters. 

  1. Click Next

Alt text

To add Square connector 

  1. In the Choose connector page, select Square connector.

imageNote

You can use the Search feature to find the connector. Also, the Square connector can be found under Ecommerce category.

Alt text

  1. Enter the Display Name to identify your Dataflow. 
  2. In the Description box, you can enter an explanation of the connector.  
  3. Click Next

Alt text

To configure Square

Follow the below steps to configure the connection to Square:

  1. Enter your credentials such as API Key and URL to configure with the Square connector.
  2. Click Connect

Alt text

  1. After configuration, you can enter the Table Details to process the data.

imageNote

In the Table Details column, you can mark only those fields that you want to import and process the data.

Item Description 
Purpose Option to assign a purpose (Data, Metadata) for each table. 
Data
Loads customer data. 
Metadata
Loads Metadata. 
NameDisplays the file name that you have imported. 
Table Name Displays the imported table name. 
  1. Click Save to apply the changes. 

Run, edit, and delete the imported data 

Once you save the connector, the Square connector gets displayed in the list of tables created in the Dataflow page. 

Alt text 

ItemDescription
Name Displays the name of the Dataflow. 
Type Displays connector type symbol. 
Status Indicates whether the data is imported successfully. 
Tables Count Displays the number of tables. 
Created Date Displays date of creation. 
Updated Date Displays last modified date. 
Last Refresh Displays the latest refresh date. This date will get updated whenever you refresh the data. 
Group by Option to view the items in a specific Group (For example, name, type, status). 
  • Select the horizontal ellipsis in the Actions column and do the following:
If you want toThen
Modify the Dataflow Select Edit and modify the Dataflow. Click Save to apply your changes.
Execute the Dataflow Select Run
Bring the data to its previous state Select Rollback
Delete the Dataflow Select Remove and then click the Delete button. All tables in the data source get deleted.
See the run history of the Dataflow Select Run History

imageNote

You can see the error message corresponding to failure while importing data from a data source in the Dataflow under Run history > Description