Problem saving HTTP Graph API call data from json to CSV file

(0) Share

Report

Posted on by AA-20080012-0

106

Hi Team,

Problem saving HTTP Graph API call data from json to CSV file. I am able to get the filtered data for Jail Broken devices list from managed devices from Graph API filtered data:

https://graph.microsoft.com/v1.0/deviceManagement/managedDevices?$filter=managementAgent eq 'mdm' and jailBroken eq 'True'

Parse JSON from HTTP data saved the schema properly & I could see there are 4 devices that came up, which is good. But I am not able to move the data from here to a CSV file. For each value from Parse Jason data is saved in CSV table. It will only take value as array content & not any object or other items. When I fixed this, its capturing all 4 items in the from section of csv table but sending Output for only one item. What exactly is missing here? Here are the snapshots:

Thanks

Arindam

Categories:

Business Process Flows

All responses (2)

Answers (0)

AA-20080012-0 106 on at

Like (0)

Report

Re: Problem saving HTTP Graph API call data from json to CSV file

Hi GrantJenkins,
Thanks for your reply. It worked.
Thanks for your help.

Thanks
Arindam
grantjenkins 11,059 Super User 2025 Season 1 on at

Like (0)

Report
Re: Problem saving HTTP Graph API call data from json to CSV file

Directly after your Parse JSON you should have your Create CSV table taking in the output from Parse JSON. So the Create CSV table should NOT be within an Apply to each.

body('Parse_JSON')?['value']