Add this code to the Global Code (Initialise page -> double click the page information box -> Global Code)
Private Function ConvertDateTimeToText(ByVal Table As DataTable) As DataTable
Dim Result As New DataTable
For Each Column As DataColumn In Table.Columns
If Column.DataType = GetType(DateTime) Then
Result.Columns.Add(Column.ColumnName, GetType(String))
Else
Result.Columns.Add(Column.ColumnName, Column.DataType)
End If
Next
For Each Row As DataRow In Table.Rows
Dim NewRow As DataRow = Result.NewRow()
For Each Column As DataColumn In Table.Columns
If Column.DataType = GetType(DataTable) Then
NewRow(Column.ColumnName) = ConvertDateTimeToText(Row(Column.ColumnName))
Else
NewRow(Column.ColumnName) = Row(Column.ColumnName)
End If
Next
Result.Rows.Add(NewRow)
Next
Return Result
End Function
Then modify the JSON To Collection stage with the following:
result = ConvertDateTimeToText(ConvertToDataTable(json))
All of the fields returned in the JSON conversion will be changed from DateTime to Text, which will keep Blue Prism from trying to automatically convert the DateTime. The ConvertDateTimeToText() function is recursive, so it will work with nested JSON as well.
On a trivial side note, I realized Blue Prism isn't trying to convert the DateTimes to local time, rather it is trying to convert from local time to UTC, which is why you ended up -1 hour instead of +1 hour. There may be a better way to handle this particular issue on version 6, but I am constrained to version 5 currently and this is the best solution I've found so far.
------------------------------
Nicholas Zejdlik
RPA Developer
------------------------------
