Integration Specifications

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

Integration Overview

Junip 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 Junip extractor is built based on this Junip API documentation. The following endpoints are used by Daasity to replicate data from Junip:

• List Products

• List Product Overviews

• List Product Reviews

• List Stores

• List Store Reviews

Junip Schema

The Daasity Junip 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.

• Products

• Product Overviews

• Product Reviews

• Stores

• Store Reviews

Products

• Endpoint: List Products

• Update Method: UPSERT

• Table Name: [junip.products]

JSON Element	Database Column
id	id
created_at	created_at
deleted_at	deleted_at
rating_average	rating_average
rating_count	rating_count
rating_distribution.1	rating_distribution__1
rating_distribution.2	rating_distribution__2
rating_distribution.3	rating_distribution__3
rating_distribution.4	rating_distribution__4
rating_distribution.5	rating_distribution__5
recommended_percentage	recommended_percentage
recommended_count	recommended_count
published	published
remote_handle	remote_handle
remote_id	remote_id
title	title
unreviewable	unreviewable
updated_at	updated_at
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
MD5(id)	__sync_key

Product Overviews

• Endpoint: List Product Overviews

• Update Method: UPSERT

• Table Name: [junip.product_overviews]

JSON Element	Database Column
id	id
created_at	created_at
rating_average	rating_average
rating_count	rating_count
rating_distribution.1	rating_distribution__1
rating_distribution.2	rating_distribution__2
rating_distribution.3	rating_distribution__3
rating_distribution.4	rating_distribution__4
rating_distribution.5	rating_distribution__5
recommended_percentage	recommended_percentage
recommended_count	recommended_count
updated_at	updated_at
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
MD5(id)	__sync_key

Product Reviews

• Endpoint: List Product Reviews

• Update Method: UPSERT

• Table Name: [junip.product_reviews]

JSON Element	Database Column
id	id
body	body
created_at	created_at
customer_id	customer_id
down_vote_count	down_vote_count
featured	featured
origin	origin
product_id	product_id
rating	rating
response	response
rewarded	rewarded
target_title	target_title
title	title
up_vote_count	up_vote_count
updated_at	updated_at
verified_buyer	verified_buyer
would_recommend	would_recommend
edited_at	edited_at
photo_urls	photo_urls
video_urls	video_urls
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
MD5(id)	__sync_key

Stores

• Endpoint: List Stores

• Update Method: UPSERT

• Table Name: [junip.stores]

JSON Element	Database Column
id	id
created_at	created_at
key	key
name	name
rating_average	rating_average
rating_count	rating_count
rating_distribution.1	rating_distribution__1
rating_distribution.2	rating_distribution__2
rating_distribution.3	rating_distribution__3
rating_distribution.4	rating_distribution__4
rating_distribution.5	rating_distribution__5
recommended_percentage	recommended_percentage
recommended_count	recommended_count
slug	slug
updated_at	updated_at
url	url
use_new_events	use_new_events
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
MD5(id)	__sync_key

Store Reviews

• Endpoint: List Store Reviews

• Update Method: UPSERT

• Table Name: [junip.store_reviews]

JSON Element	Database Column
id	id
body	body
created_at	created_at
customer_id	customer_id
down_vote_count	down_vote_count
featured	featured
origin	origin
rating	rating
response	response
rewarded	rewarded
target_title	target_title
title	title
up_vote_count	up_vote_count
updated_at	updated_at
verified_buyer	verified_buyer
would_recommend	would_recommend
edited_at	edited_at
photo_urls	photo_urls
video_urls	video_urls
Daasity-generated	_account_id
Daasity-generated	__integration_id
Daasity-generated	__synced_at
Daasity-generated	__shop_id
MD5(id)	__sync_key