Python请求接口

孰能生巧-LWP

已于 2023-04-04 10:38:20 修改

阅读量196

点赞数 2

分类专栏： python 文章标签： python

于 2023-03-09 18:46:29 首次发布

本文链接：https://blog.csdn.net/qq_33816292/article/details/129428676

版权

python 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

一、代码如下：

import requests
import time

def   hand ():
    headers = {
        "kbn-xsrf": "true",
        "Content-Type": "application/json",
        "token": "" 需填入token
    }
    workOrder =['NGD20230223000132',
                'NGD20230223000134'
                ]

    for work in workOrder:
      time.sleep(0.1)
      post = requests.post(url=f"https://eportal-car-center.dstcar.com/dst-apis/1/vehicleOperate/workorder/base/info/close/{work}" ,json={} , headers=headers)
      print(post.text)


if __name__ == '__main__':
    hand()

二、效果如图

二、先读excel数据，在掉接口post请求

1.excel工具类文件名： excel_utils.py

# -*- coding: UTF-8 -*-
import xlrd

class Excel():

    data_excel = None

    def __init__(self, file_name):
        self.data_excel = xlrd.open_workbook(file_name)

    def get_sheet(self, index):
        return self.data_excel.sheets()[index]

    def get_data(self, sheet, start_row=0):
        result = []
        for i in range(start_row, sheet.nrows):
            row = sheet.row(i)
            data = []
            for r in row:
                data.append(str(r.value).strip())
            result.append(data)
        return result

2.工具调用，调用接口代码，准备excel文件

#查询出表里面所有的数据 加-- 注释掉后面limit 5000 默认值
select vin_code  from   dst_vehicle.o_basic_car --

import requests
import time
import json

from excel_utils import Excel

excel = Excel("车辆数据修复.xls")
#excel = Excel("车辆数据修复01.xls")
sheet = excel.get_sheet(0)
#data = excel.get_data(sheet, 1)


def  get_date_eprod():
    start = time.perf_counter()
    #data =['LR83STGT4NB002326']
    print('excel的总数量为:' + str(len(data)))
    success = []
    for vinCode in data:
        #time.sleep(0.1)
        url = 'https://eportal-station.dstcar.com/dst-apis/1/vehicleOperate/oss/repush/sendMq2Queue?queue=vehicle-change-fanout-queue'
        body =  [{"vinCode": vinCode[0],
                  "type":"UPDATE",
                  "updateColumns":["serverCityCode"],
                  "dataGroup":"operate"
                  }
                 ]

        headers = {
            "token": "i26ebdc8760e644c6afc7cb717488fe1e",
            "content-type": "application/json;charset=UTF-8"
        }
        post = requests.post(url=url ,data=json.dumps(body),  headers=headers)
        success.append(post.reason)
    print("发送成功的消息总数为：" + str(len(success)))
    end = time.perf_counter()
    runTime = end - start
    # 输出运行时间
    print("eprod运行时间：", runTime, "秒")

# c0bc11df6352412bb7fb3e0dd26ea9d7       684ecb5a5ba545a6bc0f67d4e3685b5a
if __name__ == '__main__':
    get_date_eprod()

3.效果如图所示