Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
epolitis
Contributor
Contributor

API does not load data when Task triggers

I have the following API script:

LIB CONNECT TO 'VesselsValue API (mmazuqliksense_qlik-accounting)';


RestConnectorMasterTable:
SQL SELECT
"total",
"__KEY_root",
(SELECT
"ship_id",
"ais_ship_id",
"ship_name",
"ship_imo",
"ship_type_name",
"valuation_market",
"valuation_demo",
"valuation_replacement",
"ship_build_date",
"ship_build_year",
"ship_build_month",
"ship_status",
"ship_size",
"ship_size_type",
"__FK_data"
FROM "data" FK "__FK_data")
FROM JSON (wrap on) "root" PK "__KEY_root";

[data]:
LOAD [ship_id],
[ais_ship_id],
APPLYMAP( 'COMPANY NAMEMapping',[ship_name]) AS [COMPANY_NAME],
[ship_imo],
[ship_type_name],
[valuation_market],
[valuation_demo],
[valuation_replacement],
[ship_build_date],
[ship_build_year],
[ship_build_month],
[ship_status],
[ship_size],
[ship_size_type],
ReloadTime() AS [valuation_date],
[__FK_data] AS [__KEY_root]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__FK_data]);


DROP TABLE RestConnectorMasterTable;

STORE [data] into [lib://QVDs (m-mar-qlksense_qlik-accounting)/data.qvd](qvd);

DROP TABLE [data];

 

And the following task:

epolitis_0-1678265514838.png

 

When the app is  open, it loads perfect. When it is not open, it does not load. Any suggestions?

epolitis_1-1678265609780.png

epolitis_2-1678265633760.png

 

 

Labels (1)
0 Replies