🚀 Big News: Socket Acquires Coana to Bring Reachability Analysis to Every Appsec Team.Learn more

excel-runner

Advanced tools

Socket logo

Install Socket

Detect and block malicious and high-risk dependencies

Install

excel-runner

Excel http api test

0.1.2
100

Supply Chain Security

100

Vulnerability

99

Quality

100

Maintenance

100

License

Unpopular package

Quality

This package is not very popular.

Found 1 instance in 1 package

Network access

Supply chain risk

This module accesses the network.

Found 1 instance in 1 package

Uses eval

Supply chain risk

Package uses dynamic code execution (e.g., eval()), which is a dangerous practice. This can prevent the code from running in certain environments and increases the risk that the code may contain exploits or malicious behavior.

Found 1 instance in 1 package

Maintainers
1

excel-runner

Run Http requests list in excel sheet

how to use

Install excel-runner v0.1.2

pip install excel-runner==0.1.2

Create excel data file data.xlsx

namemethodurldataheadersverifyresult
get请求gethttps://httpbin.org/get?a=1&b=2res.status_code==200
post-formposthttps://httpbin.org/postname=Kevin&age=1Content-Type: application/x-www-form-urlencodedres.status_code==200
res.json()['form']['name']=='Kevin']
post-jsonposthttps://httpbin.org/post{"name": "Kevin", "age": 1}Content-Type: application/json
post-xmlposthttps://httpbin.org/posthelloContent-Type: application/xmlresult.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

namemethodurldataheadersverifyresult
get请求gethttps://httpbin.org/get?a=1&b=2res.status_code==200PASS
post-formposthttps://httpbin.org/postname=Kevin&age=1Content-Type: application/x-www-form-urlencodedres.status_code==200
res.json()['form']['name']=='Kevin']
PASS
post-jsonposthttps://httpbin.org/post{"name": "Kevin", "age": 1}Content-Type: application/jsonPASS
post-xmlposthttps://httpbin.org/posthelloContent-Type: application/xmlresult.json()["data"]=="hello"PASS

FAQs

Did you know?

Socket

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.

Install

Related posts