How to write a unstructure json data into excel is it possible?

Help Studio
, ,
1

Hi Team,

Could some one help me, This is my Json in which some time keys will be present and in some cases my keys will not present in that case how to handle this without errors.

Example:- AMOUNT is availble in JSON data in some case AMOUNT is absent in JSON data

{
“BOE”: {
“extracted_data”: {
“AMOUNT”: [
“45068”,
“82.84”,
“140.22”,
“259.92”,
“192.02”,
“125.47”,
],
“ASSESS_VALUE”: [
“8909.24”,
“15080.31”,
“27953.75”,

  ],
  "ASS_VALUE": [
    "162335"
  ],
  "BCD": [
    "12208.6",
    "10",
    "10",
    "10"
  ],
  "BE_DATE": [
    "27/03/2024"
  ],
  "BE_NO": [
    "2770250"
  ]
},
"synthetic_data": null

}
}

2

Help me please some one

3

Hi, @naveen5

You can try to convert your json file into a datatable and then write this data table into an excel file.

4

How to do that? could you please help on this

5

Hi @naveen5 , please follow these steps to check the key before accessing values of it:

image
image1249×1335 40 KB

If I change the key (to test the absence of the key):
image

If the key is good:
image

6

Or you can loop through the text and spit by semicolon

column a = key
column b = value