Best Practices

The following are some guidelines and recommendations that can help you optimize connector performance.

(missing or bad snippet)(missing or bad snippet)

Specify the Required Parameters when Inserting Data

For some tables in the Square data store, you must specify certain parameters in order to insert data successfully. For example, to successfully insert a timecard, you must provide the ID of the employee that the timecard corresponds to:

INSERT INTO Timecards (Employee_Id) VALUES ('EXP-12345678')

The following table lists the Square tables that require specific parameters when you insert data into them.

TableRequired Parameters

Categories

Name: The name of the category.

Discounts

Name: The name of the discount.

Fees

Both of the following parameters are required:

  • Name: The name of the fee.
  • Rate: The rate of the fee, as a string representation of a decimal number. For example, a value of 0.07 corresponds to a rate of 7%.

Pages

Page_Index: The position of the page in the list of pages. The value must be an integer between 0 and 4, inclusive. The endpoint returns an error if you specify a Page_Index that another page is already using.

Timecards

Employee_Id: The ID of the employee that you are creating a timecard for.