1.4 DATA WAREHOUSE API LIMITATION | Community
Skip to main content
raviprasadp7863
Level 2
Aug 29, 2019 9:53 AM UTC
Solved

1.4 DATA WAREHOUSE API LIMITATION

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"

                                    }

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Hyder_Ziaee
Hyder_ZiaeeAccepted solution
Employee
Aug 30, 2019 6:18 AM UTC

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

          ]

     }

}

14 replies

jantzen_b
Employee
Mar 17, 2020 5:52 PM UTC

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.

Translate
Hyder_Ziaee
Employee
Aug 30, 2019 5:30 PM UTC

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.

Translate
raviprasadp7863
Level 2
Aug 30, 2019 3:13 PM UTC

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?

Translate
Hyder_Ziaee
Employee
Aug 30, 2019 2:29 PM UTC

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.

Translate
raviprasadp7863
Level 2
Aug 30, 2019 2:24 PM UTC
Hyder_Ziaee
Employee
Aug 30, 2019 12:10 PM UTC

I am using Postman as well:

What's your endpoint?

Translate
raviprasadp7863
Level 2
Aug 30, 2019 12:01 PM UTC

And am using postman to get the respose

Translate
raviprasadp7863
Level 2
Aug 30, 2019 12:00 PM UTC

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

Translate
Hyder_Ziaee
Employee
Aug 30, 2019 11:45 AM UTC

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

Are you adding any additional parameters?

Translate
raviprasadp7863
Level 2
Aug 30, 2019 11:20 AM UTC

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"

}

Translate