Expand my Community achievements bar.

SOLVED

Omniture API 1.4 - Data Warehouse - Request

Avatar

Level 1

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?

1 Accepted Solution

Avatar

Correct answer by
Employee

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 solution in original post

2 Replies

Avatar

Correct answer by
Employee

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"

                                }

                }

}

Avatar

Level 1

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"

                                                }

                                    }

                        ]

            }

}