Yotpo Extractor Documentation

Yotpo is a product review platform. Yotpo provides a “sentiment” score by crawling the review text and scoring it with a score of 1% - 100%. The Daasity<>Yotpo Integration makes review info by SKU available to users for analysis.

Key Topics

Integration Availability

This integration is available for:

  • Growth
  • Pro V1 & V2 (Merchants with their own dedicated Looker instance)

ERD

 Yotpo Extractor Info

ENDPOINTS

Retrieve All Reviews  https://apidocs.yotpo.com/reference#retrieve-all-reviews 
Retrieve Orders from the Yotpo System   https://apidocs.yotpo.com/reference#retrieve-orders-from-the-yotpo-system 

RETRIEVE ALL REVIEWS

JSON Element 

Database Colum 

id 

id  

title 

title  

content 

content  

score 

score  

votes_up 

votes_up 

votes_down 

votes_down  

created_at 

created_at  

updated_at 

updated_at  

sentiment 

sentiment 

sku 

sku  

name 

name  

email 

email  

reviewer_type 

reviewer_type  

deleted 

deleted 

user_reference 

user_reference 

__source_id 

Unique id (entered by customer) during integration setup 


Incremental data extraction.

Use the since_updated_at for earliest update date of returned reviews.  


Historical data extraction.

Use since_date to extract history to get earliest creation date of returned reviews. 


Sync Key - to prevent duplicate data entries.

MD5(id:__source_id) 

RETRIEVE ALL ORDERS

 

JSON Element 

Database Colum 

Order_id 

Order_id  

Order_line_id 

Order_line_id 

Order_date 

Order_date 

Product_id 

Product_id 

User_email 

User_email 

User_name  

User_name  

Product_name 

Product_name 

Product_sku 

Product_sku 

Product_url 

Product_url 

Product_description 

Product_description 

Created_at 

Created_at 

__Source_id 

Unique id (entered by customer) during integration setup 


Incremental data extraction. 

Use since_date filter to get only records that have been created_at after date parameter. 


Sync Key - to prevent duplicate data entries. 

MD5(order_id:order_line_id:order_date:created_at:__source_id) 


All contents copyright of Daasity, Inc. 2021.