Omniture API 1.4 - Data Warehouse - Request | Community
Skip to main content
eidolon-eRp7bE
New Participant
Sep 30, 2016 7:49 PM UTC
Solved

Omniture API 1.4 - Data Warehouse - Request

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.
ChristopheProtatAccepted solution
Employee
Apr 29, 2018 3:25 PM UTC

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"

                                }

                }

}

View reply

2 replies

architj
architj
New Participant
Aug 30, 2018 9:01 AM UTC

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"

                                                }

                                    }

                        ]

            }

}

Translate
ChristopheProtatAccepted solution
Employee
Apr 29, 2018 3:25 PM UTC

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"

                                }

                }

}

Translate
Terms & ConditionsAccessibility statement

Loading footer...