Extract data from json file

Still getting the same error

Hi I modified the index after keyvaluepair
image
I could see invoice for field printing in output.
image

Yes sir…I was also doing the same…but i want to get the data of Invoice Number…if i change the String.Join(",", (From r In jobjJson(“pages”)(0)(“keyValuePairs”)(4)(“value”).AsEnumerable()

I am getting the error : Assign strAddress: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

Yes, that is because Invoice number, invoice date etc are in different hierarchy.
please understand this expression and manipulate the same.
first expression should give you invoice number. Second one should give invoice date and so on.

jobjJson(“pages”)(0)(“tables”)(0)(“columns”)(0)(“entries”)(0)(0)(“text”)
jobjJson(“pages”)(0)(“tables”)(0)(“columns”)(1)(“entries”)(0)(0)(“text”)

Please understand your json fully and the above expression fully. you should be able to work with any josn. :slight_smile:

1 Like

ok…Thank you very much…

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