ABAP中使用CL_HTTP_CLIENT如何捕获HTTPS后台下载的Excel文件

核心原因 #

浏览器访问目标URL时，会自动识别Content-Disposition: attachment响应头触发下载，而你当前的CL_HTTP_CLIENT请求因缺少必要请求头，导致服务器返回空白HTML而非实际Excel数据。

解决方案步骤 #

1. 模拟浏览器完整请求头 #

服务器可能依据请求头判断客户端类型并返回不同内容，需在CL_HTTP_CLIENT中添加浏览器常用请求头：

DATA(lo_http_client) = cl_http_client=>create_by_url( iv_url = '你的目标HTTPS URL' ).
lo_http_client->request->set_header_field( iv_name = 'User-Agent' iv_value = 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/118.0.0.0 Safari/537.36' ).
lo_http_client->request->set_header_field( iv_name = 'Accept' iv_value = 'text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8' ).
lo_http_client->request->set_header_field( iv_name = 'Accept-Language' iv_value = 'zh-CN,zh;q=0.8,en-US;q=0.5,en;q=0.3' ).
lo_http_client->request->set_header_field( iv_name = 'Accept-Encoding' iv_value = 'gzip, deflate, br' ).
lo_http_client->request->set_header_field( iv_name = 'Connection' iv_value = 'keep-alive' ).
lo_http_client->request->set_header_field( iv_name = 'Upgrade-Insecure-Requests' iv_value = '1' ).

2. 校验响应头确认数据类型 #

发送请求后，先检查响应头判断服务器是否返回Excel数据：

lo_http_client->send( ).
lo_http_client->receive( ).

* 读取关键响应头
DATA(lv_content_type) = lo_http_client->response->get_header_field( iv_name = 'Content-Type' ).
DATA(lv_content_disposition) = lo_http_client->response->get_header_field( iv_name = 'Content-Disposition' ).

WRITE: / 'Content-Type:', lv_content_type.
WRITE: / 'Content-Disposition:', lv_content_disposition.

若Content-Type为application/vnd.ms-excel或text/csv（匹配你传入的csv=X参数），且Content-Disposition包含attachment，说明响应体即为Excel数据。

3. 读取响应体并保存为Excel文件 #

确认数据类型后，直接读取响应体并保存：

DATA(lv_excel_data) = lo_http_client->response->get_data( ).

* 保存到本地客户端（需GUI权限）
DATA(lo_file_path) = cl_gui_frontend_services=>create_local_file( iv_title = '保存Excel文件' iv_default_extension = 'XLSX' ).
IF lo_file_path IS NOT INITIAL.
  cl_gui_frontend_services=>gui_download(
    EXPORTING
      filename = lo_file_path
      filetype = 'BIN'
    CHANGING
      data_tab = lv_excel_data
  ).
ENDIF.

* 或保存到应用服务器
OPEN DATASET '/usr/sap/trans/report_excel.xlsx' FOR OUTPUT IN BINARY MODE.
TRANSFER lv_excel_data TO '/usr/sap/trans/report_excel.xlsx'.
CLOSE DATASET '/usr/sap/trans/report_excel.xlsx'.

4. 手动处理重定向场景 #

若服务器返回3xx重定向状态码，CL_HTTP_CLIENT默认不会自动跳转，需手动处理：

DATA(lv_status) = lo_http_client->response->get_status( ).
IF lv_status CS '3'.
  DATA(lv_redirect_url) = lo_http_client->response->get_header_field( iv_name = 'Location' ).
  lo_http_client->close( ).
  lo_http_client = cl_http_client=>create_by_url( iv_url = lv_redirect_url ).
  * 重新添加请求头后发送请求
  lo_http_client->request->set_header_field( iv_name = 'User-Agent' iv_value = 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/118.0.0.0 Safari/537.36' ).
  lo_http_client->send( ).
  lo_http_client->receive( ).
  lv_excel_data = lo_http_client->response->get_data( ).
ENDIF.

额外注意事项 #

• 确保ABAP系统已配置HTTPS访问的SSL证书信任，否则请求会失败。
• 若服务器校验会话Cookie，需先模拟登录获取Cookie并在请求中携带：

  DATA(lv_session_cookie) = 'SESSIONID=xxxxxx; Path=/; Secure; HttpOnly'.
  lo_http_client->request->set_header_field( iv_name = 'Cookie' iv_value = lv_session_cookie ).
  

内容的提问来源于stack exchange，提问作者Vishnu Tallapragada