查詢對賬單下載下傳位址接口（alipay.data.dataservice.bill.downloadurl.query）測試之“入參不合法”

這個接口是下載下傳離線賬單的，需要T+1天生成賬單，不能查詢當日或者是當月的賬單，如果日期是當天或者是當月的會傳回“參數不合法”；

詳情請點選

檢視文檔

下載下傳對賬單位址接口隻有當面付接口可以下載下傳trade類型的賬單，其他支付接口隻能下載下傳signcustomer這個類型的 

代碼示例：

package com.alipay.demo;
  
import com.alipay.api.AlipayApiException;
import com.alipay.api.AlipayClient;
import com.alipay.api.DefaultAlipayClient;
import com.alipay.api.domain.AlipayDataDataserviceBillDownloadurlQueryModel;
import com.alipay.api.request.AlipayDataDataserviceBillDownloadurlQueryRequest;
import com.alipay.api.response.AlipayDataDataserviceBillDownloadurlQueryResponse;
import com.alipay.config.AlipayConfig;
  
/**
 * 
 * alipay.data.dataservice.bill.downloadurl.query (查詢對賬單下載下傳位址)
 * @author wb-wly251833
 *
 */
public class AlipayDataDataserviceBillDownloadurlQuery {
      
    public static void main(String[] args) throws AlipayApiException {
                 AlipayClient alipayClient = new DefaultAlipayClient("https://openapi.alipay.com/gateway.do", Config.appId, Config.privateKey, "json","utf-8", Config.alipayPulicKey, "RSA2");
        AlipayDataDataserviceBillDownloadurlQueryRequest request =  new AlipayDataDataserviceBillDownloadurlQueryRequest();
        AlipayDataDataserviceBillDownloadurlQueryModel model = new AlipayDataDataserviceBillDownloadurlQueryModel();
        //賬單時間：日賬單格式為yyyy-MM-dd，月賬單格式為yyyy-MM。必須是前一天或者上一個月，不能當天當月
        model.setBillDate("2017-12");
//      model.setBillDate("2018-01-08");
        //賬單類型，trade指商戶基于支付寶交易收單的業務賬單；signcustomer是指基于商戶支付寶餘額收入及支出等資金變動的帳務賬單；
        model.setBillType("trade");
        request.setBizModel(model);
        AlipayDataDataserviceBillDownloadurlQueryResponse response = alipayClient.execute(request);
        System.out.println("傳回資訊："+response.getBody());
        System.out.println("賬單下載下傳位址連結(BillDownloadUrl):"+response.getBillDownloadUrl());
        if(response.isSuccess()){
        System.out.println("調用成功");
        } else {
        System.out.println("調用失敗");
        }
          
    }
  
}           

注：   正式環境網關：https://openapi.alipay.com/gateway.do   正式環境網關：

https://openapi.alipaydev.com/gateway.do

 傳回資訊：

{"alipay_data_dataservice_bill_downloadurl_query_response":{"code":"10000","msg":"Success","bill_download_url":"http:\/\/dwbillcenter.alipaydev.com\/downloadBillFile.resource?bizType=trade&userId=20881021701192600156&fileType=csv.zip&bizDates=201712&downloadFileName=20881021701192600156_201712.csv.zip&fileId=%2Ftrade%2F20881021701192600156%2F201712.csv.zip&timestamp=1515487931&token=196dab0559f25bc04221b04080d8fbb9"},"sign":"V7JWM3LxoboMPRsBD0ixMWO63JoEvpSnhb15NpLwOM6pBBJN93us8NXXqAcp4EyLtxRZlMhWHQXeO5AP2GWY7BSH1rBoNb2up7u73zNP0zHGcC1upRbR5zz7YFk4LQpFqBuluB+2pPVJbOxrMF6kiNcKj/uF729JAkDDB8TIaK5X0XZun96vug5cjAHcJjbrnatkjjMpL9EQjs42r9w+ixJiUjHXBKodPpGvAD6YpYnoRsM97jSVfG4xO6BwxQrqDCJ4FPAMNVSQdsTfas277MBCkNjrtG1muFfUQNO+roIXUU7N4ouT8k78hJdj7O+jpKqlR3lq8subR4knpOVoEg=="}           

根據傳回資訊我們擷取到url

http://dwbillcenter.alipaydev.com/downloadBillFile.resource?bizType=trade&userId=20881021701192600156&fileType=csv.zip&bizDates=201712&downloadFileName=20881021701192600156_201712.csv.zip&fileId=           

将通路url擷取到兩個excel檔案 

我這邊使用的是沙箱測試，是以擷取到的隻是賬單模闆，想要下載下傳擷取賬單資料，需使用正式環境測試； 

1、賬單業務明細模闆： 

2.賬單業務明細彙總