Hello, I’m trying to figure out how to convert a JSON to a DataTable, using something like this, EXAMPLE : (From p In DictionaryJSON Select DT_JSON.Rows.Add(p.Key.ToString,p.Value.ToString)).ToArray.CopyToDataTable [Capture] PS : Data needed in the DT is : “irdrh”, “…BENEFICIAIRE”, “…IBAN”, “…SW…

I finally found a solution for my problem : > JArray.FromObject(ObjetJSON("Demandes")("Demande").Select(Function(d) New With {.idrh = d("idrh"), .dt_RIBMODI_IBAN = d("fields")("field")(0)("dt_RIBMODI_IBAN"), .dt_RIBMODI_BENEFICIAIRE = d("fields")("field")(0)("dt_RIBMODI_BENEFICIAIRE"), .dt_RIBMODI_…

JSON to DT

Help Community

Sudharsan_Ka (Sudharsan Ka) March 3, 2023, 11:48am 2

HI @mz3bel

Checkout this

Regards
Sudharsan

1 Like

Topic		Replies	Views
How to convert Json to DT Help datatable , activities , question	3	1653	November 7, 2019
LINQ to JSON to get desired result and copy to a data table Studio datatable , studio , json , linq	13	3167	June 5, 2022
Convert json from request to DataTable Academy Feedback	1	689	June 25, 2020
API Json response to datatable Studio studio , question , json , activities_panel	3	381	August 16, 2023
JSON to DataTable gives System.String[] StudioX question	4	555	January 2, 2023

Most Active Users - Yesterday
ashokkarale
anjani_priya
Dheerendra_vishwakarma
Parvathy
Aakash_Singh_Rawat
Luis_Fernando
bjorn2390
neco
pere
Shiva_Nikhil
More details...

JSON to DT

Related Topics