Bulk Add Queue Items write nonenglish values

@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 :slight_smile:

Here is the solution and it seems to work perfectly, considering going through the smallest amount of hoops and dances :rofl:

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

image
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 :sweat_smile:

1 Like