Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

george_p
New Contributor II

Load root and elements in a one go from REST source

Is there way to retrieve root data and child data in one go? Example of the JSON in the screenshot. QlikSense generates request for child data only.

I have compiled load script manually, but this causes to retrieve data twice from REST source and makes load twice as slow.

Root data:

Totals:

SQL SELECT

  "count" as "cnt",

    "next_page",

    "end_time"

FROM JSON (wrap on) "root"

WITH CONNECTION(Url "https://xxx.zendesk.com/api/v2/incremental/tickets.json?start_time=$(startAt)");

Child data:

RestConnectorMasterTable:

SQL SELECT

  "url",

  "id" AS "id_u2",

  "external_id",

  "created_at",

  "updated_at",

  "type",

  "subject",

  "raw_subject",

  "description",

  "priority",

  "status",

  "recipient",

  "requester_id",

  "submitter_id",

  "assignee_id",

  "organization_id",

  "group_id",

  "forum_topic_id",

  "problem_id",

  "has_incidents",

  "is_public",

  "due_at",

  "brand_id",

  "allow_channelback",

  "generated_timestamp"

FROM JSON (wrap off) "tickets" PK "__KEY_tickets"

WITH CONNECTION(Url "https://xxx.zendesk.com/api/v2/incremental/tickets.json?start_time=$(startAt)");

Community Browser