> For the complete documentation index, see [llms.txt](https://daton-sarasanalytics.gitbook.io/daton/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/saas-integrations/stamped.io/schema-information.md).

# Schema Information

## Tables/APIs 

The following is the list of tables or APIs associated with the Stamped.io connector:

* [Customers](#customers) 
* [NetPromoterSources](#netpromotersources) 
* [Products](#products) 
* [Questions](#questions) 
* [Reviews](#reviews) 
* [Surveys](#surveys)

#### Customers 

Creates, updates, and retrieves a list of customers of your store. For more information, see [Stamped.io Customers](https://developers.stamped.io/#f2d6d88e-ca87-43ca-966c-02f61ccbb0a1).

**Fields**

<table><thead><tr><th width="153">Field Name</th><th width="69">Data Type</th></tr></thead><tbody><tr><td>customer</td><td>RECORD</td></tr><tr><td>countReviews</td><td>NUMERIC</td></tr><tr><td>countReferrals</td><td>NUMERIC</td></tr><tr><td>points</td><td>NUMERIC</td></tr></tbody></table>

#### NetPromoterSources&#x20;

Retrieves your store's net promoter sources. For more information, see [Stamped.io Net Promoter Sources.](https://developers.stamped.io/#7db1d58c-51d1-4a3a-b492-f93168888b87)

#### Fields

<table><thead><tr><th width="153">Field Name</th><th width="69">Data Type</th></tr></thead><tbody><tr><td>nps</td><td>RECORD</td></tr><tr><td>customer</td><td>RECORD</td></tr><tr><td>orderId</td><td>STRING</td></tr><tr><td>voteUp</td><td>NUMERIC</td></tr><tr><td>voteDown</td><td>NUMERIC</td></tr><tr><td>tags</td><td>RECORD</td></tr></tbody></table>

#### Products&#x20;

Retrieves your store's questions. For more information, see [Products](https://developers.stamped.io/#adaa5c47-7f00-456c-a437-21504b93f3f0).

#### Fields

<table><thead><tr><th width="153">Field Name</th><th width="83">Data Type</th></tr></thead><tbody><tr><td>product</td><td>RECORD</td></tr><tr><td>dateLastReviewed</td><td>TIMESTAMP</td></tr></tbody></table>

#### Questions&#x20;

Retrieves your store's questions. For more information, see [Stamped.io Questions](https://developers.stamped.io/#3782f861-4ae1-42ea-b8ff-4f6ffcd15087).

**Fields**

<table><thead><tr><th width="153">Field Name</th><th width="69">Data Type</th></tr></thead><tbody><tr><td>question</td><td>RECORD</td></tr><tr><td>customer</td><td>RECORD</td></tr><tr><td>voteUp</td><td>NUMERIC</td></tr><tr><td>voteDown</td><td>NUMERIC</td></tr></tbody></table>

#### Reviews&#x20;

Retrieves your store's reviews sorted by search term, rating, review status, or specific date range. For more information, see [Stamped.io Reviews](https://developers.stamped.io/#da27f990-cabd-4882-864a-7b8f9dd55832).

#### Fields

<table><thead><tr><th width="153">Field Name</th><th width="69">Data Type</th></tr></thead><tbody><tr><td>review</td><td>RECORD</td></tr><tr><td>customer</td><td>RECORD</td></tr><tr><td>orderId</td><td>STRING</td></tr><tr><td>variant</td><td>STRING</td></tr><tr><td>voteUp</td><td>NUMERIC</td></tr><tr><td>voteDown</td><td>NUMERIC</td></tr><tr><td>countSocialShare</td><td>NUMERIC</td></tr><tr><td>topics</td><td>RECORD</td></tr><tr><td>isEdit</td><td>BOOLEAN</td></tr><tr><td>tags</td><td>RECORD</td></tr></tbody></table>

#### Surveys

Creates or retrieves a list of surveys. For more information, see [Stamped.io](https://developers.stamped.io/#da27f990-cabd-4882-864a-7b8f9dd55832) Surveys.

**Fields**

<table><thead><tr><th width="153">Field Name</th><th width="83">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>shopId</td><td>NUMERIC</td></tr><tr><td>email</td><td>STRING</td></tr><tr><td>firstName</td><td>STRING</td></tr><tr><td>lastName</td><td>STRING</td></tr><tr><td>fullName</td><td>STRING</td></tr><tr><td>location</td><td>STRING</td></tr><tr><td>phoneNumber</td><td>STRING</td></tr><tr><td>productId</td><td>STRING</td></tr><tr><td>productName</td><td>STRING</td></tr><tr><td>productUrl</td><td>STRING</td></tr><tr><td>productImageUrl</td><td>STRING</td></tr><tr><td>orderNumber</td><td>STRING</td></tr><tr><td>orderIdShopify</td><td>NUMERIC</td></tr><tr><td>orderCurrencyISO</td><td>STRING</td></tr><tr><td>orderTotalPrice</td><td>NUMERIC</td></tr><tr><td>orderSource</td><td>STRING</td></tr><tr><td>orderStatusUrl</td><td>STRING</td></tr><tr><td>reviewFormURL</td><td>STRING</td></tr><tr><td>state</td><td>NUMERIC</td></tr><tr><td>orderDate</td><td>TIMESTAMP</td></tr><tr><td>dateScheduled</td><td>TIMESTAMP</td></tr><tr><td>itemsList</td><td>RECORD</td></tr><tr><td>recommendationsList</td><td>RECORD</td></tr><tr><td>locale</td><td>STRING</td></tr></tbody></table>