Generate data table from text activity but format all columns to STRING

Hello guys, i have a slight problem. I am generating a datatable from a text that is stored in a excel cell. When i generate the data table, some of the columns become a System.Int32, System.Decimal and it is bad, because I need to convert each rows value to a variable of string and put it in a API call. How can I format the table to string?
I get this trouble with columns from 1 to 5, because there will always be a random set of numbers in it.
The wizzard:


The errors:

Hi @Povilas_Jonikas

Try Uncheck auto detect column types in generate data table activity.
image

1 Like

Hi @Povilas_Jonikas

Try this

Row.item(“Column3”).Tostring

1 Like

Oh hello and thanks :slight_smile:

Just another quick question. To put these created varaibles to HTTP request body, i need to do like this?:

Thats an option 2, thanks a lot! :slight_smile:

@Povilas_Jonikas
If you got the solution.Please mark it as solution to close the loop

1 Like

Ok, done it. But could you please help me with one more thing? The variables that I created there are passed out to HTTP request body. How to put those variables corretly now? Because I keep getting an error:
image

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.