How can I extract some data from a JSON file?

[Alejandro_Vega_Romero]

Hi, I would like to extract some information from a json file. The fields I am interested in are from side to country.

{
“process”: “liquidation”,
“salesforceCase”: “sales-1234”,
“salesforceId”: “slfid-001”,
“mailBox”: “juan@gmail.com”,
“expedient”: “exp-001”,
“documentId”: “doc-001”,
“documentName”: “dni-doc-001-1673944146181”,
“result”: [
{
“pages”: [
1,
2
],
“categories”: [
{
“category”: “dni”,
“confidence”: 0.9998
},
{
“category”: “cuentaBancaria”,
“confidence”: 0.0001
},
{
“category”: “factura”,
“confidence”: 0
},
{
“category”: “libroFamilia”,
“confidence”: 0
},
{
“category”: “mail”,
“confidence”: 0
},
{
“category”: “impuestoSucesiones”,
“confidence”: 0
},
{
“category”: “herederosTestamento”,
“confidence”: 0
},
{
“category”: “ultimasVoluntades”,
“confidence”: 0
}
],
“data”: [
{
“key”: “nes”,
“value”: ,
“confidence”: 0
},
{
“key”: “nis”,
“value”: ,
“confidence”: 0
},
{
“key”: “numPolicy”,
“value”: ,
“confidence”: 0
},
{
“key”: “dnis”,
“value”: [
{
“side”: “BOTH”,
“number”: “24112207L”,
“name”: “SEXO”,
“surname”: “NARVAEZ FERNANDEZ ENCARNACION”,
“address”: “C. AGUSTINA ARAGON 14 D PO2 D”,
“locality”: “GRANADA”,
“province”: “GRANADA”,
“country”: “ESPAÑA”
}
],
“confidence”: 0.9
}
]
}
]
}

I’m trying with the following assign, but it’s returning an error… Any idea?

DNIjson(“result”)(0)(“data”).Where(Function (x) x(“key”).Value(of String).equals(“dnis”)).first()(“value”).toObject(Of String())

[vishnuvarthanp (vishnuvarthan)]

Hi,

Please check this thread -

How to extract the exact data from Json file

Hi All, Am trying to extract the specific data from Json file . Can any of you help me on how to extract: Data is : {“invoiceNumber”:“Abc- 645687”,“accountNumber”:“DXXX”,“invoiceDate”:“XXXX”,“OrderNumber”:“XXXX”,“soldToDetails”:"; XXXXXXX . "} I wanted to create a datatable with this data . Can anyone please help. Thank you

Extract data from json file

Hello Everyone, I am trying to extract the data from json file using Deserailized Json Activity.Please help me to solve this issue. I am attaching the file for reference.Untitled.txt (2.4 KB)

[ppr (Peter Preuss)]

validating the access path:

retrievals:

[Alejandro_Vega_Romero]

Thx! And can you show how to extract it in an array, to be able to select only one value if i want

[ppr (Peter Preuss)]

@Alejandro_Vega_Romero

an array,

just define which retrieval level is looked for: values, properties, keys?

[Alejandro_Vega_Romero]

Like that?

[ppr (Peter Preuss)]

question was more about
Values

myJObject("result")(0)("data").Where(Function (x) x("key").Value(of String).equals("dnis")).First()("value")(0).Values.select(Function (x) x.Value(of String)).toArray

or Variation:

or others?