REST (API) Data Retrieval in Qlik Sense Desktop

แชร์
ฝัง
  • เผยแพร่เมื่อ 3 ธ.ค. 2024

ความคิดเห็น • 2

  • @sumitakhandual4504
    @sumitakhandual4504 ปีที่แล้ว +2

    How to pass access token dynamically in qliksense rest api connection

    • @mahammadyagubli1578
      @mahammadyagubli1578  ปีที่แล้ว +1

      Sure, Using With Connection You can achieve. as example:

      ElementsToLoad:
      Load * inline [
      ElementID
      12fa91
      1sy293
      h13d13

      ];
      Let j=0;
      for j = 0 to 99
      Let vElementID = peek('ElementID', $(j), 'Teams');
      RestConnectorMasterTable:
      SQL SELECT
      fields
      FROM "datad")
      FROM JSON (wrap on) "root" PK "__KEY_root"
      WITH CONNECTION(Url "www.domain.com/element?key=$(vElementID)/more_stuff/");
      NEXT j;
      DROP TABLE RestConnectorMasterTable;
      exit Script;