Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 RestConnectorMasterTableWHERE 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?