Data Warehouse API - port.dataWarehouseRequest() | Community
Skip to main content
October 16, 2015
Solved

Data Warehouse API - port.dataWarehouseRequest()

  • October 16, 2015
  • 1 reply
  • 856 views

Hi,

We’re trying to send a request to Data Warehouse API but the Request ID is returning “0”. Please, can someone help us showing if there’s anything wrong in this request ? Following is the code we’re developing and the parameters to the request:

                    String reportSuiteId = "adp.sj.xxxx-xxxxxxxxxxxx";

                    String contactName = "Company";

                    String contactPhone = "+559999999999";

                    String emailAddress = "xxx@xxx.com.br";

                    String[] rsid_list = new String[1];

                    rsid_list[0] = reportSuiteId;

 

// Define the breakdown list

                    String[] breakdown_List = new String[3];

                    breakdown_List[0] = "prop14";

                    breakdown_List[1] = "prop15";

                    breakdown_List[2] = "mobilerep_device_type";

                                       

                    // Define the metric list  

                    String[] metric_List = new String[3];

                   metric_List[0] = "visitors";

                    metric_List[1] = "page_time";

                    metric_List[2] = "prodView";

 

// Send the Data Warehouse request

                    int reportID = port.dataWarehouseRequest(

                                 breakdown_List, /* Breakdown List */

                                 contactName, /* Contact Name */

                                 contactPhone, /* Contact Phone */

                                 "05/29/15", /* Date From */

                                 "day", /* Date Granularity */

                                 "", /* Date Preset */

                                 "05/29/15", /* Date To */

                                 "range", /* Date Type */

                                 "DW_API-Request_Solicitado", /* Email Subject */

                                 emailAddress, /* Email To */

                                 "", /* FTP Dir */

                                 "send_via_api", /* FTP Host */

                                 "", /* FTP Password */

                                 22, /* FTP Port */

                                 "", /* FTP Username */

                                 "analytics_dw_report", /* File Name */

                                 metric_List, /* Metric List */

                                 "DW_API_Report_Suite_Descricao", /* Report Desc */

                                 "DW_API_Report_Suite_Nome", /* Report Name */

                                  reportSuiteId /* Report Suite Id */

                    );

 

Thank you.

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 Gigazelle

Could you try removing the FTP Host and FTP Port strings? It looks like you're sending the request via email, and it only supports one method or the other.

1 reply

Gigazelle
Adobe Employee
GigazelleAdobe EmployeeAccepted solution
Adobe Employee
October 16, 2015

Could you try removing the FTP Host and FTP Port strings? It looks like you're sending the request via email, and it only supports one method or the other.