# 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                | <p>Full Load Replication<br>Key Based Replication</p> |
| 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**&#x20;

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

**Fields**

<table data-header-hidden><thead><tr><th width="247"></th><th></th></tr></thead><tbody><tr><td><strong>Field Name</strong></td><td><strong>Datatype</strong></td></tr><tr><td>id</td><td>NUMERIC</td></tr><tr><td>title</td><td>STRING</td></tr><tr><td>body</td><td>STRING</td></tr><tr><td>rating</td><td>NUMERIC</td></tr><tr><td>product_external_id</td><td>NUMERIC</td></tr><tr><td>reviewer</td><td>RECORD</td></tr><tr><td>id</td><td>NUMERIC</td></tr><tr><td>external_id</td><td>NUMERIC</td></tr><tr><td>email</td><td>STRING</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>phone</td><td>STRING</td></tr><tr><td>accepts_marketing</td><td>BOOLEAN</td></tr><tr><td>unsubscribed_at</td><td>TIMESTAMP</td></tr><tr><td>tags</td><td>STRING</td></tr><tr><td>source</td><td>STRING</td></tr><tr><td>curated</td><td>STRING</td></tr><tr><td>hidden</td><td>BOOLEAN</td></tr><tr><td>verified</td><td>STRING</td></tr><tr><td>featured</td><td>BOOLEAN</td></tr><tr><td>created_at</td><td>TIMESTAMP</td></tr><tr><td>updated_at</td><td>TIMESTAMP</td></tr><tr><td>pictures</td><td>RECORD</td></tr><tr><td>ip_address</td><td>STRING</td></tr><tr><td>product_title</td><td>STRING</td></tr><tr><td>product_handle</td><td>STRING</td></tr></tbody></table>

**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      |