How to convert JSON to DataTable?

Help Studio
, ,
1

Hello

“I trained a custom model using Azure Document Intelligence AI Studio. I was able to extract data from a PDF file in JSON format, but I need it in a more readable format like string or datatable. JSON is complex, so how can I convert it?”

The main task is to parse the Line Item Table.

attached JSON File and PDF File
6556392169.pdf.json (262.5 KB)
BS-1 (2).pdf (57.8 KB)

2

Hi @kishan.savaliya

Refer the below Thread,It might helps you

Hope it helps!!

3

its not works for me

4

it will not work as the part of the JSON is not within the needed structure for this JArray…ToObject Short cut.

from where in Detail it was caught. What is the Datatype of the used object used for?

5

data is extracted from pdf using Azure Custom Model and Format is JSON only.

image
image1366×640 89.2 KB

6

At least using:

grafik
grafik511×559 32.7 KB

And
grafik
grafik781×687 39.7 KB

could be used for constructing a datatable structure and populating its rows

1 Like
7
8

thanks @ppr for the solution

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.