topic Re: Get Straight table data and loop object differences in Qlik Automate

Get Straight table data and loop object differences

random_user_3869 — Wed, 01 Feb 2023 09:34:02 GMT

Hello everyone,

In my workflow. I use :

I. My first block is list value of fields

II.GEt Straight Table Data (which contains 5 rows)

III.condition block

in my condition block i write : if list of value fields item = get straight data item field then true

true = the loop continue to the analyze the second row and so on

But what i notice is that the when the output from the result is false then the condition block doesn't continue to the second row and so on.

DO you have an idea why ?

Is that my workflow the issue ?

Re: Get Straight table data and loop object differences

AfeefaTk — Wed, 01 Feb 2023 10:10:03 GMT

Hi @random_user_3869

What are you doing in the condition block if the statement validates to false?

I could see an Error block attached in the false path. Maybe you are setting it to stop the automation and hence it's not iterating through the 2nd item from the Get Straight Table Data block.

It would be good if you could share the automation json file to confirm my above assumption

Thanks

Re: Get Straight table data and loop object differences

random_user_3869 — Wed, 01 Feb 2023 16:30:29 GMT

Here is the json file.

I have also another issue:

But i get a new error with the copy to sharepoint bloc also

Here is the detailed error log:

error:

Something went wrong while writing data to path General/2 - Applications Qlik/09 - Rapport PDF Automation/Recette/SOCIETE//DEC//DIC//Chiffres Clés - 01-02-23 - DIC: 81 - SANTOR - BAPTISTE GIROLET.pdf: Client error: `PUT https://graph.microsoft.com/v1.0/sites/ecfit.sharepoint.com,557080af-ecd5-42d5-bdd6-fb71d17e7227,eb6a14a8-b919-42ce-a2d7-0c7e623de387/drive/root:/General/2%20-%20Applications%20Qlik/09%20-%20Rapport%20PDF%20Automation/Recette/SOCIETE/DEC/DIC/Chiffres%20Cl%C3%A9s%20%20-%20%2001-02-23%20-%20DIC:%2081%20-%20SANTOR%20-%20BAPTISTE%20GIROLET.pdf:/createUploadSession` resulted in a `400 Bad Request` response: {"error":{"code":"BadRequest","message":"Resource not found for the segment 'root:'.","innerError":{"date":"2023-02-01T16:21:36","request-id":"3844ef20-3abc-40d8-9b42-986e5bd54231","client-request-id":"3844ef20-3abc-40d8-9b42-986e5bd54231"}}}

And i have another request also.

In my other automation in the copy block path i put the list of value field item as a string to create a subfolder in sharepoint:

But in my current automation i have the following code:

But the only thing that appeat is the text i wrote so basically the string written DEC/DIC..

I thought that i could use the get straight data item as it loops over to get the string name like list value item.

Do you know why it's not working ?

Thanks

Re: Get Straight table data and loop object differences

AfeefaTk — Thu, 02 Feb 2023 11:51:05 GMT

Hi @random_user_3869
Thanks for sharing the json file

For the 1st issue, where the Get Straight Table Data is not iterating through the 2 nd item if the condition is false, The Error block is set to continue the automation. So that might not be the cause

To dive deep into the issue, please share the per-block history of both Get Straight Table Data and condition blocks. Please share the automation run history by clicking on the Export Run button.

More details on how to get these details are explained here.

For the next issue, I see the "Copy File on SharePoint" block is not placed within the "Get Straight Table Data" block and it's outside the "Get Straight Table Data" block. You are trying to map each value from "Get Straight Table Data" block in the path which is not going to work as it's not added within the "Get Straight Table Data" block itself.

Thanks!

Re: Get Straight table data and loop object differences

renassol — Wed, 12 Jul 2023 20:24:12 GMT

The solution works well, however when I try to use a loop (List Values of Field) - to generate an excel of each value inside the loop it gives error. Could you verify ?

Error :