Query json in Microsoft Flow

One of the important fundamental parts of Microsoft Flow development is understanding how  to query json. Some data is made available in part of the flow by an action and now you need to get to an element of this data.
As a simple example of json we can have data like this:
{
"level1": { "level2": "data"}
}
Many people would now use the following syntax to query the json to get to the level2 data:
outputs('Compose')?['level1']?['level2']

This would give you:

Data

A similar query approach, with a slightly different syntax can be:

outputs('Compose')?['level1/level2']

At first I didn’t really see too much of an advantage of using this syntax, but when you reopen the flow you will see the advantage straight away:

Now compare that with the other syntax:

Compare Data Query

The query on the Compose json actually shows the elements that your flow will try query.

 

 

Advertisements

Please leave a comment or feedback

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.