Struggling to Export Data from "Get HTTP Request" to CSV

(0) Share

Report

Posted on by CactusJ

So I have a GrapAPI call set up and working, using "Send an HTTP Request". This works and provides results.

I have Parse JSON after that, and the schema is from the results of "Send an HTTP Request"

Parse JSON works as expected, and I can get it to run result. But I can't find the way to get the results from Parse JSON to a CSV. There results are always empty.

I am probably missing something very obvious. Currently I am getting an error in the Apply to Each.. I think I have been staring at this too long

I'd appreciate if someone was able to point me in the correct direction - I want to make this work, but I can't figure out how to get the JSON outputted to CSV. I don't know the right questions to ask.

Thanks,

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (1)

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report

Hi @CactusJ

You could directly pass the value array from the output of "Parse Json" action to create csv table action:

Output:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
CactusJ 11 on at

Like (0)

Report

Thanks,

Currently Getting:

I really appreciate the help..

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report

Pls try with the below schema in parse json action:

{

    "type": "object",

    "properties": {

        "statusCode": {

            "type": "integer"

        },

        "headers": {

            "type": "object",

            "properties": {

                "Cache-Control": {

                    "type": "string"

                },

                "Transfer-Encoding": {

                    "type": "string"

                },

                "Vary": {

                    "type": "string"

                },

                "Strict-Transport-Security": {

                    "type": "string"

                },

                "request-id": {

                    "type": "string"

                },

                "client-request-id": {

                    "type": "string"

                },

                "x-ms-ags-diagnostic": {

                    "type": "string"

                },

                "x-ms-resource-unit": {

                    "type": "string"

                },

                "OData-Version": {

                    "type": "string"

                },

                "Timing-Allow-Origin": {

                    "type": "string"

                },

                "x-ms-apihub-cached-response": {

                    "type": "string"

                },

                "x-ms-apihub-obo": {

                    "type": "string"

                },

                "Date": {

                    "type": "string"

                },

                "Content-Type": {

                    "type": "string"

                },

                "Content-Length": {

                    "type": "string"

                }

            }

        },

        "body": {

            "type": "object",

            "properties": {

                "@@odata.context": {

                    "type": "string"

                },

                "value": {

                    "type": "array",

                    "items": {

                        "type": "object",

                        "properties": {

                            "businessPhones": {

                                "type": "array",

                                "items": {

                                    "type": "string"

                                }

                            },

                            "displayName": {

                                "type": "string"

                            },

                            "givenName": {

                                "type": "string"

                            },

                            "jobTitle": {

                                "type": "string"

                            },

                            "mail": {

                                "type": "string"

                            },

                            "mobilePhone": {},

                            "officeLocation": {

                                "type": "string"

                            },

                            "preferredLanguage": {

                                "type": "string"

                            },

                            "surname": {

                                "type": "string"

                            },

                            "userPrincipalName": {

                                "type": "string"

                            },

                            "id": {

                                "type": "string"

                            }

                        },

                        "required": [

                            "businessPhones",

                            "displayName",

                            "givenName",

                            "jobTitle",

                            "mail",

                            "mobilePhone",

                            "officeLocation",

                            "preferredLanguage",

                            "surname",

                            "userPrincipalName",

                            "id"

                        ]

                    }

                }

            }

        }

    }

}

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
CactusJ 11 on at

Like (0)

Report

Same issue..

Is this because BusisnessPhones is an Array? Or because some of the values are null ?

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report

Pls verify if "Send an HTTP request" is returning users data from the graph api. It looks like value array is null or empty.

Also verify the value object by hovering mouse over it:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
CactusJ 11 on at

Like (0)

Report
Data is for sure being returned.. you can see the results from Parse JSON in my very first screenshot... I just blacked out the user names and other info...

Here is the HTTP Request:

https://graph.microsoft.com/v1.0/users?$filter=employeeid ne null and accountEnabled ne false&$count=true

Thanks for looking at this with me, I am stumped as to why this is so difficult.

Was this reply helpful? Yes No
Verified answer

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (1)

Report
Pls use the below expression in 'From' parameter of "Create CSV table". Expression needs to be added in the expression box:

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

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
CactusJ 11 on at

Like (0)

Report

Holy Heck Batman, it worked

What did I learn from this ? my "value" was wrong? Why ?

Thank you very much.

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report

The value from dynamic content was incorrect. Alternatively, we can enter the value object in the form of expression. So, the expression worked.

I am glad it solves your problem 🙂

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No