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 add-in 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 add-in.
- 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. |