Integration Specifications

This article will help you learn about how Daasity replicates data from Okendo, limitations to the data we can extract, and where the data is stored in the Okendo schema

Integration Overview

Okendo is a product reviews platform for e-commerce brands. Our integration extracts and loads the contents of those reviews.

This document provides context on what kind of data is being gathered through this extractor, which endpoints that data is coming from, and how the extracted tables relate to each other.

Integration Availability

This integration is currently available for:

• Enterprise

API Endpoints

The Daasity Okendo extractor is built based on this Okendo API documentation. The following endpoints are used by Daasity to replicate data from Okendo:

• List Reviews

Okendo Schema

The Daasity Okendo extractor creates these tables using the endpoints and replication methods listed. The data is mapped from source API endpoint to the table based on the mapping logic outlined in each table.

• Reviews

Reviews

• Endpoint: List Reviews

• Update Method: UPSERT

• Table Name: [okendo.reviews]

JSON element	Database column	Notes
subscriberId	SUBSCRIBER_ID	Your user id within Okendo.
reviewId	REVIEW_ID	🔑 Foreign key
productId	PRODUCT_ID	The product ID prefixed by a platform identifier.
body	BODY	The content of the review.
containsProfanity	CONTAINS_PROFANITY	True if the title or body contain words on the profanity list, otherwise false.
dateCreated	DATE_CREATED
helpfulCount	HELPFUL_COUNT	The number of upvotes a review has received.
isRecommended	IS_RECOMMENDED
order.orderId	ORDER_ID
order.orderNumber	ORDER_NUMBER
rating	RATING	The number of stars a review has received.
reviewer.displayName	REVIEWER_DISPLAY_NAME	The full name entered by the reviewer with the last name truncated.
reviewer.isVerified	REVIEWER_IS_VERIFIED
reviewer.name	REVIEWER_NAME	The full name entered by the reviewer
reviewer.verifiedStatus	REVIEWER_VERIFIED_STATUS	Verified Buyer' if the reviewer could be connected to a valid order. 'Verified Reviewer' if the reviewer could not be connected to a valid order but verified their email address.
reviwer.email	REVIEWER_EMAIL
	ATTRIBUTES
reviewer.avatarUrl	AVATAR_URL
reviewer.socialConnection	SOCIAL_CONNECTION
	LOCATION
sentiment	SENTIMENT	The natural language sentiment of the review title and body.
status	STATUS	The moderation status of the review.
title	TITLE	The title of the review.
unhelpfulCount	UNHELPFUL_COUNT	The number of downvotes a review has received
variantId	VARIANT_ID	The id of the reviewed Shopify product variant.
variantName	VARIANT_NAME	The name of the reviewed Shopify product variant.
productName	PRODUCT_NAME
reply.body	REPLY_BODY	The html representation of the review reply.
reply.dateCreated	REPLY_DATE_CREATED
reply.rawBody	REPLY_RAW_BODY	The reply entered by the user. (Note: can include markdown syntax)
reply.isPrivate	REPLY_IS_PRIVATE	true if the reply is unpublished otherwise false
reward.description	DESCRIPTION
reward.integration	INTEGRATION
reward.type	TYPE
reward.value	VALUE
reward.isCouponUpgrade	IS_COUPON_UPGRADE
Daasity-generated	__FILENAME	NULL
Daasity-generated	__FILENAME_DATE	NULL
Daasity-generated	__SHOP_ID
Daasity-generated	_ACCOUNT_ID	Your Daasity account ID
Daasity-generated	__SYNC_KEY	🔑 Primary key MD5(reviewId + productId + body)
Daasity-generated	__SYNCED_AT	The UTC timestamp of when the data was loaded.
Daasity-generated	__INTEGRATION_ID	ID of the integration that loaded the data.

Review Media

• Endpoint: List Reviews

• Update Method: UPSERT

• Table Name: [okendo.review_media]

JSON elment	Database column	Notes
	LARGE_PORTRAIT_THUMBNAIL_URL
streamId	STREAM_ID
fullSizeUrl	FULL_SIZE_URL
largeUrl	LARGE_URL
	DYNAMIC_KEY
type	TYPE	Indicates whether the type of media is an image or a video
thumbnailUrl	THUMBNAIL_URL
isHidden	IS_HIDDEN
reviewId	REVIEW_ID	🔑 Foreign key
Daasity-generated	__FILENAME	NULL
Daasity-generated	__FILENAME_DATE	NULL
Daasity-generated	__SHOP_ID
Daasity-generated	_ACCOUNT_ID	Your Daasity account ID
Daasity-generated	__SYNC_KEY	🔑 Primary key MD5(streamId + reviewId)
Daasity-generated	__SYNCED_AT	The UTC timestamp of when the data was loaded.
Daasity-generated	__INTEGRATION_ID	ID of the integration that loaded the data.

Review Attributes With Rating

• Endpoint: List Reviews

• Update Method: UPSERT

• Table Name: [okendo.review_attributes_with_rating]

JSON element	DB column	Notes
attributesWithRating.minLabel	MIN_LABEL	The label for the leading edge of an attribute bar.
attributesWithRating.midLabel	MID_LABEL	The label for the midpoint of a centered-range attribute bar.
attributesWithRating.maxLabel	MAX_LABEL	The label for the trailing edge of an attribute bar.
attributesWithRating.title	TITLE	The title of the attribute.
attributesWithRating.type	TYPE
attributesWithRating.value	VALUE	The value selected on the attribute scale. For attribute of type 'range' this is between 1 and 5. For 'centered-range', between -1 and 1.
review_id	REVIEW_ID	🔑 Foreign key
Daasity-generated	__FILENAME	NULL
Daasity-generated	__FILENAME_DATE	NULL
Daasity-generated	__SHOP_ID
Daasity-generated	_ACCOUNT_ID	Your Daasity account ID
Daasity-generated	__SYNC_KEY	🔑 Primary key MD5(title + value + reviewId)
Daasity-generated	__SYNCED_AT	The UTC timestamp of when the data was loaded.
Daasity-generated	__INTEGRATION_ID	ID of the integration that loaded the data.

Review Product Attributes

• Endpoint: List Reviews

• Update Method: UPSERT

• Table Name: [okendo.review_product_attributes]

JSON element	DB column	Notes
productAttributes.title	TITLE	The title of the attribute.
productAttributes.type	TYPE
productAttributes.value	VALUE	The selected value(s) for the attribute. For types 'drop-down' and 'single-select' this is a single value. For type 'multi-select' it is an array.
reviewId	REVIEW_ID	🔑 Foreign key
Daasity-generated	__FILENAME	NULL
Daasity-generated	__FILENAME_DATE	NULL
Daasity-generated	__SHOP_ID
Daasity-generated	_ACCOUNT_ID	Your Daasity account ID
Daasity-generated	__SYNC_KEY	🔑 Primary key MD5(title + value + reviewId)
Daasity-generated	__SYNCED_AT	The UTC timestamp of when the data was loaded.
Daasity-generated	__INTEGRATION_ID	ID of the integration that loaded the data.