@loginerror My bad, don’t know why i overlooked it and it makes sense, I came up with this as a temporary fix, devs should be able to implement this in the activity a bit cleaner
Here is the solution and it seems to work perfectly, considering going through the smallest amount of hoops and dances
First do a ‘Read Range’ into a DT created by the activity (in this case named AddToQueue)
Then setup the following
First ‘For Each’ is removing the period from column names (proberly other symbols should be removed? @loginerror )
Assign in first For Each loop:
column.ColumnName = Regex.Replace(column.ColumnName.ToString,“.”,“”)
Now copy the datatable as we cannot loop over and modify the same datatable
Then we go through the second ‘For Each’ it loops through columns from the temp datatable, extract the datatype as string, replaces the ‘System.’ in front of every datatype with # and adds that as the new odata column value in the original datatable referring back to the column name
Add Data Column
ColumnName:
column.ColumnName.ToString+“@odata.type”
DataTable:
AddToQueue
DefaultValue:
Regex.Replace(TempDT.Rows(0).Item(column.ColumnName).GetType.ToString,“System.”,“#”)
Now we have set the proper datatype for each column and we can send the data to an orchestrator queue with full UTF-8 support in Bulk Add
please pleas pleas update the Bulk add to do this by itself