1.4 DATA WAREHOUSE API LIMITATION

raviprasadp7863

29-08-2019

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"

                                    }

Accepted Solutions (1)

Accepted Solutions (1)

hyderziaee

Employee

29-08-2019

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"}

          ]

     }

}

Answers (13)

Answers (13)

hyderziaee

Employee

30-08-2019

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.

hyderziaee

Employee

30-08-2019

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.

jantzen_belliston-Adobe

Community Manager

17-03-2020

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.

raviprasadp7863

29-08-2019

{

                "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