topic Re: Error 404 Qlik application Automation - Copy data to Microsoft excel sheets in Qlik Automate

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

TaMahdi — Wed, 14 Sep 2022 14:03:28 GMT

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.

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

J_Lindberg — Thu, 15 Sep 2022 11:42:12 GMT

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.

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

AfeefaTk — Fri, 16 Sep 2022 04:46:20 GMT

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!!

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

TaMahdi — Fri, 16 Sep 2022 06:52:36 GMT

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!

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

TaMahdi — Sun, 18 Sep 2022 05:22:07 GMT

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.

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

J_Lindberg — Tue, 11 Oct 2022 08:37:09 GMT

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

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

TaMahdi — Wed, 12 Oct 2022 05:15:31 GMT

@J_Lindberg Yes I have.

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

J_Lindberg — Mon, 24 Oct 2022 07:39:38 GMT

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/1877410#M257

I'm attaching a solution for that as well.