JudgeMe

Snapshot

Features	Details
Release Status	Released
Source API Version	v1
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	OAuth using JudgeMe login
Replication Type	Full Load Replication Key Based Replication
Replication Key	Date
Suggested Replication Frequency	12 hrs

Integrate JudgeMe with Daton

1. Sign-in to Daton.

2. Select JudgeMe from the integrations page.

3. Provide Integration Name, Replication Frequency, and History. The integration name would be used in creating tables for the integration and cannot be changed later.

4. Click authenticate.

5. Enter your entire Shopify shop url. E.g: *storename*.myshopify.com

6. Post successful authentication, you will be prompted to choose from the list of available tables

7. Then select all required fields for each table

8. Submit the integration.

JudgeMe Tables

Source documentation: https://judge.me/api/docs#section/Authentication

1. Reviews

Purpose: To get all the reviews on JudgeMe. Replication: Full Replication Replication Key: NA

Fields

Field Name	Datatype
id	NUMERIC
title	STRING
body	STRING
rating	NUMERIC
product_external_id	NUMERIC
reviewer	RECORD
id	NUMERIC
external_id	NUMERIC
email	STRING
name	STRING
phone	STRING
accepts_marketing	BOOLEAN
unsubscribed_at	TIMESTAMP
tags	STRING
source	STRING
curated	STRING
hidden	BOOLEAN
verified	STRING
featured	BOOLEAN
created_at	TIMESTAMP
updated_at	TIMESTAMP
pictures	RECORD
ip_address	STRING
product_title	STRING
product_handle	STRING

2. Orders

Purpose: To get all your orders on JudgeMe. Replication: Incremental Replication Key: start date & end date

Fields

Field Name	Datatype
id	NUMERIC
name	STRING
fulfilled_at	TIMESTAMP
external_id	NUMERIC
reviewer_id	NUMERIC
fulfillment_status	STRING
cancelled_at	TIMESTAMP
country	STRING

3. Products

Purpose: To get all the products on JudgeMe. Replication: Full Load

Fields

Field Name	Datatype
id	NUMERIC
external_id	NUMERIC
title	STRING
handle	STRING
in_store	BOOLEAN
path	STRING
product_type	STRING
description	STRING
vendor	STRING
excluded	BOOLEAN
tags	STRING
mpns	STRING
barcodes	STRING
skus	STRING
lowest_price	STRING
highest_price	STRING
image_url	STRING
medium_image_url	STRING
small_image_url	STRING

4. LineItems

Purpose: To get all the Line item details for the orders on JudgeMe. Replication: Incremental (Dependent on orders table)

Fields

Field Name	Datatype
order_id	NUMERIC
order_name	STRING
order_external_id	NUMERIC
line_items	RECORD
id	NUMERIC
external_id	NUMERIC
status	STRING
price	STRING
quantity	NUMERIC
processed_at	TIMESTAMP
product_id	NUMERIC
product_external_id	NUMERIC