topic Re: Block automation - copy file to sharepoint error in Qlik Automate

Block automation - copy file to sharepoint error

random_user_3869 — Mon, 19 Dec 2022 08:15:52 GMT

Hello everyone,

I have face the issue on the copy to sharepoint block ?

Anyone know how to correct this issue ?

Thanks

Re: Block automation - copy file to sharepoint error

Madhushree_BP — Mon, 19 Dec 2022 09:23:46 GMT

Hi @random_user_3869 ,

Could you please check if the source file input is passed with the correct filename?
Use the "Open file" block before the copy file block.

Thanks

Re: Block automation - copy file to sharepoint error

AfeefaTk — Mon, 19 Dec 2022 09:21:38 GMT

Hi @random_user_3869

Could you please share the screenshot of the input section that is being sent to the block?

I suspect the issue is with the 'Source File' input parameter, where you might be sending a null / incorrect value. As mentioned in the field description you should use the block "Open file" first and then select the file from this dropdown field as an input to the 'Source File' input parameter

Also if you could share the whole workflow, maybe a screenshot or automation JSON file would help us further troubleshoot the issue

Thanks!

Afeefa TK

Re: Block automation - copy file to sharepoint error

random_user_3869 — Mon, 19 Dec 2022 09:38:47 GMT

Hello everyone,

Here is the screenshot

Re: Block automation - copy file to sharepoint error

random_user_3869 — Mon, 19 Dec 2022 09:42:39 GMT

Hello,

I don't really understand what you say by using the open file on microsoft sharepoint first.

I usually generate report then copy the output file to the sharepoint.

By placing open file in beetween what i understand is that this block will search a file in sharepoint folder.

And what i want is :

1. Generate the report

2. Use the output from 1 and copy it to sharepoint

Re: Block automation - copy file to sharepoint error

AfeefaTk — Mon, 19 Dec 2022 09:59:24 GMT

Hi @random_user_3869

Sorry for the confusion here
If you are using the "Generate Report" block, you can exclude the "Open file" block from the workflow.

You can simply select the "Generate Report" block output from the dropdown of the 'Source File' input parameter and that should work

Thanks!

Re: Block automation - copy file to sharepoint error

AfeefaTk — Mon, 19 Dec 2022 11:34:07 GMT

Hi @random_user_3869

From the screenshot you have shared, As mentioned before I see the source input parameter value is null because of which you are getting some error

What is the output from the "Generate Report" block?

Are you able to see the "Generate Report" block as a dropdown in the "Source File" input parameter

Thanks!

Re: Block automation - copy file to sharepoint error

random_user_3869 — Mon, 19 Dec 2022 15:40:38 GMT

Hello,

Here is the json.

Thank you.

Because i don't understand at to process the issue

Re: Block automation - copy file to sharepoint error

AfeefaTk — Tue, 20 Dec 2022 07:56:36 GMT

Hi @random_user_3869

Thanks for sharing JSON file

It seems you have properly mapped the Generate Report block to the Source file input parameter.

Could you please send screenshot from the chronological overview that contains both the inputs & the outputs of the Generate Report block?

Something like this :

It seems you have set the automation to continue and ignore errors for Generate Report block. It could be worth checking if the 'Generate Report' block itself is failing, hence causing Copy file block to fail

In order to stop automation if the block fails, change the 'On error' settings of Generate Report block and select option "Stop - Stop Automation and set to failed"

Please let me know if this helps to identify the issue

Thanks!

Re: Block automation - copy file to sharepoint error

AfeefaTk — Tue, 20 Dec 2022 08:51:10 GMT

Hi @random_user_3869

Adding to my previous comment
If you are still not able to point out the root cause, Could you please share failed job run log file

You can get it by navigating to specific failed job run history, click on the Export this run button, save it as JSON file and share the JSON file

Thanks!