how to check nested json is exits/not?

julkifli33julkifli33 Member Posts: 1,039
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.

Answers

  • ftorneroftornero Member Posts: 459
    Hello @julkifli33,

    You could do something like this:
    if jsObj.SelectToken('affectedAmounts.fractionAmount', jsToken) then
    ..........
    

    Regards
  • julkifli33julkifli33 Member Posts: 1,039
    edited 2022-01-19
    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;
    
Sign In or Register to comment.