Yotpo V2
Yotpo ETL connector for data replication
Snapshot
Features | Details |
Release Status | Released |
Source API Version | v1, v3 |
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 | Products |
Questions | Collections |
ReviewMetadata |
Integrate Yotpo with Daton
Signin to Daton
Select Yotpo from Integrations page
Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
Provide your yotpo client id and yotpo client secret.
After providing the details to authorize Daton to periodically extract data from Yotpo.
Post successful authentication you will be prompted to choose from the list of available tables
Then select all required fields for each table
Submit the integration.
Workflow
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
Users would be able to edit/pause/re-activate/delete integration anytime
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.
Source API Documentation: https://apidocs.yotpo.com/reference/summary
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
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.
Source API Documentation: https://apidocs.yotpo.com/reference/retrieve-all-reviews
Replication: Full-Based Replication
Replication Key: NA
Fields
Name | Target Datatype |
id | NUMERIC |
title | STRING |
content | STRING |
score | NUMERIC |
votes_up | NUMERIC |
votes_down | NUMERIC |
created_at | TIMESTAMP |
updated_at | TIMESTAMP |
sentiment | NUMERIC |
sku | STRING |
name | STRING |
STRING | |
reviewer_type | STRING |
deleted | BOOLEAN |
archived | BOOLEAN |
escalated | BOOLEAN |
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.
Source API Documentation: https://apidocs.yotpo.com/reference/raw-data
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 | NUMERIC |
review_type | STRING |
email_sent_timestamp | TIMESTAMP |
opened_timestamp | TIMESTAMP |
review_form | STRING |
content_creation_timestamp | TIMESTAMP |
platform | STRING |
failed_timestamp | TIMESTAMP |
invalid_address_timestamp | TIMESTAMP |
coupon_code | STRING |
clicked_through_timestamp | TIMESTAMP |
unsubscribed_timestamp | TIMESTAMP |
marked_spam_timestamp | TIMESTAMP |
arrived_early_timestamp | TIMESTAMP |
DynamicCouponCodes
Purpose: Retrieves all Coupons created in yotpo System.
Source API Documentation: https://apidocs.yotpo.com/reference/retrieve-all-unique-coupon-codes
Replication: Full based Replication
Replication Key: NA
Fields
Name | Target Datatype |
code | STRING |
DynamicCouponCodeStatistics
Purpose: Retrieves all Coupons with statistics created in yotpo System.
Source API Documentation: https://apidocs.yotpo.com/reference/retrieve-unique-code-statistics
Replication: Full Based Replication
Replication Key: NA
Fields
Name | Target Datatype |
map_review | NUMERIC |
map_review_share | NUMERIC |
AllProducts
Purpose: Retrieves a list of all of your store's products.
Source API Documentation: https://core-api.yotpo.com/v1.0/reference/retrieve-all-products
Replication: Full Based Replication
Replication Key: NA
Fields
Name | Target Datatype |
id | NUMERIC |
created_at | TIMESTAMP |
updated_at | TIMESTAMP |
average_score | NUMERIC |
total_reviews | NUMERIC |
url | STRING |
external_product_id | STRING |
name | STRING |
description | STRING |
product_specs | RECORD |
category | RECORD |
images | RECORD |
blacklisted | BOOLEAN |
ProductGroups
Purpose: Retrieve product groups for account
Source API Documentation: https://core-api.yotpo.com/v1.0/reference/retrieve-product-groups-for-account
Replication: Full Based Replication
Replication Key: NA
Fields
Name | Target Datatype |
id | NUMERIC |
display_name | STRING |
account_id | NUMERIC |
WidgetSiteReviews
Purpose: Retrieves all widget site reviews
Source API Documentation: https://apidocs.yotpo.com/reference/retrieve-widget-site-reviews
Replication: Full-Based Replication
Replication Key: NA
Fields
Name | Target Datatype |
id | NUMERIC |
score | NUMERIC |
votes_up | NUMERIC |
votes_down | NUMERIC |
content | STRING |
title | STRING |
created_at | TIMESTAMP |
deleted | BOOLEAN |
verified_buyer | BOOLEAN |
sentiment | NUMERIC |
product_id | NUMERIC |
images_data | RECORD |
user | RECORD |
videos_data | RECORD |
UnSubscribers
Purpose: Retrieve a List of unsubscribers
Source API Documentation: https://apidocs.yotpo.com/reference/retrieve-a-list-of-unsubscribers
Replication: Full-Based Replication
Replication Key: NA
Fields
Name | Target Datatype |
id | NUMERIC |
user_email | STRING |
email_type_id | NUMERIC |
unsubscribed_by_name | STRING |
Products
Purpose: Retrieves a list of all of your store's products
Source API Documentation https://apidocs.yotpo.com/reference#retrieve-a-list-of-unsubscribers
Replication: Full-Based Replication
Replication Key: NA
Fields
| Name | Target Datatype |
|---|---|
yotpo_id | NUMERIC |
external_id | STRING |
name | STRING |
description | STRING |
status | STRING |
url | STRING |
is_valid_url | BOOLEAN |
image_url | STRING |
price | NUMERIC |
compare_at_price | NUMERIC |
currency | STRING |
inventory_quantity | NUMERIC |
is_discontinued | BOOLEAN |
group_name | STRING |
brand | STRING |
sku | STRING |
mpn | STRING |
gtins | RECORD |
custom_properties | RECORD |
created_at | DATETIME |
updated_at | DATETIME |
store_id | STRING |
is_valid_url_format | BOOLEAN |
handle | STRING |
external_created_at | DATETIME |
external_updated_at | DATETIME |
Questions
Purpose: Retrieve all Questions
Source API Documentation: https://apidocs.yotpo.com/reference#retrieve-a-list-of-unsubscribers
Replication: Full-Based Replication
Replication Key: NA
Fields
| NAME | TARGET DATATYPE |
|---|---|
id | NUMERIC |
content | STRING |
asker | RECORD |
user_type | STRING |
created_at | TIMESTAMP |
archived | BOOLEAN |
published | BOOLEAN |
allow_sent | BOOLEAN |
answers | RECORD |
products_app | RECORD |
Collections
Purpose: Retrieves a list of all store's collections.
Source API Documentation: https://apidocs.yotpo.com/reference#retrieve-a-list-of-unsubscribers
Replication: Full-Based Replication
Replication Key: NA
Fields
| NAME | TARGET DATATYPE |
|---|---|
yotpo_id | NUMERIC |
external_id | STRING |
name | STRING |
created_at | TIMESTAMP |
updated_at | TIMESTAMP |
ReviewMetadata
Purpose: Retrieve a review's order, customer, and product metadata
Source API Documentation: https://apidocs.yotpo.com/reference/get-review-metadata-by-review-id
Replication: Full-Based Replication
Replication Key: NA
Fields
| NAME | TARGET DATATYPE |
|---|---|
order | RECORD |
customer | RECORD |
product | RECORD |
Last updated