
Announcements
Hello everyone,
I am trying to request a API with GET Method, but after transform JSON Code returned in Custom Object, I have 2 tables and I only can acess 1 table. See JSON returned below:
{
"Number1":{"Age":"25","Name":"Gustavo","LastName":"Penedo"},
"Number2":{"Age":"30","Name":"Lucas","LastName":"Silva"}
}
I can acess a table with "%table['Number1']%", and it returns to me "{"Age":"25","Name":"Gustavo","LastName":"Penedo"}", but I can't select only a Name, or a Age...
Can you help me?
Hi There,
To access specific properties within the JSON object, you should use the appropriate expressions in Power Automate.
To access the ‘Name’ property for ‘Number1’:
outputs('JSON_PARSE_ACTION_NAME')?['body/Number1/Name']
To access the ‘Age’ property for ‘Number1’:
outputs(‘’JSON_PARSE_ACTION_NAME')?['body/Number1/Age']
Replace 'JSON_PARSE_ACTION_NAME' with the name of your 'Parse JSON' action.
Please give kudos and mark as solution if it helps.
Thanks,
Sandeep Mishra