Stamped.io v1

Stamped.io ETL connector for data replication

Snapshot

Features	Details
Release Status	Released
Source API Version	v2
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	Stamped.io API private key Stamped.io API public key Stamped.io store hash
Replication Type	Key Based Incremental Full Replication
Replication Key	Date
Suggested Replication Frequency	24 hrs

Tables/APIs Supported
reviews	questions
net promoter scores	surveys
unsubscribe

Integrate Stampedio with Daton

1. Signin to Daton

2. Select Stampedio from Integrations page

3. Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later

4. Provide your api public key, api private key and store hash from your stampedio account to authorize Daton to periodically extract data from stampedio.

5. Post successful authentication, you will be prompted to choose from the list of available tables

6. Then select all required fields for each table

7. Submit the integration

Workflow

1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

2. Users would be able to edit/pause/re-activate/delete integration anytime

3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

STAMPEDIO Data

Reviews

Purpose: Returns all the reviews created for a product.

Source API Documentation https://developers.stamped.io/?version=latest#1e9fc214-5b59-40a0-9a7b-1030fbaef679

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name	Target Datatype
id	NUMERIC
reviewState	NUMERIC
rating	NUMERIC
title	STRING
author	STRING
email	STRING
location	STRING
countryISO	STRING
imagesFileName	STRING
imagesFileNamePublished	STRING
videosFileName	STRING
videosFileNamePublished	STRING
body	STRING
reply	STRING
productId	NUMERIC
productHandle	STRING
productTitle	STRING
productUrl	STRING
productImageUrl	STRING
productImageCroppedUrl	STRING
productImageThumbnailUrl	STRING
sentimentScore	STRING
sentimentMagnitude	STRING
source	NUMERIC
reviewSource	STRING
ipAddress	STRING
ipAddressSource	STRING
userReference	STRING
isPublishedShopify	BOOLEAN
isConvertedImage	BOOLEAN
isPublicReply	BOOLEAN
isFeatured	BOOLEAN
isRead	BOOLEAN
isPublishedFeed	BOOLEAN
isRecommend	BOOLEAN
queueReviewEmailID	STRING
customerId	STRING
shopProductId	NUMERIC
reviewSourceAppId	STRING
reviewSourceAppEntityId	STRING
shop_ID	NUMERIC
verifiedType	NUMERIC
dateCreated	STRING
dateReplied	STRING
dateAdded	STRING
reviewMediaList	STRING
reviewOptionsList	STRING
reviewVotesList	STRING
reviewSocialSharesList	STRING
tagsList	STRING
sentimentAnalysisReviewList	STRING
isPublished	STRING

Questions

Purpose: Returns a list of the questions asked.

Source API Documentation https://developers.stamped.io/?version=latest#16828688-5ce6-482b-9444-d9772a243762

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name	Target Datatype
question	RECORD
questionEmailsList	RECORD
customer	RECORD
voteUp	NUMERIC
voteDown	NUMERIC
tags	STRING

NetPromoterScores

Purpose:Returns all the net promoter scores

Source API Documentation https://developers.stamped.io/?version=latest#d18ca11d-356a-4da9-8dd6-a84be64400d0

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name	Target Datatype
id	NUMERIC
rating	NUMERIC
body	STRING
reply	STRING
state	NUMERIC
surveySource	STRING
shopProductId	STRING
ipAddress	STRING
customerId	STRING
queueReviewEmailId	STRING
isRead	BOOLEAN
isFeatured	BOOLEAN
shop_ID	NUMERIC
shopProduct	STRING
verifiedType	STRING
dateCreated	STRING
dateAdded	STRING
dateReplied	STRING
tagsList	STRING
customer	STRING
orderId	STRING
voteUp	NUMERIC
voteDown	NUMERIC
tags	STRING

Surveys

Purpose:Returns all the surveys

Source API Documentation https://developers.stamped.io/?version=latest#141ce8d5-e9a2-42eb-b27e-9af7e688f4d7

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
id	NUMERIC
email	STRING
firstName	STRING
lastName	STRING
fullName	STRING
location	STRING
locationCity	STRING
locationState	STRING
customerId	STRING
productId	STRING
productName	STRING
productUrl	STRING
productImageUrl	STRING
orderNumber	STRING
orderId	STRING
orderIdShopify	STRING
orderCurrencyISO	STRING
orderTotalPrice	NUMERIC
orderSource	STRING
orderStatusUrl	STRING
reviewFormURL	STRING
couponCode	STRING
subscribed	STRING
review	STRING
npsRating	STRING
reviewId	STRING
orderDate	STRING
orderDateFulfilled	STRING
dateScheduled	STRING
dateOpened	STRING
dateSent	STRING
dateSentReminder	STRING
dateScheduledNPS	STRING
dateOpenedNPS	STRING
dateSentNPS	STRING
dateReviewedNPS	STRING
dateScheduledSet	STRING
itemsList	RECORD
recommendationsList	RECORD

Unsubscribe

Purpose:Gives out the details of all the unsubscribers.

Source API Documentation https://developers.stamped.io/?version=latest#b0753b9e-8942-4d84-ba57-9f7bab8fa395

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
id	NUMERIC
email	STRING
fromQuestionId	STRING
fromReviewEmailId	STRING
dateUnsubscribed	STRING