0 Replies Latest reply: Nov 30, 2016 7:17 AM by George Pimenov RSS

    Load root and elements in a one go from REST source

    George Pimenov

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