Snippets
Retrieve, upsert, and delete the HTML snippet for a Square site. Keyed by SiteId from the Sites table. Requires filtering by SiteId.
Table Specific Information
Select
The connector uses the Square API to filter the results by the following columns and operators while the rest of the filter is executed client-side within the connector.
- SiteId supports the following operator: =.
Retrieve the snippet for a specific site:
SELECT * FROM Snippets WHERE SiteId = 'site_id_here'
Insert
To create or replace a snippet, you must specify the SiteId and Content columns.
INSERT INTO Snippets (SiteId, Content) VALUES ('site_id_here', '<p>Hello World</p>')
Delete
Delete the snippet for a site by providing the SiteId:
DELETE FROM Snippets WHERE SiteId = 'site_id_here'
Columns
| Name | Type | ReadOnly | Description |
| SiteId [KEY] | String | False |
The ID of the site that contains the snippet. Required for all operations and used as the URL path parameter. |
| Id | String | True |
The Square-generated ID of the snippet. |
| Content | String | False |
The HTML content of the snippet. This value is used as-is and injected into the site page. |
| CreatedAt | Datetime | True |
The timestamp when the snippet was created, in RFC 3339 format. |
| UpdatedAt | Datetime | True |
The timestamp when the snippet was last updated, in RFC 3339 format. |