How to find values on Json Array

Help Activities
, , , ,
1

1

2

Hello, I have data table on excel and simple Json array, I am trying to fill my “RESULT” column with condition if date on datatable match with date on Json, Write TRUE, if not, write FALSE.

can anyone help? Thanks

2

Hi @Kevin_Maurice

Try this:
Use Deserialize JSON activity to read the JSON file and the output is JSON Object.(Download UiPath.webAPI.activities dependeny)

For each row in excel:
    if row("DATE") == jsonObject(row("DATE")):
        write cell activity: TRUE
    else:
        write cell activity: FALSE

Note: Here jsonObject means output of Deserialize activity.

Hope it helps.

1 Like
3

@Kevin_Maurice

  1. Are you checking for the key which is at first pevel before description or after description
  2. If before you can use like this…deserialize the json then ISNothing(jobj("Key1")("DatekeyvalfromExcel"))…this will return true if the fdatekeyvalfromexcrl is not present else false

Cheers

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.