Awesome
jqp
jqp is a free serverless proxy that lets you request data from remote sources, filter it using jq-web, and receive the filtered response.
How to use
Query param | Description | Required |
---|---|---|
url | a URL-encoded URL (🤯) for a publicly accessible JSON endpoint or CSV file | ✔️ |
jq | a URL-encoded filter expression supported by jq-web | |
debug | true returns a nested response object that includes the values of the passed params above |
jqp will first assume that the response body is JSON. If parsing fails, it will assume that the response body is CSV and attempt to parse it into JSON.
Note: Each row of CSV data will be parsed into an object of values keyed by field name.
Note: To fetch multiple files, the
url
parameter can be used more than once. The responses are made available to jq-web as an array, and can be referenced in the same order as their respectiveurl
parameters, e.g..[0]
,.[1]
, etc.
Examples
Transform JSON response
Query param | Unencoded value |
---|---|
url | https://raw.githubusercontent.com/fanzeyi/pokemon.json/master/pokedex.json |
jq | [.[] | {name: .name.english, hp: .base.HP}] |
Convert CSV response to JSON
Query param | Unencoded value |
---|---|
url | https://gist.githubusercontent.com/armgilles/194bcff35001e7eb53a2a8b441e8b2c6/raw/92200bc0a673d5ce2110aaad4544ed6c4010f687/pokemon.csv |