Automation In Qlik Cloud Analytics

[Raju_6952]

Hi,

I am using one of of the automation as a task chain where I have configured with 30 app reloads in a single automation but the problem is its getting timed out at 4 hrs. so planning to split the automation into two parts like 15 and 15.My idea here is that my second automation would triggered based on the first automation run is successful.

Any suggestions would be highly appreciated.

Regards,

Raju

[tolange]

Hi Raju, 

you would need to use the actual character "🔄", not the Qlik community version with the :name:. You may also just remove the character completely.

As for "can you explain this deeper or share any community article which helps us in setting the process flow." -> I will consider doing this once I have some time on my hands.

[Raju_6952]

Hi @tolange ,

Thanks for the hint but even after removing that still some error.

Regards,

Raju

[marksouzacosta · Accepted solution]

Hi @Raju_6952,

This is the reviewed and tested code:

SUB ReloadApp(AppID)

    TRACE Starting reload for AppID: $(AppID);

    // Create JSON body with AppID
    LET vJSONBody = '{""appId"":""$(AppID)"",""partial"":false}';
    
    LIB CONNECT TO 'ReloadsAPI';
   
    // Make API call to trigger app reload
    REST_Reload:
    SQL SELECT 
        "id"
    FROM 
        JSON (wrap on) "root"
        WITH CONNECTION (
            BODY "$(vJSONBody)"
        )
    ;
    
    // Capture the reload ID from API response
    LET vReloadID = Peek('id', 0, 'REST_Reload');

    // Log success or failure
    IF Len(Trim('$(vReloadID)')) > 0 THEN
    	TRACE Reload triggered successfully for AppID: $(AppID), Reload ID: $(vReloadID);
    ELSE
    	TRACE Reload failed for AppID: $(AppID);
    ENDIF
    
END SUB

Call ReloadApp('45bdff00-c8cf-41ca-8738-6ec27928c31e'); // The AppID of the next Application

This is my ReloadsAPI Connection - just for your review.
The green arrows indicates where I made changes.

Regards,

Mark Costa

[Raju_6952]

Hi @marksouzacosta ,

Many thanks for sharing the code and connection parameters.

Its working for me now.

Thanks again for your great help.

Regards,

Raju

[marksouzacosta]

You are welcome @Raju_6952