how to check nested json is exits/not?

julkifli33

hi all ,
how do we check nested json exist or not exist?

this one is not nested is ok.

IF JsonObject.Contains('item') = false THEN
.....................
else
......................

but how about if we want to check fractionAmount?

[
    {
        "id": "630",
        "item": "Item001",
        "affectedAmounts": {
            "fractionAmount": 0
        }
        "fees": []
    }
]

Thanks.

ftornero

Hello @julkifli33,

You could do something like this:

if jsObj.SelectToken('affectedAmounts.fractionAmount', jsToken) then
..........

Regards

julkifli33

Hi @ftornero

I tested this one error if not exist

Amount := SelectJsonToken(JsonObject,$.foreignAmount.amount).AsValue.AsDecimal()

so i just add like this

IF JsonObject.Contains('foreignAmount') = true THEN 
begin
Amount := SelectJsonToken(JsonObject,$.foreignAmount.amount).AsValue.AsDecimal();
end;