Error 404 Qlik application Automation - Copy data to Microsoft excel sheets

[TaMahdi]

Hello,

I'm facing error 404 while running the automation, an excel file is already existing with the sheet to be deleted, however, I'm not sure the reason of the eror.

Please refer to the attached screenshots.

Qlik Application Automation OEM 

[J_Lindberg · Accepted solution]

The error indicates that the worksheet you are trying to delete doesn't exist. 

Try using the List Worksheets block to:

1. Ensure that the sheet you are trying to delete exists.

2. Ensure that the sheet name/id has been correctly provided to the Delete  Worksheets block.

[AfeefaTk]

Hi @TaMahdi 

In addition to @J_Lindberg  reply, you can even try using the do-lookup functionality of the 'Delete Worksheet' endpoint for all the input parameters and select the appropriate Drive Id, Item Id, Worksheet, etc to ensure you are passing correct values over all the input parameters

Thanks!!

[TaMahdi]

Thank you @J_Lindberg .

1. Its strange as the sheet already exists in the excel file with the exact name.

2. Will try to add List Worksheets block and see how it goes.

I'm also facing error 503- unknown error for some automation and not sure whats the cause of it!

[TaMahdi]

In similar automatons, I'm facing error 503 unknown error which I'm not quite sure about its cause. 

I also got an error of 401 general exceptions at the start of the automation run, appreciate your support to fix it.

[J_Lindberg]

@TaMahdi Do you have the required permissions to write to the drive and file?

[TaMahdi]

@J_Lindberg  Yes I have.

[J_Lindberg]

Hello @TaMahdi ,
I've set up an automation similar to yours that works, see attached automation.

In stead of looping over the output from the Get Straight Table Data, you could solve it using this approach:
https://community.qlik.com/t5/Qlik-Application-Automation/QAA-Update-Excel-rows-from-Table-Data/m-p/...

I'm attaching a solution for that as well.