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?