1.4 DATA WAREHOUSE API LIMITATION | Community
Skip to main content
raviprasadp7863
raviprasadp7863
Level 2
August 29, 2019
Solved

1.4 DATA WAREHOUSE API LIMITATION

  • August 29, 2019
  • 14 replies
  • 16205 views

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

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

Show previous replies
Hyder_Ziaee
Adobe Employee
Hyder_ZiaeeAdobe Employee
Adobe Employee
August 30, 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.

    raviprasadp7863
    raviprasadp7863Author
    Level 2
    August 30, 2019

    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?

    Hyder_Ziaee
    Adobe Employee
    Hyder_ZiaeeAdobe Employee
    Adobe Employee
    August 30, 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.

      jantzen_b
      Adobe Employee
      jantzen_bAdobe Employee
      Adobe Employee
      March 17, 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.

      Terms & ConditionsAccessibility statement

      Loading footer...