我正试图捕捉从 Postman 的React,它需要存储在csv中。
这是我试过的代码,但没有得到预期的输出
UsergroupURL="https://"+ dex.3ds.com"
UsergroupsURL= UsergroupURL + "/3drdd/resources/b1/usersgroup?select=title,description,owner,members,pending_members,creation_date,modification_date&top=100&skip=0"
skip = 0
all_results = []
while True:
usergroupresponse = session.post(UsergroupsURL, data = data)
if usergroupresponse.status_code != 200:
Failmsg="Failed to post usergroup. Status code : " + str(response.status_code)
sys.exit(Failmsg)
results = usergroupresponse.json()
print(results)
if len(results) == 0:
# No more results to retrieve
break
# Append the results to the all_results list
all_results += results
# Increment skip to skip the previously retrieved results
skip += 100
# Update the URL with the new skip value
UsergroupsURL = UsergroupURL + "/3drdd/resources/b1/usersgroup?select=title,description,owner,members,pending_members,creation_date,modification_date&top=100&skip=" + str(skip)
print(results)
# Write the results to a CSV file
with open('response.csv', 'w', newline='') as csvfile:
writer = csv.writer(csvfile)
for row in all_results:
writer.writerow(row.values())
在此代码中,第一次点击URL后将仅获得100个数据,但URL包含多个数据,因此在此传递跳过参数以从URL检索所有数据,前100个数据将被捕获到CSV文件
我期待当我尝试点击URL第二次跳过值应更改为100,所以它将检索第二个100数据第一个100将被跳过,所以第二个100数据被捕获CSV文件,当我尝试点击URL第三次跳过值应更改为200,所以它将检索其余的数据,它应该被击中,直到没有响应从URL
1条答案
按热度按时间k5hmc34c1#
下面是我更新的代码:
需要单独改变这部分