Skip to content

Data Visualization & API Delivery (Level 4)

6.1 Query To JSON (REST API)

Expose any Active query as a JSON REST endpoint — no deployment step required.

Navigate: Data Visualization → Query To JSON.

Query To JSON builder

The builder has two steps on a progress bar: Query Parameters → Result.

Step 1 — Select Query

Field Purpose
Query Name Dropdown of Active queries the current user can run.
Authorization Basic Authorization (username + password) or API Key (X-API-Key header).
User Name (Basic only) — the EQQ account that will execute the call.
Password (Basic only).
Row Index Optional — zero-based offset for paging.
Row Size Optional — page size; overrides the default.
Query More Code Optional — paging continuation token returned by a prior call.

Step 2 — Enter Query Parameters

Auto-generated table of every parameter declared in the query. Fill in Required values.

Step 3 — Generate Code Snippet

Click Generate Code Snippet to produce a working cURL command (importable into Postman via the linked help). Click Copy Code Snippet to put it on your clipboard.

Example snippet:

curl -X POST "https://eqq.ewarenow.com/api/query/execute/Demo_All_customers_and_the_items_they_ordered" \
  -H "X-API-Key: eqq_live_9f8c2a..." \
  -H "Content-Type: application/json" \
  -d '{"rowSize":100}'

Step 4 — Run Test API

Executes the call from the browser and shows the JSON response on the Result step. Use this to validate auth, parameters, and the JSON shape before handing the snippet to a developer.

Response paging

When a result exceeds a single page, the JSON includes a queryMoreCode field. Pass it back as Query More Code on the next call.

6.2 Query To Chart

Render any Active query as a chart (bar, line, pie, etc.).

Navigate: Data Visualization → Query To Chart.

Query To Chart builder

Three-step wizard: Query Parameters → Chart Configuration → Chart Result.

  1. Query Parameters — pick the query and supply inputs.
  2. Chart Configuration — on the next step EQQ auto-classifies columns as categorical or numeric. Choose chart type, X axis (categorical), Y axis (numeric), aggregation (Sum / Avg / Min / Max / Count), legend grouping, and color palette.
  3. Chart Result — live-rendered chart with download as PNG/SVG.

Embed (Extended Edition)

The chart result URL can be embedded in an iframe for portal integration. Token-based auth is supported so end users see live charts without a separate EQQ login. Contact info@ewarenow.com for setup details.