Omniture API 1.4 - Data Warehouse - Request | Community
Skip to main content
September 30, 2016
Solved

Omniture API 1.4 - Data Warehouse - Request

  • September 30, 2016
  • 2 replies
  • 5342 views

I see in the documentation here: https://marketing.adobe.com/developer/documentation/analytics-reporting-1-4/get-started that version 1.3 is now deprecated. Does this include the Data Warehouse services? Or, are the Analytics and Data Warehouse services separate? I attempted to create a DataWarehouse.Request with 1.4 and got an error code of 501 (Not implemented). Are we safe continuing to use 1.3 for the DataWarehouse?

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 ChristopheProtat

Hello,

I assume you found out the solution due to the request date but anyway here is a sample REST call using the API 1.4 for Datawarehouse report queue.

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

{

                "reportDescription":{

                                "reportSuiteID":"xxxxxx",

                                "dateFrom":"2017-01-01",

                                "dateTo":"2017-04-28",

                                "dateGranularity":"month",

                                "metrics":[

                                                {

                                                                "id":"revenue"

                                                }

                                ],

                                "segments":[

                                                {

                                                                "id":"s300002816_5adf9868de3c97316a2e8694"

                                                }

                                ],           

                                "source":"warehouse",

                                "ftp":

                                {

                                                "host":"sftp:xxxxxx.com",

                                                "port":"22",

                                                "directory":"xxxxxxx",

                                                "username":"xxxxxxx",

                                                "password":"",

                                                "filename":"myReport.csv"

                                }

                }

}

2 replies

ChristopheProtatAdobe EmployeeAccepted solution
Adobe Employee
April 29, 2018

Hello,

I assume you found out the solution due to the request date but anyway here is a sample REST call using the API 1.4 for Datawarehouse report queue.

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

{

                "reportDescription":{

                                "reportSuiteID":"xxxxxx",

                                "dateFrom":"2017-01-01",

                                "dateTo":"2017-04-28",

                                "dateGranularity":"month",

                                "metrics":[

                                                {

                                                                "id":"revenue"

                                                }

                                ],

                                "segments":[

                                                {

                                                                "id":"s300002816_5adf9868de3c97316a2e8694"

                                                }

                                ],           

                                "source":"warehouse",

                                "ftp":

                                {

                                                "host":"sftp:xxxxxx.com",

                                                "port":"22",

                                                "directory":"xxxxxxx",

                                                "username":"xxxxxxx",

                                                "password":"",

                                                "filename":"myReport.csv"

                                }

                }

}

architj
August 30, 2018

Hi,

I was checking if you have a similar query for Summary Reports like below for POSTMAN? I am not sure where to put Shared Secret details for Authentication and get the data.

{

            "reportDescription":{

                        "reportSuiteID":"xyz",

                "dateFrom":"yyyy-mm-dd",

                "dateTo":"yyyy-mm-dd",

                        "dateGranularity":"YEAR",

                        "metrics":[

                                    {

                                                "id":"pageviews"

                                    }

                        ],

                        "elements":[

                                    {

                                           "id" : "page",

                                                "search":{

                                                            "keywords":[

                                                                        "xyz"

                                                            ],

                                                            "type" : "OR"

                                                }

                                    }

                        ]

            }

}