API does not load data when Task triggers

epolitis — Mon, 26 Jan 2026 18:19:17 GMT

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:

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

topic API does not load data when Task triggers in QlikView

API does not load data when Task triggers