PULL FROM QRS API USING WITH CONNECTION

phillgilchrist — Fri, 13 Aug 2021 18:54:41 GMT

Hi...

Trying to pull from QRS API using WITH CONNECTION call as below...

When doing the reload, it pulls the expected number of rows, but not pulling the dimensions as expected.

So KEY shows 1-368 but id & createdDate are null...

Any pointers greatfully received.

RestConnectorMasterTable:
SQL SELECT
"__KEY_root",

(SELECT
  "id",
  "createdDate",
        "type",
        "connectionstring",
  "__FK_items"
FROM "items" FK "__FK_items")
FROM JSON (wrap off) "root" PK "__KEY_root"
WITH CONNECTION(
URL "https://QLIKSERVER/qrs/dataconnection",
HTTPHEADER "X-Qlik-xrfkey" "12345678qwertyui",
QUERY "xrfkey" "12345678qwertyui"
);
;

Re: PULL FROM QRS API USING WITH CONNECTION

Levi_Turner — Mon, 24 Feb 2020 15:18:20 GMT

GET /qrs/dataconnnection does not have the createDate element but GET /qrs/dataconnection/full does.

Example script:

Let vDataConnection = 'monitor_apps_REST_app'; LIB CONNECT TO '$(vDataConnection)'; RestConnectorMasterTable: SQL SELECT "id" AS "id_u2", "createdDate" AS "createdDate_u0", "connectionstring", "type", "__KEY_root" FROM JSON (wrap on) "root" PK "__KEY_root" WITH CONNECTION( URL "https://localhost/qrs/dataconnection/full", HTTPHEADER "X-Qlik-xrfkey" "12345678qwertyui", QUERY "xrfkey" "12345678qwertyui" ); [dataconnections]: LOAD [id_u2] AS [id], [createdDate_u0] AS [createddate], [connectionstring], [type], [__KEY_root] RESIDENT RestConnectorMasterTable WHERE NOT IsNull([__KEY_root]); DROP TABLE RestConnectorMasterTable;

topic Re: PULL FROM QRS API USING WITH CONNECTION in Integration, Extension & APIs

PULL FROM QRS API USING WITH CONNECTION

Re: PULL FROM QRS API USING WITH CONNECTION