Expand my Community achievements bar.

Submissions are now open for the 2026 Adobe Experience Maker Awards

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

SOLVED

Data Warehouse API - port.dataWarehouseRequest()

Avatar

Level 1

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.

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

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.

View solution in original post

1 Reply

Avatar

Correct answer by
Employee Advisor

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.