Extracting spesific value from Json

Help Studio
, , , , , ,
1

Hello i get this repsonse from a api call
Want to know how i can extract first the “type” make a check if its containing “REG” or “DAMAGE” then i extract the “filename” and “url”

“data”: {

"so_number": "0000522941",

"registration": "VH28033",

"insurance_company": "CODAN FORSIKRING",

"insurance_company_m3_id": "100453",

"images": [

    {

        "filename": "NO/IMAGES/0000522941/INSURANCE/0000522941_REG_1616140395.JPEG",

        "type": "REG",

        "url": "https://insurancepictures.blob.core.windows.net/nordics/NO/IMAGES/0000522941/INSURANCE/0000522941_REG_1616140395.JPEG?sv=2017-11-09&sr=b&se=2021-06-02T06:58:44Z&sp=r&spr=https&sig=6WMdfSXz2SEoqRp340r317D3GD5cC7u1rMptg5Rl2Rg%3D"

    },

    {

        "filename": "NO/IMAGES/0000522941/INSURANCE/0000522941_DAMAGE_1616140395.JPEG",

        "type": "DAMAGE",

        "url": "https://insurancepictures.blob.core.windows.net/nordics/NO/IMAGES/0000522941/INSURANCE/0000522941_DAMAGE_1616140395.JPEG?sv=2017-11-09&sr=b&se=2021-06-02T06:58:44Z&sp=r&spr=https&sig=HTQK6JLH%2BUybCzSVzQy%2BxMAeHgCloNNRtt6aUlECszQ%3D"

    },

    {

        "filename": "NO/IMAGES/0000522941/INSURANCE/0000522941_REG_1617086583.JPEG",

        "type": "REG",

        "url": "https://insurancepictures.blob.core.windows.net/nordics/NO/IMAGES/0000522941/INSURANCE/0000522941_REG_1617086583.JPEG?sv=2017-11-09&sr=b&se=2021-06-02T06:58:44Z&sp=r&spr=https&sig=rsU%2F6lm1EWc6v6r7RqYpKdmNs7a7wWnSRfFhZD0DkyA%3D"

    },

    {

        "filename": "NO/IMAGES/0000522941/INSURANCE/0000522941_REG_1617086614.JPEG",

        "type": "REG",

        "url": "https://insurancepictures.blob.core.windows.net/nordics/NO/IMAGES/0000522941/INSURANCE/0000522941_REG_1617086614.JPEG?sv=2017-11-09&sr=b&se=2021-06-02T06:58:44Z&sp=r&spr=https&sig=pfNNXMWWhMrCxownQv2CzLtRBtVdv7gw1BSoM07pfYo%3D"

    },

    {

        "filename": "NO/IMAGES/0000522941/INSURANCE/0000522941_DAMAGE_1617086614.JPEG",

        "type": "DAMAGE",

        "url": "https://insurancepictures.blob.core.windows.net/nordics/NO/IMAGES/0000522941/INSURANCE/0000522941_DAMAGE_1617086614.JPEG?sv=2017-11-09&sr=b&se=2021-06-02T06:58:44Z&sp=r&spr=https&sig=yzBttjBN6XZ4709dbLG7XDuIyawTpq0PdtHZqOfDLR8%3D"

    },

    {

        "filename": "NO/IMAGES/0000522941/OTHER/0000522941_DAMAGE1_1620193283.JPEG",

        "type": "OTHER",

        "url": "https://insurancepictures.blob.core.windows.net/nordics/NO/IMAGES/0000522941/OTHER/0000522941_DAMAGE1_1620193283.JPEG?sv=2017-11-09&sr=b&se=2021-06-02T06:58:44Z&sp=r&spr=https&sig=jPvPwHCeQqk5Z2UEuHkd9yDTYdm5G%2B5pnEkuD%2Fh5eFA%3D"

    }

]

}

2

use the json activity in the uipath.webapi.activities to parse json.
you could also add the Json.NET dependency to convert a json string to other datatypes.

3

have a look here:
similar as value wtihin an array contained object is to retrieve:

give a try on $.data.images.[0].type or similar

otherwise we can also use a LINQ

4

Converting it doesn’t really answer the question of how to get the second tier value.

5

hm seems like the value filename,type and url are of type Jproperty?