Knowi enables visualization, analysis, and reporting automation from your Judge.me product reviews data.

Connect your Judge.me account to pull reviews and product data into Knowi for analytics and dashboards - no manual exports or CSV files needed.

Overview

Connect directly to Judge.me using your Private API token and Shopify shop domain. Knowi handles authentication, pagination, and data extraction automatically.

Judge.me returns a reviews array in its responses. Knowi's Cloud9QL expand() function flattens this nested structure into tabular rows for easy analysis.

Prerequisites

You need two credentials to connect:

• Your Judge.me Private API Token (read/write, used server-side only - not the Public token).
• Your Shop domain in myshopify.com format (e.g., mystore.myshopify.com).

Find your Judge.me API credentials

1. From your Judge.me admin, go to Settings > Integrations.
2. Click the View API tokens button in the top right.

3. Copy your Private API Token. This token grants read/write access to your data and is used only on the server side.

   Note: Do not use the Public API Token - it only supports the public widget API. Knowi requires the Private token.

4. Note your Shop domain in myshopify.com format (shown on the same screen).

Connecting

1. Log in to Knowi and navigate to Queries from the left sidebar.
2. Click New Datasource (the + icon), then search for Judge.me in the datasource selector.

3. Fill in the form:

   a. Datasource Name: A label for this connection (e.g., "Judge.me Production")

   b. Shop Domain: Your Shopify store domain in myshopify.com format (e.g., mystore.myshopify.com)

   c. Private API Token: Paste the private token you copied above

4. Click Save to store the datasource.

Collections

After connecting, select a collection from the dropdown to query your Judge.me data.

Reviews

Retrieves all product reviews for your store, including rating, title, body, reviewer details, and publish status.

Optional Filters:

• Product ID - Internal Judge.me product ID (not the Shopify product ID). Use the Product Lookup collection to convert a Shopify product ID into the internal Judge.me ID. Leave blank for all products.
• Rating - Filter by star rating from 1 to 5. Leave blank for all ratings.
• Reviewer Email - Filter to a specific reviewer's email address.

Default Cloud9QL:

select expand(reviews);
select id, rating, title, body, reviewer.id as reviewer_id, reviewer.name as reviewer_name, reviewer.email as reviewer_email, product_external_id, verified, curated, hidden, created_at, updated_at order by created_at desc;

The expand(reviews) flattens the response so each review becomes its own row. Knowi pages through all reviews automatically and stops at the last page.

Product Lookup

Converts a Shopify product into its internal Judge.me product ID. The Reviews collection filters by the internal Judge.me product ID, so use this collection first to find that ID from your Shopify product ID.

Required Parameters:

• External (Shopify) Product ID - The Shopify product ID. The response includes the matching Judge.me product, including its internal id for use in the Reviews filter.

Default Cloud9QL:

select product.id as judgeme_product_id, product.external_id as shopify_product_id, product.handle, product.title, product.description, product.product_type;

Custom Endpoint

For power users who need to access any Judge.me API resource not covered by the predefined collections.

Required Parameters:

• Resource - The Judge.me API v1 resource path (e.g., reviews, widgets/product_review, products/-1).

Optional Parameters:

• Query Parameters - Additional query string parameters appended to the URL as-is (e.g., per_page=50&page=2&rating=5). The api_token and shop_domain are added automatically.

Refer to the Judge.me API documentation for available resources.

Querying

After selecting a collection, click Preview to see the data. Use the Cloud9QL editor to transform and filter the results.

Judge.me returns reviews in a reviews array. Common transformations:

• Flatten the response: select expand(reviews);
• Select specific fields: select id, rating, body, reviewer.name as reviewer_name;
• Filter by rating: select * where rating >= 4;
• Aggregate: select rating, count(*) group by rating;

Cross-Source Joins

Judge.me data becomes powerful when joined with other sources:

• Judge.me + Shopify: Join review ratings with order and product data to correlate reviews with sales.
• Judge.me + PostgreSQL: Combine reviews with your application database for deeper product analysis.
• Judge.me + Google Analytics: Correlate review activity with website behavior and conversions.

Use Knowi's multi-datasource joins to combine Judge.me with any of the 30+ supported data sources.

Scheduling

Once your query is configured, you can schedule it to run automatically (e.g., every hour, daily) to keep your dashboards up to date. Knowi handles pagination automatically - all pages are fetched until the data is complete.

Notes

• The Judge.me Private API token grants read/write access and is used only on the server side. It does not expire unless manually rotated.
• Authentication is passed as query parameters (api_token and shop_domain); the API host is fixed at https://api.judge.me/api/v1 and the store is identified by the shop domain.
• The Reviews collection uses page-number pagination (page, 100 per page). Knowi increments pages and stops at the last page automatically.
• Reviews created via the Judge.me API cannot be marked as verified, and the API response does not include video URLs or replies to reviews.
• Use select expand(reviews); in Cloud9QL to flatten the response structure.