Data Warehouse API returning inflated data | Community
Skip to main content
C
chrisalvarespmg
Level 2
September 15, 2020
Solved

Data Warehouse API returning inflated data

  • September 15, 2020
  • 5 replies
  • 6020 views

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.
Best answer by ankitsh

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

5 replies

A
Adobe Employee
ankitshAdobe EmployeeAccepted solution
Adobe Employee
September 15, 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. 

C
chrisalvarespmgAuthor
Level 2
September 15, 2020

@ankits28281247 posted as another comment.

C
chrisalvarespmgAuthor
Level 2
September 15, 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
}

A
Adobe Employee
ankitshAdobe Employee
Adobe Employee
September 15, 2020

@pmgp52464762 unfortunately I don't think there is a fix, This is being work upon, will update this thread as soon as fix is in place.

khurshid
Adobe Employee
khurshidAdobe Employee
Adobe Employee
September 16, 2020

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

jantzen_b
Adobe Employee
jantzen_bAdobe Employee
Adobe Employee
December 3, 2020
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?
sobhacrystalhome
sobhacrystalhome
February 27, 2024

Hi @ankitsh , nice posting.

Terms & ConditionsAccessibility statement

Loading footer...