Data Warehouse API returning inflated data

Avatar

Avatar

chrisalvarespmg

Avatar

chrisalvarespmg

chrisalvarespmg

15-09-2020

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.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

ankits28281247

Employee

Avatar

ankits28281247

Employee

ankits28281247
Employee

15-09-2020

@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. 

Answers (2)

Answers (2)

Avatar

Avatar

Khurshid_Alam

Employee

Avatar

Khurshid_Alam

Employee

Khurshid_Alam
Employee

16-09-2020

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

Avatar

Avatar

chrisalvarespmg

Avatar

chrisalvarespmg

chrisalvarespmg

15-09-2020

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
}