|
本帖最后由 千雨千 于 2018-5-11 11:58 编辑
- <div class="blockcode"><blockquote>#coding=utf-8
- import requests
- import json
- from requests import get,post,Session
- import xlrd
- import sys
- import mysql
- def open_excel(file='file.xls'):
- try:
- data = xlrd.open_workbook(file)
- return data
- except Exception, e:
- print str(e)
- def excel_table_byindex(file='file.xls', colnameindex=0, by_index=0):
- data = open_excel(file)
- table = data.sheets()[by_index]
- nrows = table.nrows
- colnames = table.row_values(colnameindex)
- list = []
- for rownum in range(1, nrows):
- row = table.row_values(rownum)
- if row:
- app = {}
- for i in range(len(colnames)):
- app[colnames[i]] = row[i]
- list.append(app)
- return list
- listdata1 = excel_table_byindex("D:\\add1.xlsx", 0)
- for i in range(0, len(listdata1)):
- headers = {'Content-Type': "application/json",}
- url1 = "http://ivt3.hschefu.com:9199/v1/app/login"
- data1 = {"data": {"password": "12345678","username": "18583287560"}}
- para1 = json.dumps(data1)
- r=requests.post(url1,data=para1,headers= headers)
- jas1 = r.text
- result = jas1.encode('utf-8')
- jd = json.loads(result)
- token=jd["data"]["token"]
- token1=str(token)
- print(type(token1))
- url = "http://ivt3.hschefu.com:9199/v1/app/mytask/commitPhoneAudit"
- payload = {{
- "imageList": [{
- "code": "BSR",
- "path": "erp/2004/BSR63cc2a4d59c1302592a5f4ea96f119e8.jpg"
- }, {
- "code": "CCF",
- "path": "erp/2004/CCFde3675d1d991dcbc76b884a00aac238c.jpg"
- }, {
- "code": "CCIA",
- "path": "erp/2004/CCIA460924ef753ab09d88c1e2a7c515f617.jpg"
- }, {
- "code": "CFD",
- "path": "erp/2004/CFDd87d7b35fed6a43d1c16b6eb304a184b.jpg"
- }, {
- "code": "COS",
- "path": "erp/2004/COS6ce50253a200931dad2e20c0fc4b8451.jpg"
- }, {
- "code": "CB",
- "path": "erp/2004/CB4097b40e1a84cb265e9c10f401837e56.jpg"
- }, {
- "code": "FSC",
- "path": "erp/2004/FSC86068e95f74c5a9060c3fd44bf251234.jpg"
- }, {
- "code": "CR",
- "path": "erp/2004/CRfaff0f214d0b625aa386f6bd0009e1ce.jpg"
- }, {
- "code": "CI",
- "path": "erp/2004/CIb0192039379d728547cec1cce2b18373.jpg"
- }, {
- "code": "CFR",
- "path": "erp/2004/CFR76ebf3e7da4a4c98337c9635c0d85235.jpg"
- }, {
- "code": "CBR",
- "path": "erp/2004/CBReb22389428a1fb735239bfdaf66d15ca.jpg"
- }, {
- "code": "CN",
- "path": "erp/2004/CN92b522703d680f93f884be525b740548.jpg"
- }, {
- "code": "ICFAC",
- "path": "erp/2004/ICFAC7a8df8f6023a2f15e3fb0c629223d378.jpg"
- }, {
- "code": "OPI",
- "path": "erp/2004/OPI82bb04c2ae50288c2a39ff12a8d0ab35.jpg"
- }, {
- "code": "RCMVB",
- "path": "erp/2004/RCMVB4683a067eef43b86a8e1b90701afd05a.jpg"
- }, {
- "code": "MVDLB",
- "path": "erp/2004/MVDLB6edb6bcae22fd8b3a9a5c75f85b656c5.jpg"
- }, {
- "code": "LPPB",
- "path": "erp/2004/LPPB063608433e8eb36c1c9fb7c5446f8548.jpg"
- }, {
- "code": "PMC",
- "path": "erp/2004/PMC177916accb87d6197fa08c24c9a06620.jpg"
- }, {
- "code": "ECI",
- "path": "erp/2004/ECIe4b64c9f6f70016474710e201dd2fe9f.jpg"
- }],
- "os": "android",
- "phone": "18583287560",
- "reqId": 121,
- "step": 2,
- "taskId": 122,
- "token": token1
- }
- }
- data=json.dumps(payload)
- response = requests.request("POST", url, data=data, headers=headers)
- # r = requests.post(url,data=payload,headers= headers)
- print(response.text)
- # print(r.text)
复制代码
payload的数据在postman是这可以正常调通接口的
|
-
运行报错
|