Data Warehouse API returning inflated data | Community
Skip to main content
chrisalvarespmg
Level 2
Sep 15, 2020 5:44 PM UTC
Solved

Data Warehouse API returning inflated data

As of Saturday, any request made using the Data Warehouse API's Report.Queue has been returning considerably more data (roughly 10x more rows), inflating numbers when selecting more than 3 dimensions. When duplicating the report inside of Data Warehouse and setting the target to "email", the numbers return to normal, however, any request made using the API returns significantly more data.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
ankitshAccepted solution
Employee
Sep 15, 2020 6:05 PM UTC

@chrisalvarespmg  Can you provide more details, like what request you are making from data warehouse API and response you are getting that will help us in debugging the issue. 

View reply

14 replies

sobhacrystalhome
sobhacrystalhome
New Participant
Feb 27, 2024 9:41 AM UTC

Hi @ankitsh , nice posting.

Translate
jantzen_b
jantzen_b
Employee
Dec 3, 2020 8:20 PM UTC
Do any of the answers below answer your initial question? If so, can you select one of them as the correct answer? If none of the answers already provided answer your question, can you provide additional information to better help the community solve your question?
Translate
khurshid
khurshid
Employee
Sep 16, 2020 7:39 PM UTC

Can you try without currentData? May be that is causing the issue.

Translate
chrisalvarespmgAuthor
Level 2
Sep 15, 2020 6:33 PM UTC

Here is the request: 

Report.Queue: 

"reportDescription": {

    "reportSuiteID": "<redacted>",

    "dateFrom": "2020-09-08",

    "dateTo": "2020-09-13",

    "dateGranularity": "day",

    "metrics": [{

        "id": "revenue"

    },

    {

        "id": "visits"

    },

    {

        "id": "orders"

    },

    {

        "id": "allvisitors"

    }],

    "elements": [

    {

        "id": "mobiledevicetype",

        "everythingElse": true

    },

    {

        "id": "evar1",

        "everythingElse": true

    },

    {

        "id": "referringdomain",

        "everythingElse": true

    },

    {

        "id": "trackingcode",

        "everythingElse": true

    },

    {

        "id": "visitnumber",

        "everythingElse": true

    }],

    "locale": "en_US",

    "currentData": true,

    "source": "warehouse",

    "elementDataEncoding": "utf8"

    }

}

Report.Get 
{
     "reportId": "<redacted>"
     "format": "csv",
     "page": 1 //1,2,3,4,5,6,7, etc
}

Translate
ankitsh
Employee
Sep 15, 2020 6:39 PM UTC
need some more clarity and required further troubleshooting, do you have access to customercare or if you can share you email address we can get support ticket created for you.
Translate
ankitshAccepted solution
Employee
Sep 15, 2020 6:05 PM UTC

@chrisalvarespmg  Can you provide more details, like what request you are making from data warehouse API and response you are getting that will help us in debugging the issue. 

Translate
chrisalvarespmgAuthor
Level 2
Sep 15, 2020 6:29 PM UTC

@ankits28281247 posted as another comment.

Translate
Terms & ConditionsAccessibility statement

Loading footer...