Stamped.io

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

Stampedio API private key Stampedio API public key Stampedio 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