寫個腳本一共完成了三件事: 第一,python調(diào)用http接口, 第二,把調(diào)用到的數(shù)據(jù)寫入mysql數(shù)據(jù)庫, 第三,python調(diào)用wsdl接口,獲取錄音文件, import time import json import pprint import MySQLdb import urllib import os import urllib2 #調(diào)報表接口用 import suds #調(diào)錄音用 pageNum = range(1,1000) for a in pageNum:     url = "http://x.x.x.x:xx/agentProxy/getCallDetail?RN=118117&callType=1&entId=xxxxx&pwd=61712&startTime=20170517000000&endTime=20170517235959&pageNum=" + str(a)     req = urllib2.Request(url)     res_data = urllib2.urlopen(req)     res = res_data.read()     data = json.loads(res)     data1 = data[0]     data2 = data1["callDetailArray"]     data4  = data1["retCode"]     data5 = data1["retMsg"]     data6 = data1["nextPageNum"]     data7 = data1["RN"]     data8 = data1["entId"]     if len(data1['callDetailArray']) == 0:         break     #print "返回代碼:",data4,"是否成功:",data5,"下一頁:",data6,"RN:",data7,"企業(yè)編號:",data8,"本頁總條數(shù):",len(data1['callDetailArray'])     data9 = len(data1['callDetailArray'])     l = range(len(data1['callDetailArray']))     for i in l:         data3 = (data2[i])         data10 = int(data3['sessionId'])         data11 = hex(data10)         data12 = data11[2:]         data13 = data12[:-1]         data14 = str(data3['resourceId'])         data15 = time.strftime("%Y-%m-%d %X", time.localtime())         url = "http://x.x.x.x:xx/dcmsWebservice/webservice/QueryRecord?wsdl"         client=suds.client.Client(url)         res = client.service['QueryRecord'].queryRecordAddr("xxxxx",data14,data14,data13)         record= str(res)         print record         db = MySQLdb.connect("x.x.x.x","ucds","ucds","report_detail",charset = "utf8")         cursor = db.cursor()         sql = """insert into outbound (record_url,sessionId_16,sessionId,resourceId,resourceName,resourceDN,skillId,remoteUrl,localUrl,startTime,endTime,         alertDuration,talkDuration,acwDuration,ivrDuration,joinDuration,endType,insertTime)         values("%s","%s","%s","%s","%s","%s","%s","%s","%s","%s","%s","%s","%s","%s","%s","%s","%s","%s")"""\             %(record,data13,data3['sessionId'],data3['resourceId'],data3['resourceName'],data3['resourceDN'],             data3['skillId'],data3['remoteUrl'],data3['localUrl'],data3['startTime'],data3['endTime'],data3['alertDuration'],data3['talkDuration'],data3['acwDuration'],data3['ivrDuration'],data3['joinDuration'],data3['endType'],data15)         cursor.execute(sql)         db.commit()         cursor.close()         db.close()         path=r'E:\record\xxxxxxx'         if record == str('-5'):             print "返回-5,無錄音文件"         else:             wav = record.split('/')             wav1 = wav[8]             dest_dir=os.path.join(path,wav1)             urllib.urlretrieve(record,dest_dir) print "本次共同步:",(a-1)*100-int(data9),"條數(shù)據(jù)"

成都創(chuàng)新互聯(lián)主營芙蓉網(wǎng)站建設(shè)的網(wǎng)絡(luò)公司,主營網(wǎng)站建設(shè)方案,app軟件開發(fā)公司,芙蓉h5微信平臺小程序開發(fā)搭建,芙蓉網(wǎng)站營銷推廣歡迎芙蓉等地區(qū)企業(yè)咨詢

另外有需要云服務(wù)器可以了解下創(chuàng)新互聯(lián)cdcxhl.cn，海內(nèi)外云服務(wù)器15元起步，三天無理由+7*72小時售后在線，公司持有idc許可證，提供“云服務(wù)器、裸金屬服務(wù)器、高防服務(wù)器、香港服務(wù)器、美國服務(wù)器、虛擬主機(jī)、免備案服務(wù)器”等云主機(jī)租用服務(wù)以及企業(yè)上云的綜合解決方案，具有“安全穩(wěn)定、簡單易用、服務(wù)可用性高、性價比高”等特點與優(yōu)勢，專為企業(yè)上云打造定制，能夠滿足用戶豐富、多元化的應(yīng)用場景需求。

網(wǎng)頁題目：python調(diào)用http接口,數(shù)據(jù)寫入mysql數(shù)據(jù)庫并下載錄音文件-創(chuàng)新互聯(lián)
文章路徑：http://weahome.cn/article/cohgij.html