Error converting value to type 'System.Int64' while desalinizing JSON object to data table

Help
, ,
#1

I am trying to deserialize JSON output to the data table and getting the below error

Error converting value “1D” to type ‘System.Int64’

I am using this - > JsonConvert.DeserializeObject(Of DataTable)(jSonOutput)

Data in the input column is similar to like this.

Column0
12
13
14
1D
12M
16
17

#2

Hi @sravya_vankadaru

1D is not Int, so you would have to deserialize the json into string

#3

Column0 has a combination of intergers and strings. How do we do that ?

#4

There is any need to have the data in Int form? Else map the column to string

#5

how do we map entire column in datatable to string.
I tried - >

dt=(From row In dt.Select Order By Convert.ToString(row(“Column10”)) Ascending Select row).ToArray.CopyToDatatable()

Unfortunately it is not getting converted to String type. The data type still shows as system.object