Schema Information

This subtopic provides a structured reference to assist you in working with Daton's Stamped.io connector and the associated fields and tables.

Tables/APIs

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

• Customers

• NetPromoterSources

• Products

• Questions

• Reviews

• Surveys

Customers

Creates, updates, and retrieves a list of customers of your store. For more information, see Stamped.io Customers.

Fields

Field Name	Data Type
customer	RECORD
countReviews	NUMERIC
countReferrals	NUMERIC
points	NUMERIC

NetPromoterSources

Retrieves your store's net promoter sources. For more information, see Stamped.io Net Promoter Sources.

Fields

Field Name	Data Type
nps	RECORD
customer	RECORD
orderId	STRING
voteUp	NUMERIC
voteDown	NUMERIC
tags	RECORD

Products

Retrieves your store's questions. For more information, see Products.

Fields

Field Name	Data Type
product	RECORD
dateLastReviewed	TIMESTAMP

Questions

Retrieves your store's questions. For more information, see Stamped.io Questions.

Fields

Field Name	Data Type
question	RECORD
customer	RECORD
voteUp	NUMERIC
voteDown	NUMERIC

Reviews

Retrieves your store's reviews sorted by search term, rating, review status, or specific date range. For more information, see Stamped.io Reviews.

Fields

Field Name	Data Type
review	RECORD
customer	RECORD
orderId	STRING
variant	STRING
voteUp	NUMERIC
voteDown	NUMERIC
countSocialShare	NUMERIC
topics	RECORD
isEdit	BOOLEAN
tags	RECORD

Surveys

Creates or retrieves a list of surveys. For more information, see Stamped.io Surveys.

Fields

Field Name	Data Type
id	NUMERIC
shopId	NUMERIC
email	STRING
firstName	STRING
lastName	STRING
fullName	STRING
location	STRING
phoneNumber	STRING
productId	STRING
productName	STRING
productUrl	STRING
productImageUrl	STRING
orderNumber	STRING
orderIdShopify	NUMERIC
orderCurrencyISO	STRING
orderTotalPrice	NUMERIC
orderSource	STRING
orderStatusUrl	STRING
reviewFormURL	STRING
state	NUMERIC
orderDate	TIMESTAMP
dateScheduled	TIMESTAMP
itemsList	RECORD
recommendationsList	RECORD
locale	STRING