Download Channel Winning Records

Updated: 2022-09-27 11:32:05

Interface Description

1、导出频道的单抽奖的中奖用户列表的中奖文件
2、导出表格格式可具体参考直播后台的导出中奖记录功能
3、接口支持https协议

Interface URL

http://api.polyv.net/live/v3/channel/lottery/download-winner-detail

Request Method

GET

Interface Constraints

The interface supports both HTTP and HTTPS. HTTPS is recommended to ensure interface security. The interface has call frequency limits. For details, please see

Request Parameter Description

Parameter	Required	Type	Description
appId	true	String	Account appId [See Get Secret Key]
timestamp	true	Long	Current 13-digit millisecond timestamp, valid for 3 minutes
sign	true	String	Signature, a 32-character uppercase MD5 value. `The appSecret key used to generate the signature is critical for communication data security. It must never be used directly on the client side. All APIs must be called through your own server to relay requests to the POLYV server for response data.` [See Signature Generation Rules]
channelId	true	String	Channel ID
lotteryId	true	String	Lottery session ID. This parameter is obtained from Query Channel Lottery Records

Example

http://api.polyv.net/live/v3/channel/lottery/download-winner-detail?appId=frlr1zazn3&sign=2C9656549D3579CE1F06EF722BD390D1&channelId=1965681&timestamp=1621844995312&lotteryId=fv3hogjmh3

Response Parameter Description

Upon successful response, the interface returns a file stream in .xls format, which can be saved as a file.

Java Request Example

For quick integration of the basic code, please download the relevant dependency source code. Click here to download the source code. After downloading, add it to your own source project. The test cases include HttpUtil.java and LiveSignUtil.java in the downloaded file.

It is strongly recommended to use the Live Java SDK for API integration. The Live Java SDK provides unified encapsulation and optimization for API call logic, exception handling, data signing, and HTTP request thread pooling.

private static final Logger log = LoggerFactory.getLogger(LiveInteractionTest.class);
/**
 * 下载频道场次中奖记录
 * @throws IOException
 */
@Test
public void testDownloadWinnerDetail() throws IOException, NoSuchAlgorithmException {
    //公共参数,填写自己的实际参数
    String appId=super.appId;
    String appSecret=super.appSecret;
    String userId = super.userId;
    String timestamp=String.valueOf(System.currentTimeMillis());
    //业务参数
    String url = "http://api.polyv.net/live/v3/channel/lottery/download-winner-detail";
    String channelId = "1965681";
    String lotteryId = "fv3hogjmh3";
    //http 调用逻辑
    Map<String,String> requestMap = new HashMap<>();
    requestMap.put("appId", appId);
    requestMap.put("timestamp",timestamp);

    requestMap.put("channelId",channelId);
    requestMap.put("lotteryId",lotteryId);

    requestMap.put("sign",LiveSignUtil.getSign(requestMap, appSecret));
    byte[] binary = HttpUtil.getBinary(url, requestMap, null);
    String path = getClass().getResource("/file/").getPath() + "DownloadWinnerDetail.xls";
    HttpUtil.writeFile(binary, path);
    log.info("测试下载频道场次中奖记录接口返回值：{}",path);
    //do somethings
}

Response Example

For global error descriptions, see Global Error Description

Success Example

/C:/IDEA/project/polyv-api-example/target/test-classes/file/DownloadWinnerDetail.xls

Error Example

{
    "code": 400,
    "status": "error",
    "message": "invalid signature.",
    "data": ""
}

Live Streaming Server API