Run Http requests list in excel sheet
Install excel-runner v0.1.2
pip install excel-runner==0.1.2
Create excel data file data.xlsx
| name | method | url | data | headers | verify | result |
|---|---|---|---|---|---|---|
| get请求 | get | https://httpbin.org/get?a=1&b=2 | res.status_code==200 | |||
| post-form | post | https://httpbin.org/post | name=Kevin&age=1 | Content-Type: application/x-www-form-urlencoded | res.status_code==200 res.json()['form']['name']=='Kevin'] | |
| post-json | post | https://httpbin.org/post | {"name": "Kevin", "age": 1} | Content-Type: application/json | ||
| post-xml | post | https://httpbin.org/post | hello | Content-Type: application/xml | result.json()["data"]=="hello" |
Run excel data file
from excel_runner import run_excel
run_excel('data.xlsx')
Open data.xlsx again, you will see the test result
| name | method | url | data | headers | verify | result |
|---|---|---|---|---|---|---|
| get请求 | get | https://httpbin.org/get?a=1&b=2 | res.status_code==200 | PASS | ||
| post-form | post | https://httpbin.org/post | name=Kevin&age=1 | Content-Type: application/x-www-form-urlencoded | res.status_code==200 res.json()['form']['name']=='Kevin'] | PASS |
| post-json | post | https://httpbin.org/post | {"name": "Kevin", "age": 1} | Content-Type: application/json | PASS | |
| post-xml | post | https://httpbin.org/post | hello | Content-Type: application/xml | result.json()["data"]=="hello" | PASS |
FAQs
Excel http api test
We found that excel-runner demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Research
Security News
Malicious Ruby gems typosquat Fastlane plugins to steal Telegram bot tokens, messages, and files, exploiting demand after Vietnam’s Telegram ban.
Research
Security News
Socket uncovered four malicious npm packages that exfiltrate up to 85% of a victim’s Ethereum or BSC wallet using obfuscated JavaScript.
Security News
TC39 advances 9 JavaScript proposals, including Array.fromAsync, Error.isError, and Explicit Resource Management, which are now headed into the ECMAScript spec.