cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
robofski
Helper II
Helper II

Http Request - Parse JSON - Filter Array

I have a flow that is using a http request to graph API to retrieve some user details.

I'm taking the output from the http request and formatting it with a Parse JSON action.

When I then try to use filter array on the parse JSON output I get the following error:

The 'from' property value in the 'query' action inputs is of type 'Null'. The value must be an array.

Here's a sample of the output from the parse JSON which is not null!

{
    "value": [
      {
        "userType": "Member",
        "accountEnabled": true,
        "employeeId": "Mexico",
        "displayName": "User1",
        "userPrincipalName": "User1@company.com"
      },
      {
        "userType": "Member",
        "accountEnabled": true,
        "employeeId": "Mexico",
        "displayName": "user2",
        "userPrincipalName": "user2@company.com"
      },
      {
        "userType": "Member",
        "accountEnabled": true,
        "employeeId": "1043",
        "displayName": "user3",
        "userPrincipalName": "user3@company.com"
      },
      {
        "userType": "Member",
        "accountEnabled": true,
        "employeeId": "5935",
        "displayName": "user4",
        "userPrincipalName": "user4@company.com"
      }
    ]
  }
 
Any pointers? 
2 REPLIES 2
Mari
Community Support
Community Support

Hi! Could you try to save the same output that you pass to the "From" field in a Compose before the Filter Array action? Run the flow and check if the results in the Compose are indeed null.

 

Best regards,

 

Community Support Team - Mari
If this post helps, then please consider Accept as solution to help the other members find it more quickly.

Nice idea but still fails.  When I pass the "Value" from the parse JSON to the compose if I try to view the output there is nothing!  If I pass the body then the filter array doesn't like it because it's an object not an array.

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (1,796)