Yotpo
Yotpo 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
Yotpo Client Id Yotpo Client Secret
Replication Type
Key based Replication Full Replication
Replication Key
DATE NA
Suggested Replication Frequency
24 hrs
Tables/APIs Supported
Overview
Reviews
RawData
DynamicCouponCodes
DynamicCouponCodeStatistics
AllProducts
ProductGroups
WidgetSiteReviews
UnSubscribers

Integrate Yotpo with Daton

  1. 1.
    Signin to Daton
  2. 2.
    Select Yotpo from Integrations page
  3. 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. 4.
    Provide your yotpo client id and yotpo client secret.
  5. 5.
    After providing the details to authorize Daton to periodically extract data from Yotpo.
  6. 6.
    Post successful authentication you will be prompted to choose from the list of available tables
  7. 7.
    Then select all required fields for each table
  8. 8.
    Submit the integration.

Workflow

  1. 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. 2.
    Users would be able to edit/pause/re-activate/delete integration anytime
  3. 3.
    Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

Yotpo Data

Overview
Purpose: View a summary of all metrics as an itemized list for a specified email type.Data can be segmented by email type and grouped by various metrics.
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
email_type
STRING
start_date
DATE
end_date
DATE
answers_from_emails
NUMERIC
arrived_early
NUMERIC
click_throughs
NUMERIC
emails_failed
NUMERIC
emails_opened
NUMERIC
emails_sent
NUMERIC
invalid_address
NUMERIC
marked_spam
NUMERIC
reviews_from_emails
NUMERIC
unsubscribed
NUMERIC
Reviews
Purpose:Reviews are the core content generated using Yotpo. Yotpo helps generating reviews which can then later be displayed on the store's site and published on social networks.
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
id
INTEGER
title
STRING
content
STRING
score
NUMERIC
votes_up
NUMERIC
votes_down
NUMERIC
created_at
TIMESTAMP
updated_at
TIMESTAMP
sentiment
NUMERIC
sku
STRING
name
STRING
email
STRING
reviewer_type
STRING
deleted
BOOLEAN
user_reference
STRING
RawData
Purpose: Use this request to return detailed data about every email sent from Yotpo including the email recipient, when the email was received, order information, delivery success or failure, when the email was opened, clicks, unsubscribe, etc.
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
email_address
STRING
order_id
STRING
order_timestamp
TIMESTAMP
product_id
STRING
sku
STRING
email_type
STRING
reminder_num
STRING
trr_bundle_id
STRING
trr_bundle_subject
STRING
review_type
STRING
coupon_code
STRING
email_sent_timestamp
TIMESTAMP
opened_timestamp
TIMESTAMP
clicked_through_timestamp
TIMESTAMP
content_creation_timestamp
TIMESTAMP
review_form
STRING
platform
STRING
invalid_address_timestamp
TIMESTAMP
failed_timestamp
TIMESTAMP
unsubscribed_timestamp
TIMESTAMP
marked_spam_timestamp
TIMESTAMP
arrived_early_timestamp
TIMESTAMP
DynamicCouponCodes
Purpose: Retrieves all Coupons created in yotpo System.
Replication: Full based Replication
Replication Key: NA
Fields
Name
Target Datatype
code
STRING
DynamicCouponCodeStatistics
Purpose: Retrieves all Coupons with statistics created in yotpo System.
Replication: Full Based Replication
Replication Key: NA
Fields
Name
Target Datatype
map_review
NUMERIC
map_review_share
NUMERIC
AllProducts
Purpose: Use this endpoint to retrieves a list of all of your store's products.
Replication: Full Based Replication
Replication Key: NA
Fields
Name
Target Datatype
id
NUMERIC
created_at
TIMESTAMP
updated_at
TIMESTAMP
blacklisted
BOOLEAN
average_score
NUMERIC
total_reviews
NUMERIC
url
STRING
external_product_id
INTEGER
name
STRING
description
STRING
product_specs
RECORD
category
RECORD
images
RECORD
ProductGroups
Purpose: Retrieve product groups for account
Replication: Full Based Replication
Replication Key: NA
Fields
Name
Target Datatype
id
INTEGER
display_name
STRING
account_id
INTEGER
WidgetSiteReviews
Purpose: Retrieves all widget site reviews for yotpo system.
Replication: Full-Based Replication
Replication Key: NA
Fields
Name
Target Datatype
id
INTEGER
score
NUMERIC
votes_up
NUMERIC
votes_down
NUMERIC
content
STRING
title
STRING
sentiment
NUMERIC
created_at
TIMESTAMP
verified_buyer
BOOLEAN
product_id
INTEGER
user
RECORD
UnSubscribers
Purpose: Retrieve a List of unsubscribers for yotpo system.
Replication: Full-Based Replication
Replication Key: NA
Fields
Name
Target Datatype
id
INTEGER
user_email
STRING
email_type_id
NUMERIC
unsubscribed_by_name
STRING
Last modified 1yr ago