cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
raghavendrac
Level: Powered On

Getting JSON keys in flow

Hi below is the JSON format I am getting from planner API I want User id's from this.

 

{
  "planId": "plan id",
  "bucketId": "bucket Id",
  "title": "test multiple user",
  ...
  ...
  ..
  ..
  "assignments": {
    "User ID 1": {
      ...
      ...
    },
    "User ID 2": {
      ...
      ...
    },
    "User ID 2": {
      ...
      ...
    }
  }
}

Here I want "User ID 1", "User ID 2", "User ID 3". I cant use for each because it's an object, not an array. please help with this.

 

1 ACCEPTED SOLUTION

Accepted Solutions
royg
Level: Powered On

Re: Getting JSON keys in flow

Hi, this may be a little too late for the initiator of this thread, but hopefully it may help others.

I give all the credit for this solution to the writer of this blog post (John) who faced the same requirement and suggested using xml/xpath methods.

The real magic is getting the assignments JSON object and converting it to XML.

to do that use a compose action that concatenates a root level to the assignments json (using the assignments JSON without the root fails because attirbutes at the top level get converted creating mutilpe root items).

Compose:

xpath(xml(json(concat('{ "root": ', string(body('HTTPTaskAssignments')), ' }'))
), '/root/assignments/*')
*Note - remember to add the blank space before and after the "root": and before the appended curly braces or your json won't be parsed to xml. Also, stringify the assignments json, This can be broken into several compose actions for readability.
 
The next step is to select the result xml nodes into an array using Select action, use the previous step's Output and map into a new property (UserId for example) the xmlnode name.
Expression:
xpath(item(), 'name(/*)')
 
PlannerFlow.PNG
 
That's it, now you can iterate the select action result to perform actions such as getting the user name etc.
 
Hope this helps someone!
 

View solution in original post

9 REPLIES 9
Sru
Level 8

Re: Getting JSON keys in flow

Hi @raghavendrac

 

use parse jason and apply for each to grab the values using Dynamic content.

formated  your json  and tried, able to see user id values in for each loop. Hope it helps.

 

{
  "planId": "plan id",
  "bucketId": "bucket Id",
  "title": "test multiple user",
  "assignments": [{
    "User ID 1": "a",
    "User ID 2": "b",
    "User ID 3" : "c"
      }]
 
}

 

raghavendrac
Level: Powered On

Re: Getting JSON keys in flow

Thanks for the reply, but for each loop will work only if its array. But my scenario there is no array.

It's a javascript objects with the key-value pair, and I want the list of keys.

Community Support Team
Community Support Team

Re: Getting JSON keys in flow

Hi @raghavendrac,

 

Do you want to use "User ID 1", "User ID 2" and "User ID 3" within "Apply to each" in your flow?

Could you please share a screenshot of your flow's configuration?

Further, do you want to get the "User ID 1" key (User ID 2, User ID 3) or its corresponding value?

 

Yes, you are right. The input parameter of "Apply to each" action is required to fill an array rather than an object. So within your flow, you should convert the Object data into an array firstly, then you could use your JSON data within your "Apply to each" action.

 

If you want to get the "User ID 1" (User ID 2, User ID 3) key within a "Apply to each" action, I afraid that there is no way to get the "User ID 1" (User ID 2, User ID 3) key in Microsoft Flow currently. I have no idea how to get the JSON key within a "Apply to each" action.

 

If you want to get the corresponding value of "User ID 1" ((User ID 2, User ID 3)) key, please take a try with the following workaround:

  • Add a proper trigger, here I use Flow Button trigger.
  • Add a Compose action, Inputs field set to the original JSON format data that you provided as below:
{
  "planId": "plan id",
  "bucketId": "bucket Id",
  "title": "test multiple user",
  "assignments": {
    "User ID 1": {
      "Name": "Kris Dai"
    },
    "User ID 2": {
      "Name": "Angelina"
    },
    "User ID 3": {
      "Name": "Teresa"
    }
  }
}
  • Add a "Compose 2" action, Inputs set to following formula:
array(outputs('Compose')?['assignments'])
  • Add a "Apply to each" action, input parameter set to output of "Compose 2" action.
  • Within "Apply to each", add a "Compose 3" action, Input set to following formula:
item()?['User ID 1']

Note: If you want to get the corresponding value of User ID 2 and User ID 3, please type following formula within above Compose 3 action:

item()?['User ID 2']
item()?['User ID 3']

Image reference:13.JPG

 

14.JPG

The flow works successfully as below:15.JPG

 

 

 

Best regards,

Kris

 

 

 

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
raghavendrac
Level: Powered On

Re: Getting JSON keys in flow

Thanks for your help.

But I need the JSON keys ('User ID 1', 'User ID 3', 'User ID 3') not values so the logic won't work for my scenario.

And even if you put JSON object inside an array you will get same JSON Object while iterating, you won't get the JSON keys or values. so solution won't work.

 

My goal is to get the user ids, Planner API providing the "assignments" JSON object (Not an array).

This JSON object will have "User ID" as key and "User Details" as values.

Since a task can be assigned to anyone, so values inside "assignments" object are dynamic.

I cant hard code the values to get the user id because I will not be knowing to whom the task is assigned.

testasdfasfsafa
Level: Powered On

Re: Getting JSON keys in flow

I have the same problem...  I have JSON returning a bunch of Key and Values and ALL I want to do is to get the value of specific key... why is this so complicated?  Flow is supposed to be for power users, not for developers or ODATA gurus...

StevenWade
Level: Powered On

Re: Getting JSON keys in flow

having the SAME issue with the planner API. not sure whether i'm more annoyed at flow (for not allowing the ability to grab the key from key/value pairs) or at the Planner API team (who thought it would be a great idea to use the user id as an object key instead of the value).

 

either way, i don't have any ability to associate user-readable names with assigned planner tasks.

StevenWade
Level: Powered On

Re: Getting JSON keys in flow

If anyone is curious, here's the assignments object returned within the task object:

 

SyntaxEditor Code Snippet

 "assignments": {
      "96586a3d-314e-4146-8def-1dfe72a0a733": {
        "@odata.type": "#microsoft.graph.plannerAssignment",
        "assignedDateTime": "2018-10-08T14:47:31.8329019Z",
        "orderHint": "",
        "assignedBy": {
          "user": {
            "displayName": null,
            "id": "96586a3d-314e-4146-8def-1dfe72a0a733"
          }
        }
      },
      "5b9c9288-4e23-43ba-be30-3eca86e43459": {
        "@odata.type": "#microsoft.graph.plannerAssignment",
        "assignedDateTime": "2018-10-08T14:47:36.7608382Z",
        "orderHint": "",
        "assignedBy": {
          "user": {
            "displayName": null,
            "id": "96586a3d-314e-4146-8def-1dfe72a0a733"
          }
        }
      }
    }
  }
StevenWade
Level: Powered On

Re: Getting JSON keys in flow

Ok...i came up with one hack of a solution for this that involved creating an Azure Function App (using the underscore.js library) to extract the user id keys, and then calling that app with an http POST from my Flow. It seriously shouldn't have to be this hard.

royg
Level: Powered On

Re: Getting JSON keys in flow

Hi, this may be a little too late for the initiator of this thread, but hopefully it may help others.

I give all the credit for this solution to the writer of this blog post (John) who faced the same requirement and suggested using xml/xpath methods.

The real magic is getting the assignments JSON object and converting it to XML.

to do that use a compose action that concatenates a root level to the assignments json (using the assignments JSON without the root fails because attirbutes at the top level get converted creating mutilpe root items).

Compose:

xpath(xml(json(concat('{ "root": ', string(body('HTTPTaskAssignments')), ' }'))
), '/root/assignments/*')
*Note - remember to add the blank space before and after the "root": and before the appended curly braces or your json won't be parsed to xml. Also, stringify the assignments json, This can be broken into several compose actions for readability.
 
The next step is to select the result xml nodes into an array using Select action, use the previous step's Output and map into a new property (UserId for example) the xmlnode name.
Expression:
xpath(item(), 'name(/*)')
 
PlannerFlow.PNG
 
That's it, now you can iterate the select action result to perform actions such as getting the user name etc.
 
Hope this helps someone!
 

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,121)