Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
From the above post I am able to trigger Nprinting task through Qliksense API.Now I am trying to create a dashboard to show all the task details along with execution status of the task whether running or completed or enqueue. I got a metadata table from which I can fetch all the task details time of creation,last execution etc but unable to get execution status.
The below code will fetch all the task details.
LIB CONNECT TO $(vAPIConnectionNameForGET); //exit script; let vEndpoint= vNPrintingServer & '/api/v1/tasks' ; RestConnectorMasterTable: SQL SELECT "__KEY_data", (SELECT "id", "name", "description", "type", "created", "lastUpdate", "lastExecution", "enabled", "appId", "__FK_items" FROM "items" FK "__FK_items") FROM JSON (wrap off) "data" PK "__KEY_data" with Connection (URL "$(vEndpoint)", HTTPHEADER "Cookie" "$(vCookie)"); [items]: LOAD [id] AS [id], [name] AS [name], [description] AS [description], [type] AS [type], [created] AS [created], [lastUpdate] AS [lastUpdate], [lastExecution] AS [lastExecution], [enabled] AS [enabled], [appId] AS [appId] RESIDENT RestConnectorMasterTable //WHERE NOT IsNull([__FK_items]) and [name]= $(vNPrintingPublishTaskName); WHERE NOT IsNull([__FK_items]); // and [id]= '$(vNPrintingPublishTaskID)';
Is there any other metadata table from where I can get execution status of all task? I can fetch individually execution status of a task but need the entire list.