"Get Straight Table Data" does not read the table - Out: 0 items

[agardella]

Goodmorning, 

i have a problem with an automation for exporting data to csv file. This Qlik Sense Cloud istance is released by our mother company and i don't have a permission to edit the table and the app. I can create a data export automation  to connect our CRM. 

I use the "create file on FTP" and "Open file on FTP" for the CSV and then use the "Get Straight Table Data" and "Write Line To File on FTP" to write the data to the csv. That's fine in many situation but in one specific case "Get Straight Table Data" return 0 items e doesn't write any records to the csv file. 

In the "Object ID" i tried to choose all the options but can't get the result. I think that the correct object Id is "KQEBhbm - container - row 5 col 0" 

is the problem with the container? i can't modify the table e the settings.. can i solve it any method?

Thank you!

[random_user_3869 · Accepted solution]

Hello,

First of all you got to be sure that the object id of your object id is the right one.

To do that, in read mode you do right click on the straight table/Share/Integer then you get this view

and you see at the bottom the object id. In my case it's sYpBu.

In the automation/Object id you can past directly the object id. In my case you paste sYpBu without commas.

Then you can try a test run to see if there are datas.