AnsweredAssumed Answered

JSON Array Parsing Syntax?

Question asked by ThierryGuemboura on May 10, 2018
Latest reply on May 11, 2018 by jbrown

I have a JSON array with 15 Objects

All 15 Objects are formatted the same way with 32 objects in each of them

Keys 0.JPG

We can see that the last 3 objects are array themselves containing 3 objects each.

JSONListKeys ( JSON_Pretty; ".0" ) returns

$id

Adjuster_Assigned

CLAIM_ASSIGN_NOTES

CLAIM_ASSIGN_NOTES_USERID

Catcode

ClAIM_ASSIGN_NOTES_DATETIME

ClaimNum

Claim_Accepted_Date

Claim_Added

Claim_Assignment_Status

Claim_Contacts

Claim_Data_Prior_Claims

Claim_ID

Claim_Notes

Company

Description

Loss_Date

Loss_Severity

Loss_Type

Master_Company

Policy_Location

Policy_Module

Policy_Number

Policy_Symbol

Property_Address

Property_City

Property_State

Property_ZIP

Report_Date

ReserveAmount

ReserveChangeNotes

XWind

I cannot find how to drill down the Claim_Contacts the same way to find the Keys, I tried JSONListKeys ( JSON_Pretty; ".0.Claim_Contacts[0]" ) and any combination I could think of. I would like to get the 17 keys

What am I doing wrong?

Outcomes