topic Re: Qlik Cloud POST Reloads API returns "too many requests" in Integration, Extension & APIs

Qlik Cloud POST Reloads API returns "too many requests"

francesco_menin — Mon, 30 Sep 2024 19:14:28 GMT

Hi all,
I have an application on a customer's tenant that triggers the reload of a different app just before the end of script.

We're basically making a REST call to the API endpoint as per standard guide on qlik.dev, and we're getting this error at the same time we're triggering the reload on the app.

Invalid argument. (Connector error: HTTP protocol error 429 (Too Many Requests):

{"traceId":"dc04c017fc1c8087bdb00f9f17432c7a","errors":[{"code":"RELOADS-007","title":"Too many requests.","detail":"A pending reload request already exists for this app"}]})

It looks like the API call is triggered more than one time with the script (but we don't experience this issue with other apps).

What should we take a look at?

Re: Qlik Cloud POST Reloads API returns "too many requests"

marksouzacosta — Mon, 30 Sep 2024 19:31:12 GMT

Hi @francesco_menin,

Can you please share your Load Script and the how you setup your REST Connection?

Regards,

Mark Costa

Re: Qlik Cloud POST Reloads API returns "too many requests"

francesco_menin — Mon, 30 Sep 2024 19:46:46 GMT

of course, the script in the app itself is very simple, I'm just skipping some variable settings:

...

Load * from "$(pathQvd)*.qvd" (qvd);

Let vConnAPI = 'DataConnections:REST POST Reload';
Let vChildAppId = '<app_id>';

$(Must_Include=lib://$(Environment)_Setup:DataFiles/TriggerReload.qvs);

Call TriggerReload(vChildAppId,vConnAPI,pathReloadLog);

----

meanwhile the QVS script is a bit more complicated:

Sub TriggerReload(vChildAppId,vConnAPI,pathReloadLog) LIB CONNECT TO '$(vConnAPI)'; LET vQueryBody = '{""appId"":""$(vChildAppId)"",""partial"":false}'; // Collect data from the response for logging // Configure app ID for reload RestConnectorMasterTable: SQL SELECT "id", "appId", "tenantId", "userId", "type", "status", "creationTime", "__KEY_root" FROM JSON (wrap on) "root" PK "__KEY_root" WITH CONNECTION (BODY "$(vQueryBody)"); DisConnect; ReloadLog: NoConcatenate LOAD DISTINCT [id] AS [Reload ID], [appId] AS [Reload App ID], [tenantId] AS [Reload Tenant ID], [userId] AS [Reload User ID], [type] AS [Reload Type], [status] AS [Reload Status], [creationTime] AS [Reload Creation Time], DocumentName() AS [Reload Trigger App ID], DocumentTitle() AS [Reload Trigger App Name] RESIDENT RestConnectorMasterTable WHERE NOT IsNull([__KEY_root]); // Set variables to produce log filenames LET vReloadTime = Timestamp(Peek('Reload Creation Time',0),'YYYYMMDDhhmmss'); LET vReloadID = Peek('Reload ID',0); // Check to see if the reload request returned rows, and the variables carry data. If not, fail this reload If (NoOfRows('ReloadLog') <> 1) OR ('$(vReloadTime)' = '') OR ('$(vReloadID)' = '') THEN // Fail with an error for the log Call Error('An unexpected number of rows was returned by the reloads API, or invalid data was found.'); END IF; TRACE >>> Returned reload $(vReloadID) at $(vReloadTime); // Store logs and clear model STORE ReloadLog INTO [$(pathReloadLog)ReloadLog_$(vChildAppId)_$(vReloadID)_$(vReloadTime).qvd] (qvd); DROP TABLE ReloadLog; DROP TABLE RestConnectorMasterTable; End Sub