Re: Unable to display JSON records with null values

2022-02-23 Thread Sid
Okay. So what should I do if I get such data? On Wed, Feb 23, 2022 at 11:59 PM Sean Owen wrote: > There is no record "345" here it seems, right? it's not that it exists and > has null fields; it's invalid w.r.t. the schema that the rest suggests. > > On Wed, Feb 23, 2022 at 11:57 AM Sid wrote:

Re: Unable to display JSON records with null values

2022-02-23 Thread Sean Owen
There is no record "345" here it seems, right? it's not that it exists and has null fields; it's invalid w.r.t. the schema that the rest suggests. On Wed, Feb 23, 2022 at 11:57 AM Sid wrote: > Hello experts, > > I have a JSON data like below: > > [ > { > "123": { > "Party1": { >

Unable to display JSON records with null values

2022-02-23 Thread Sid
Hello experts, I have a JSON data like below: [ { "123": { "Party1": { "FIRSTNAMEBEN": "ABC", "ALIASBEN": "", "RELATIONSHIPTYPE": "ABC, FGHIJK LMN", "DATEOFBIRTH": "7/Oct/1969" }, "Party2": { "FIRSTNAMEBEN": "ABCC", "ALIASBEN