Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
LIB CONNECT TO 'f2 (qliksense_sense_admin)';
RestConnectorMasterTable:
SQL SELECT
"content-disposition",
"pragma",
"Content-Length",
"Cache-Control",
"Content-Type",
"Date",
"Expires",
"Last-Modified",
"Set-Cookie",
"Server",
"status",
"strict-transport-security",
"x-access-level",
"x-connection-hash",
"x-content-type-options",
"x-frame-options",
"x-rate-limit-limit",
"x-rate-limit-remaining",
"x-rate-limit-reset",
"x-response-time",
"x-transaction",
"x-twitter-response-tags",
"x-xss-protection",
"__KEY__response_header",
(SELECT
"next_cursor",
"next_cursor_str",
"previous_cursor",
"previous_cursor_str",
"__KEY_root",
"__FK_root",
"@Value",
"__FK_ids"
FROM "ids" FK "__FK_ids" ArrayValueAlias "@Value")
FROM (wrap on) "root" PK "__KEY_root" FK "__FK_root")
FROM JSON "_response_header" PK "__KEY__response_header";
[ids]:
LOAD
1 AS [accountno],
[@Value] AS [valuee]
//[__FK_ids] AS [kKEY]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__FK_ids]);
DROP TABLE RestConnectorMasterTable;
LIB CONNECT TO 't22 (qliksense_sense_admin)';
2 AS [accountno],
The above script only shows table with account id 1
Not sure if that helps but I had a project where I need to loop thru embedded links without a table to get
more account.
Does your next_coursor represent a link?
Or any other field?
post your app.
