Nested JSON Data Extraction

“data”: {
“fields”: [
{
“name”: “agreementtype”,
“label”: “Agreement Type”,
“mapTo”: “agreementtype”,
“userModified”: false,
“value”: “ABCD EFG”,
“page”: 1,
“confidence”: 0.975,
“zones”: [
{
“left”: 419,
“top”: 200,
“width”: 177,
“height”: 22
}
],
“roles”: [
“DocTypeLocal”,
“AgreementType”
],
“alternatives”: ,
“userAccepted”: true
},
{
“name”: “executeddate”,
“label”: “Executed Date”,
“mapTo”: “executeddate”,
“userModified”: false,
“value”: “December 01, 2002”,
“page”: 1,
“confidence”: 1.0,
“zones”: [
{
“left”: 570,
“top”: 278,
“width”: 180,
“height”: 20
}
],
“roles”: [
“DateLocal”,
“Executed”
],
“alternatives”: ,
“userAccepted”: true
},
{
“name”: “effectivetime”,
“label”: “Effective Time”,
“mapTo”: “effectivetime”,
“userModified”: false,
“value”: “four Business Days”,
“page”: 1,
“confidence”: 0.999,
“zones”: [
{
“left”: 220,
“top”: 1134,
“width”: 176,
“height”: 21
}
],
“roles”: [
“EffectiveTimeLocal”,
“EffectiveTime”
],
“alternatives”: ,
“userAccepted”: true
}
],

I want to extract data from this JSON, the catch here is it has multiple nested json objects.

@ppr please need your help

I need to extract VALUE for property NAME if it equal to agreementtype

Can you share a complete sample file?

For some reason i’m unable to upload the sample file but here is the first part of the json and the second part starts form the json data that i already posted in the 1st post.

“batchId”: 1234,
“name”: “TestData.pdf”,
“className”: “ControlAgmt”,
“workflowId”: 23,
“documentCount”: 2,
“pageCount”: 26,
“dateCreated”: “2021-03-24T12:05:42.193”,
“dateModified”: “2021-03-24T13:30:38.663”,
“status”: “Completed”,
“extractionState”: “Ready”,
“process”: “Completed Workflow”,
“documents”: [
{
“intellidactId”: “2645612641612”,
“name”: “1st Amendement GoBrands.pdf”,
“documentType”: “DAMD”,
“pageCount”: 8,
“redacted”: false,
“classification”: {
“documentType”: “DAMD”,
“confidence”: 0.932,
“classifiers”: “Content”
},
“engine”: {
“ocr”: “12.5.6.0”,
“extraction”: “3.3.9.24288”,
“classification”: “4.2.4.25072”
},
“validationStatus”: {
“indexing”: “Reviewed”,
“redaction”: “NotReviewed”
},
“userData”: [
{
“name”: “cla_proj_name”,
“value”: “agreement”
},
{
“name”: “cla_prod_rev”,
“value”: “8”
},
{
“name”: “cla_eval_rev”,
“value”: “7”
},
{
“name”: “cla_eval_doc”,
“value”: “”
},
{
“name”: “lbx_proj_name”,
“value”: “agreement”
},
{
“name”: “lbx_prod_rev”,
“value”: “4”
},
{
“name”: “lbx_eval_rev”,
“value”: “3”
},
{
“name”: “rem_imgs”,
“value”: “0”
}
],
“rotatePages”:
},
{
“intellidactId”: “26+61616216262”,
“name”: “1st Amendement GoBrands.pdf_2”,
“documentType”: “Test”,
“pageCount”: 18,
“redacted”: false,
“classification”: {
“documentType”: “Test”,
“confidence”: 0.973,
“classifiers”: “Content”
},
“engine”: {
“ocr”: “12.5.6.0”,
“extraction”: “3.3.9.24288”,
“classification”: “4.2.4.25072”
},
“validationStatus”: {
“indexing”: “Reviewed”,
“redaction”: “NotReviewed”
},
“userData”: [
{
“name”: “cla_proj_name”,
“value”: “agreement”
},
{
“name”: “cla_prod_rev”,
“value”: “8”
},
{
“name”: “cla_eval_rev”,
“value”: “7”
},
{
“name”: “cla_eval_doc”,
“value”: “”
},
{
“name”: “lbx_proj_name”,
“value”: “agreement”
},
{
“name”: “lbx_prod_rev”,
“value”: “4”
},
{
“name”: “lbx_eval_rev”,
“value”: “3”
},
{
“name”: “rem_imgs”,
“value”: “0”
}
],
“rotatePages”:
}
],
“extraction”: {
“documents”: [
{
“intellidactId”: “1654516161621626”,
“fileName”: “1st Data test_.tif”,
“documentType”: “DAMD”,
“confidence”: 0.932,
“splitConfidence”: 0.024,
“pages”: [
{
“page”: 1,
“origFileName”: “1st Amendement GoBrands.pdf”,
“origPage”: 1
},
{
“page”: 2,
“origFileName”: “TestData.pdf”,
“origPage”: 2
},
{
“page”: 3,
“origFileName”: “TestData.pdf”,
“origPage”: 3
},
{
“page”: 4,
“origFileName”: “TestData.pdf”,
“origPage”: 4
},
{
“page”: 5,
“origFileName”: “TestData.pdf”,
“origPage”: 5
},
{
“page”: 6,
“origFileName”: “TestData.pdf”,
“origPage”: 6
},
{
“page”: 7,
“origFileName”: “TestData.pdf”,
“origPage”: 7
},
{
“page”: 8,
“origFileName”: “TestData.pdf”,
“origPage”: 8
}
],
“data”: {
“fields”: [
{
“name”: “executeddate”,
“label”: “Executed Date”,
“mapTo”: “executeddate”,
“userModified”: true,
“value”: “October 6. 2023,”,
“page”: 1,
“confidence”: 0.0,
“zones”: [
{
“left”: 756,
“top”: 259,
“width”: 155,
“height”: 20
}
],
“alternatives”: ,
“userAccepted”: true
}
],
“tables”: [
{
“name”: “company”,
“label”: “Company Notices”,
“mapTo”: “company”,
“columnDefinitions”: [
{
“name”: “companyname”,
“label”: “Company Name”,
“mapTo”: “companyname”
},
{
“name”: “companystreet”,
“label”: “Company Street”,
“mapTo”: “companystreet”
},
{
“name”: “companycity”,
“label”: “Company City”,
“mapTo”: “companycity”
},
{
“name”: “companystate”,
“label”: “Company State”,
“mapTo”: “companystate”
},
{
“name”: “companyzip”,
“label”: “Company Zip”,
“mapTo”: “companyzip”
},
{
“name”: “companyattn”,
“label”: “Company Attn”,
“mapTo”: “companyattn”
},
{
“name”: “companynumber”,
“label”: “Company Number”,
“mapTo”: “companynumber”
},
{
“name”: “companyemail”,
“label”: “Company Email”,
“mapTo”: “companyemail”
}
],
“rows”:
},
{
“name”: “copytocompany”,
“label”: “Copy To Company Notices”,
“mapTo”: “copytocompany”,
“columnDefinitions”: [
{
“name”: “copytocompanyname”,
“label”: “Copy To Company Name”,
“mapTo”: “copytocompanyname”
},
{
“name”: “copytocompanystreet”,
“label”: “Copy To Company Street”,
“mapTo”: “copytocompanystreet”
},
{
“name”: “copytocompanycity”,
“label”: “Copy To Company City”,
“mapTo”: “copytocompanycity”
},
{
“name”: “copytocompanystate”,
“label”: “Copy To Company State”,
“mapTo”: “copytocompanystate”
},
{
“name”: “copytocompanyzip”,
“label”: “Copy To Company Zip”,
“mapTo”: “copytocompanyzip”
},
{
“name”: “copytocompanyattn”,
“label”: “Copy To Company Attn”,
“mapTo”: “copytocompanyattn”
},
{
“name”: “copytocompanynumber”,
“label”: “Copy To Company Number”,
“mapTo”: “copytocompanynumber”
},
{
“name”: “copytocompanyemail”,
“label”: “Copy To Company Email”,
“mapTo”: “copytocompanyemail”
}
],
“rows”:
},
{
“name”: “debtor”,
“label”: “Debtor Notices”,
“mapTo”: “debtor”,
“columnDefinitions”: [
{
“name”: “debtorname”,
“label”: “Debtor Name”,
“mapTo”: “debtorname”
},
{
“name”: “debtorstreet”,
“label”: “Debtor Street”,
“mapTo”: “debtorstreet”
},
{
“name”: “debtorcity”,
“label”: “Debtor City”,
“mapTo”: “debtorcity”
},
{
“name”: “debtorstate”,
“label”: “Debtor State”,
“mapTo”: “debtorstate”
},
{
“name”: “debtorzip”,
“label”: “Debtor Zip”,
“mapTo”: “debtorzip”
},
{
“name”: “debtorattn”,
“label”: “Debtor Attn”,
“mapTo”: “debtorattn”
},
{
“name”: “debtornumber”,
“label”: “Debtor Number”,
“mapTo”: “debtornumber”
},
{
“name”: “debtoremail”,
“label”: “Debtor Email”,
“mapTo”: “debtoremail”
}
],
“rows”:
},
{
“name”: “copytodebtor”,
“label”: “Copy To Debtor Notices”,
“mapTo”: “copytodebtor”,
“columnDefinitions”: [
{
“name”: “copytodebtorname”,
“label”: “Copy To Debtor Name”,
“mapTo”: “copytodebtorname”
},
{
“name”: “copytodebtorstreet”,
“label”: “Copy To Debtor Street”,
“mapTo”: “copytodebtorstreet”
},
{
“name”: “copytodebtorcity”,
“label”: “Copy To Debtor City”,
“mapTo”: “copytodebtorcity”
},
{
“name”: “copytodebtorstate”,
“label”: “Copy To Debtor State”,
“mapTo”: “copytodebtorstate”
},
{
“name”: “copytodebtorzip”,
“label”: “Copy To Debtor Zip”,
“mapTo”: “copytodebtorzip”
},
{
“name”: “copytodebtorattn”,
“label”: “Copy To Debtor Attn”,
“mapTo”: “copytodebtorattn”
},
{
“name”: “copytodebtornumber”,
“label”: “Copy To Debtor Number”,
“mapTo”: “copytodebtornumber”
},
{
“name”: “copytodebtoremail”,
“label”: “Copy To Debtor Email”,
“mapTo”: “copytodebtoremail”
}
],
“rows”:
},
{
“name”: “securedcreditor”,
“label”: “Secured Creditor Notices”,
“mapTo”: “securedcreditor”,
“columnDefinitions”: [
{
“name”: “securedcreditorname”,
“label”: “Secured Creditor Name”,
“mapTo”: “securedcreditorname”
},
{
“name”: “securedcreditorstreet”,
“label”: “Secured Creditor Street”,
“mapTo”: “securedcreditorstreet”
},
{
“name”: “securedcreditorcity”,
“label”: “Secured Creditor City”,
“mapTo”: “securedcreditorcity”
},
{
“name”: “securedcreditorstate”,
“label”: “Secured Creditor State”,
“mapTo”: “securedcreditorstate”
},
{
“name”: “securedcreditorzip”,
“label”: “Secured Creditor Zip”,
“mapTo”: “securedcreditorzip”
},
{
“name”: “securedcreditorattn”,
“label”: “Secured Creditor Attn”,
“mapTo”: “securedcreditorattn”
},
{
“name”: “securedcreditornumber”,
“label”: “Secured Creditor Number”,
“mapTo”: “securedcreditornumber”
},
{
“name”: “securedcreditoremail”,
“label”: “Secured Creditor Email”,
“mapTo”: “securedcreditoremail”
}
],
“rows”:
},
{
“name”: “copytosecuredcreditor”,
“label”: “Copy To Secured Creditor Notices”,
“mapTo”: “copytosecuredcreditor”,
“columnDefinitions”: [
{
“name”: “copytosecuredcreditorname”,
“label”: “Copy To Secured Creditor Name”,
“mapTo”: “copytosecuredcreditorname”
},
{
“name”: “copytosecuredcreditorstreet”,
“label”: “Copy To Secured Creditor Street”,
“mapTo”: “copytosecuredcreditorstreet”
},
{
“name”: “copytosecuredcreditorcity”,
“label”: “Copy To Secured Creditor City”,
“mapTo”: “copytosecuredcreditorcity”
},
{
“name”: “copytosecuredcreditorstate”,
“label”: “Copy To Secured Creditor State”,
“mapTo”: “copytosecuredcreditorstate”
},
{
“name”: “copytosecuredcreditorzip”,
“label”: “Copy To Secured Creditor Zip”,
“mapTo”: “copytosecuredcreditorzip”
},
{
“name”: “copytosecuredcreditorattn”,
“label”: “Copy To Secured Creditor Attn”,
“mapTo”: “copytosecuredcreditorattn”
},
{
“name”: “copytosecuredcreditornumber”,
“label”: “Copy To Secured Creditor Number”,
“mapTo”: “copytosecuredcreditornumber”
},
{
“name”: “copytosecuredcreditoremail”,
“label”: “Copy To Secured Creditor Email”,
“mapTo”: “copytosecuredcreditoremail”
}
],
“rows”:
},
{
“name”: “accountnumbers”,
“label”: “Account Numbers”,
“mapTo”: “accountnumbers”,
“columnDefinitions”: [
{
“name”: “col_accountnumbers”,
“label”: “Account Numbers”,
“mapTo”: “col_accountnumbers”
}
],
“rows”: [
{
“number”: 1,
“columns”: [
{
“name”: “col_accountnumbers”,
“label”: “Account Numbers”,
“mapTo”: “col_accountnumbers”,
“userModified”: true,
“value”: “1234567890”,
“page”: 1,
“confidence”: 0.999,
“zones”: [
{
“left”: 360,
“top”: 907,
“width”: 111,
“height”: 16
}
],
“roles”: [
“Number”,
“Account”
],
“alternatives”: ,
“userAccepted”: true
}
]
},
{
“number”: 2,
“columns”: [
{
“name”: “col_accountnumbers”,
“label”: “Account Numbers”,
“mapTo”: “col_accountnumbers”,
“userModified”: false,
“value”: “1234567890”,
“page”: 1,
“confidence”: 0.999,
“zones”: [
{
“left”: 731,
“top”: 1197,
“width”: 110,
“height”: 16
}
],
“roles”: [
“Number”,
“Account”
],
“alternatives”: ,
“userAccepted”: true
}
]
},
{
“number”: 3,
“columns”: [
{
“name”: “col_accountnumbers”,
“label”: “Account Numbers”,
“mapTo”: “col_accountnumbers”,
“userModified”: false,
“value”: “1234567890”,
“page”: 1,
“confidence”: 0.873,
“zones”: [
{
“left”: 731,
“top”: 1225,
“width”: 109,
“height”: 16
}
],
“roles”: [
“Number”,
“Account”
],
“alternatives”: ,
“userAccepted”: true
}
]
},
{
“number”: 4,
“columns”: [
{
“name”: “col_accountnumbers”,
“label”: “Account Numbers”,
“mapTo”: “col_accountnumbers”,
“userModified”: false,
“value”: “1234567890”,
“page”: 1,
“confidence”: 0.998,
“zones”: [
{
“left”: 731,
“top”: 1279,
“width”: 110,
“height”: 16
}
],
“roles”: [
“Number”,
“Account”
],
“alternatives”: ,
“userAccepted”: true
}
]
},
{
“number”: 5,
“columns”: [
{
“name”: “col_accountnumbers”,
“label”: “Account Numbers”,
“mapTo”: “col_accountnumbers”,
“userModified”: false,
“value”: “1234567890”,
“page”: 1,
“confidence”: 0.997,
“zones”: [
{
“left”: 731,
“top”: 1307,
“width”: 111,
“height”: 16
}
],
“roles”: [
“Number”,
“Account”
],
“alternatives”: ,
“userAccepted”: true
}
]
},
{
“number”: 6,
“columns”: [
{
“name”: “col_accountnumbers”,
“label”: “Account Numbers”,
“mapTo”: “col_accountnumbers”,
“userModified”: false,
“value”: “1234567890”,
“page”: 1,
“confidence”: 0.997,
“zones”: [
{
“left”: 731,
“top”: 1335,
“width”: 111,
“height”: 16
}
],
“roles”: [
“Number”,
“Account”
],
“alternatives”: ,
“userAccepted”: true
}
]
},
{
“number”: 7,
“columns”: [
{
“name”: “col_accountnumbers”,
“label”: “Account Numbers”,
“mapTo”: “col_accountnumbers”,
“userModified”: false,
“value”: “1234567890”,
“page”: 1,
“confidence”: 0.996,
“zones”: [
{
“left”: 731,
“top”: 1363,
“width”: 111,
“height”: 16
}
],
“roles”: [
“Number”,
“Account”
],
“alternatives”: ,
“userAccepted”: true
}
]
},
{
“number”: 8,
“columns”: [
{
“name”: “col_accountnumbers”,
“label”: “Account Numbers”,
“mapTo”: “col_accountnumbers”,
“userModified”: false,
“value”: “1234567890”,
“page”: 1,
“confidence”: 0.992,
“zones”: [
{
“left”: 731,
“top”: 1391,
“width”: 111,
“height”: 16
}
],
“roles”: [
“Number”,
“Account”
],
“alternatives”: ,
“userAccepted”: true
}
]
},
{
“number”: 9,
“columns”: [
{
“name”: “col_accountnumbers”,
“label”: “Account Numbers”,
“mapTo”: “col_accountnumbers”,
“userModified”: false,
“value”: “1234567890”,
“page”: 2,
“confidence”: 0.992,
“zones”: [
{
“left”: 731,
“top”: 155,
“width”: 110,
“height”: 16
}
],
“roles”: [
“Number”,
“Account”
],
“alternatives”: ,
“userAccepted”: true
}
]
},
{
“number”: 10,
“columns”: [
{
“name”: “col_accountnumbers”,
“label”: “Account Numbers”,
“mapTo”: “col_accountnumbers”,
“userModified”: false,
“value”: “1234567890”,
“page”: 2,
“confidence”: 0.992,
“zones”: [
{
“left”: 731,
“top”: 183,
“width”: 111,
“height”: 16
}
],
“roles”: [
“Number”,
“Account”
],
“alternatives”: ,
“userAccepted”: true
}
]
},
{
“number”: 11,
“columns”: [
{
“name”: “col_accountnumbers”,
“label”: “Account Numbers”,
“mapTo”: “col_accountnumbers”,
“userModified”: false,
“value”: “1234567890”,
“page”: 2,
“confidence”: 0.992,
“zones”: [
{
“left”: 731,
“top”: 211,
“width”: 111,
“height”: 16
}
],
“roles”: [
“Number”,
“Account”
],
“alternatives”: ,
“userAccepted”: true
}
]
},
{
“number”: 12,
“columns”: [
{
“name”: “col_accountnumbers”,
“label”: “Account Numbers”,
“mapTo”: “col_accountnumbers”,
“userModified”: false,
“value”: “1234567890”,
“page”: 2,
“confidence”: 0.992,
“zones”: [
{
“left”: 731,
“top”: 238,
“width”: 111,
“height”: 16
}
],
“roles”: [
“Number”,
“Account”
],
“alternatives”: ,
“userAccepted”: true
}
]
},
{
“number”: 13,
“columns”: [
{
“name”: “col_accountnumbers”,
“label”: “Account Numbers”,
“mapTo”: “col_accountnumbers”,
“userModified”: false,
“value”: “1234567890”,
“page”: 2,
“confidence”: 0.992,
“zones”: [
{
“left”: 731,
“top”: 266,
“width”: 111,
“height”: 16
}
],
“roles”: [
“Number”,
“Account”
],
“alternatives”: ,
“userAccepted”: true
}
]
},
{
“number”: 14,
“columns”: [
{
“name”: “col_accountnumbers”,
“label”: “Account Numbers”,
“mapTo”: “col_accountnumbers”,
“userModified”: false,
“value”: “1234567890”,
“page”: 2,
“confidence”: 0.992,
“zones”: [
{
“left”: 731,
“top”: 294,
“width”: 111,
“height”: 16
}
],
“roles”: [
“Number”,
“Account”
],
“alternatives”: ,
“userAccepted”: true
}
]
},
{
“number”: 15,
“columns”: [
{
“name”: “col_accountnumbers”,
“label”: “Account Numbers”,
“mapTo”: “col_accountnumbers”,
“userModified”: true,
“value”: “1234567890”,
“page”: 1,
“confidence”: 0.0,
“zones”: [
{
“left”: 203,
“top”: 549,
“width”: 114,
“height”: 17
}
],
“alternatives”: ,
“userAccepted”: true
}
]
},
{
“number”: 16,
“columns”: [
{
“name”: “col_accountnumbers”,
“label”: “Account Numbers”,
“mapTo”: “col_accountnumbers”,
“userModified”: true,
“value”: “1234567890”,
“page”: 1,
“confidence”: 0.0,
“zones”: [
{
“left”: 204,
“top”: 581,
“width”: 110,
“height”: 16
}
],
“alternatives”: ,
“userAccepted”: true
}
]
},
{
“number”: 17,
“columns”: [
{
“name”: “col_accountnumbers”,
“label”: “Account Numbers”,
“mapTo”: “col_accountnumbers”,
“userModified”: true,
“value”: “1234567890”,
“page”: 1,
“confidence”: 0.0,
“zones”: [
{
“left”: 204,
“top”: 612,
“width”: 113,
“height”: 16
}
],
“alternatives”: ,
“userAccepted”: true
}
]
},
{
“number”: 18,
“columns”: [
{
“name”: “col_accountnumbers”,
“label”: “Account Numbers”,
“mapTo”: “col_accountnumbers”,
“userModified”: true,
“value”: “1234567890”,
“page”: 1,
“confidence”: 0.0,
“zones”: [
{
“left”: 204,
“top”: 644,
“width”: 113,
“height”: 16
}
],
“alternatives”: ,
“userAccepted”: true
}
]
},
{
“number”: 19,
“columns”: [
{
“name”: “col_accountnumbers”,
“label”: “Account Numbers”,
“mapTo”: “col_accountnumbers”,
“userModified”: true,
“value”: “1234567890”,
“page”: 1,
“confidence”: 0.0,
“zones”: [
{
“left”: 204,
“top”: 674,
“width”: 112,
“height”: 17
}
],
“alternatives”: ,
“userAccepted”: true
}
]
},
{
“number”: 20,
“columns”: [
{
“name”: “col_accountnumbers”,
“label”: “Account Numbers”,
“mapTo”: “col_accountnumbers”,
“userModified”: true,
“value”: “1234567890”,
“page”: 1,
“confidence”: 0.0,
“zones”: [
{
“left”: 204,
“top”: 706,
“width”: 112,
“height”: 16
}
],
“alternatives”: ,
“userAccepted”: true
}
]
},
{
“number”: 21,
“columns”: [
{
“name”: “col_accountnumbers”,
“label”: “Account Numbers”,
“mapTo”: “col_accountnumbers”,
“userModified”: true,
“value”: “1234567890”,
“page”: 1,
“confidence”: 0.0,
“zones”: [
{
“left”: 204,
“top”: 737,
“width”: 112,
“height”: 16
}
],
“alternatives”: ,
“userAccepted”: true
}
]
},
{
“number”: 22,
“columns”: [
{
“name”: “col_accountnumbers”,
“label”: “Account Numbers”,
“mapTo”: “col_accountnumbers”,
“userModified”: true,
“value”: “1234567890”,
“page”: 1,
“confidence”: 0.0,
“zones”: [
{
“left”: 204,
“top”: 769,
“width”: 113,
“height”: 16
}
],
“alternatives”: ,
“userAccepted”: true
}
]
},
{
“number”: 23,
“columns”: [
{
“name”: “col_accountnumbers”,
“label”: “Account Numbers”,
“mapTo”: “col_accountnumbers”,
“userModified”: true,
“value”: “1234567890”,
“page”: 1,
“confidence”: 0.0,
“zones”: [
{
“left”: 204,
“top”: 803,
“width”: 113,
“height”: 16
}
],
“alternatives”: ,
“userAccepted”: true
}
]
},
{
“number”: 24,
“columns”: [
{
“name”: “col_accountnumbers”,
“label”: “Account Numbers”,
“mapTo”: “col_accountnumbers”,
“userModified”: true,
“value”: “1234567890”,
“page”: 1,
“confidence”: 0.0,
“zones”: [
{
“left”: 730,
“top”: 1252,
“width”: 111,
“height”: 16
}
],
“alternatives”: ,
“userAccepted”: true
}
]
}
]
}
]
}
},
{
“intellidactId”: “54646464646416416”,
“fileName”: “TestData_.tif”,
“documentType”: “TEST”,
“confidence”: 0.973,
“splitConfidence”: 0.958,
“pages”: [
{
“page”: 1,
“origFileName”: “TestData.pdf”,
“origPage”: 9
},
{
“page”: 2,
“origFileName”: “TestData.pdf”,
“origPage”: 10
},
{
“page”: 3,
“origFileName”: “TestData.pdf”,
“origPage”: 11
},
{
“page”: 4,
“origFileName”: “TestData.pdf”,
“origPage”: 12
},
{
“page”: 5,
“origFileName”: “TestData.pdf”,
“origPage”: 13
},
{
“page”: 6,
“origFileName”: “TestData.pdf”,
“origPage”: 14
},
{
“page”: 7,
“origFileName”: “TestData.pdf”,
“origPage”: 15
},
{
“page”: 8,
“origFileName”: “TestData.pdf”,
“origPage”: 16
},
{
“page”: 9,
“origFileName”: “TestData.pdf”,
“origPage”: 17
},
{
“page”: 10,
“origFileName”: “TestData.pdf”,
“origPage”: 18
},
{
“page”: 11,
“origFileName”: “TestData.pdf”,
“origPage”: 19
},
{
“page”: 12,
“origFileName”: “TestData.pdf”,
“origPage”: 20
},
{
“page”: 13,
“origFileName”: “TestData.pdf”,
“origPage”: 21
},
{
“page”: 14,
“origFileName”: “TestData.pdf”,
“origPage”: 22
},
{
“page”: 15,
“origFileName”: “TestData.pdf”,
“origPage”: 23
},
{
“page”: 16,
“origFileName”: “TestData.pdf”,
“origPage”: 24
},
{
“page”: 17,
“origFileName”: “TestData.pdf”,
“origPage”: 25
},
{
“page”: 18,
“origFileName”: “TestData.pdf”,
“origPage”: 26
}
],

It looks incomplete. See if you can upload it with another extension.

@abhirpa,

Have you tried to deserialize the json? You can just give the json sample to LLM and ask it to give you deserialization code.

1 Like

@abhirpa

Use deserialize json activity and pass the string as input then you would get the ouput jobj

Now jobj("data")("fields").Where(function(x) x("name").ToString.Equals("agreementType")) this will give all objects related to agreement type now you can add select statement after it to get any property inside the array

So basically any object ({) can be accessed using name of it and if it is array ([) then use linq to filter or (0) will give first item and (1) will give second item etc

Cheers

1 Like