Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

1.4 DATA WAREHOUSE API LIMITATION

raviprasadp7863
Level 2
Level 2

I was trying 1.4 Data warehouse API,@ was able to get the response too, but encountered one limitation like below:

"error_description": "The maximum number of elements supported is 4"

if I give more than 4 elements, its throwing error, is there any way to add more elements?

"elements":[

                                     {

                                           "id" : "zip"

                                    },

                                    {

                                           "id" : "evar8"

                                    },

                                     {

                                           "id" : "evar6"

                                    },

                                     {

                                           "id" : "evar77"

                                    },

                                    {

                                           "id" : "evar37"

                                    }

1 Accepted Solution
hyderziaee
Correct answer by
Employee
Employee

For data warehouse, you need to specify source as warehouse.

Try this code:

{

     "reportDescription":{

          "reportSuiteID":"<INSERT-RSID-HERE>",

          "dateFrom":"2019-08-10",

          "dateTo":"2019-08-11",

          "dateGranularity":"day",

          "source":"warehouse",

          "metrics":[

               {"id":"event10"}

          ],

          "elements":[

               {"id" : "zip"},

               {"id" : "evar8"},

               {"id" : "evar6"},

               {"id" : "evar77"},

               {"id" : "evar37"}

          ]

     }

}

View solution in original post

14 Replies
hyderziaee
Employee
Employee

What is the complete API request? Can you blank out the RSID and share?

raviprasadp7863
Level 2
Level 2

{

                "reportDescription":{

                                "reportSuiteID":"",

                                "dateFrom":"2019-08-10",

                                "dateTo":"2019-08-11",

                                "dateGranularity":"day",

                               

                                "metrics":[

                                                {

                                                                "id":"event10"

                                                }

                                ],

                                    "elements":[

                                     {

                                           "id" : ""

                                    },

                                    {

                                           "id" : ""

                                    },

                                     {

                                           "id" : ""

                                    },

                                     {

                                           "id" : ""

                                    },

                                    {

                                           "id" : ""

                                    }

                        ]

                }

}

if the elements upto 4 its giving response, but more than 4 throwing error

hyderziaee
Correct answer by
Employee
Employee

For data warehouse, you need to specify source as warehouse.

Try this code:

{

     "reportDescription":{

          "reportSuiteID":"<INSERT-RSID-HERE>",

          "dateFrom":"2019-08-10",

          "dateTo":"2019-08-11",

          "dateGranularity":"day",

          "source":"warehouse",

          "metrics":[

               {"id":"event10"}

          ],

          "elements":[

               {"id" : "zip"},

               {"id" : "evar8"},

               {"id" : "evar6"},

               {"id" : "evar77"},

               {"id" : "evar37"}

          ]

     }

}

raviprasadp7863
Level 2
Level 2

Already tried with this , was getting below error

{

    "error": "report_unsupported",

    "error_description": "This report type is unsupported by this method",

    "error_uri": "https://marketing.adobe.com/developer/documentation/analytics-reporting-1-4/errors"

}

hyderziaee
Employee
Employee

Did you use my code? I just ran with no problems at all.

Are you adding any additional parameters?

raviprasadp7863
Level 2
Level 2

I used the same code..Is there any limitation for the report suit?

raviprasadp7863
Level 2
Level 2

And am using postman to get the respose

hyderziaee
Employee
Employee

I am using Postman as well:

Annotation 2019-08-30 182149.jpg

What's your endpoint?

hyderziaee
Employee
Employee

The method is incorrect. The correct method is "Report.Queue".

Also, can you try with just api.omniture.com. The "5" is not necessary.

Report.Run is for real time report. It is not for Data Warehouse. Thus the request error.

raviprasadp7863
Level 2
Level 2

okay, got it, So to get the response we need to provide the FTP details in the request?

Can we point to S3 location other than FTP?

hyderziaee
Employee
Employee

The response you receive is the report ID. Next, you need to do a request with this endpoint:

https://api.omniture.com/admin/1.4/rest/?method=Report.Get

{

    "reportID": <INSERT-REPORT-ID>

}

This will give a JSON response, if the report is ready (processed). Otherwise it will give report not ready error.

You can also provide FTP/SFTP details if you want the file to be delivered to a file server. S3 is not supported.

jantzen_belliston-Adobe
Level 10
Level 10

Do any of these replies provide an answer to your original question? If so, please mark the most correct answer. If not, can you provide some additional details to help the community better answer your question.