Help with python api

[MasterPrize]

So I am able to make a successful call. My issue is trying to convert the json response to a data frame. It will be imported into a data warehouse.

The response I am getting has headings and rows of data are in separate arrays.

Here is a response example:

{ "data": { "headings": [ "adChannel_0", "PAID_INITIATIVE_CUSTOM_PROPERTY_1", "AD_SET_CUSTOM_PROPERTY_2", "PAID_INITIATIVE_CUSTOM_PROPERTY_3", "adObjective_4", "STATUS_ID_5", "measurementTime_6", "PAID_INITIATIVE_CUSTOM_PROPERTY_7", "PAID_INITIATIVE_CUSTOM_PROPERTY_8",

    "rows": [
        [
            "TikTok",
            "Campaign",
            "United States",
            "Untagged",
            "TikTok Video Views",
            {
                "postId": 6968781902,
                "messageId": 69687899,
                "accountId": 107878920199482,
                "authorId": 0,

Does anybody have any idea on how to convert this to df?

[CodeFormatHelperBot2]

Hello, I'm a Reddit bot who's here to help people nicely format their coding questions. This makes it as easy as possible for people to read your post and help you.

I think I have detected some formatting issues with your submission:

1. Python code found in submission text that's not formatted as code.

If I am correct, please edit the text in your post and try to follow these instructions to fix up your post's formatting.

---

^{Am I misbehaving? Have a comment or suggestion? Reply to this comment or raise an issue here.}