python调用接口获取数据并将数据存入数据库_python读取百度推广api接口的数据并传入数据库代码的整合...

import requests,json,datetime,re

import pandas as pd

today = datetime.date.today()

oneday = datetime.timedelta(days=1)

yesterday = today-oneday

def getRealTimeData(username,password,token):

url = "https://api.baidu.com/json/sms/service/ReportService/getRealTimeData"

data = {

"header":{

"username":username,

"password":password,

"token":token

},

"body":{

"realTimeRequestType":{

"reportType":10,

"levelOfDetails":3,

"startDate":str(yesterday),

"endDate":str(yesterday),

"performanceData":["impression","click","cost"],

"device":0,

"unitOfTime":8

}

}

}