Advertisements
Compare Data Query

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:

Json 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:

Showing json query syntax

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

Leave a Reply

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

%d bloggers like this: