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:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

grantjenkins 11,063 Moderator on at

Like (0)

Report
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']

Was this reply helpful? Yes No
AA-20080012-0 106 on at

Like (0)

Report

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

Thanks
Arindam

Was this reply helpful? Yes No