Load root and elements in a one go from REST source

[Anonymous]

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)");