The "Type" parameter

Create custom functionality with the 'type' parameter.

For some URLs you can set to JSON format as the default in the editor, but you can also utilise further json formatting using the type parameter, and even return HTML tables. Here is one example:

https://api.csvgetter.com/abcd1234 // returns some csv data

https://api.csvgetter.com/abcd1234?type=json_records // returns JSON data

json_records	list like [{column -> value}, … , {column -> value}]​​
json_split	dict like {‘index’ -> [index], ‘columns’ -> [columns], ‘data’ -> [values]}
json_index	dict like {index -> {column -> value}}
json_columns	dict like {column -> {index -> value}}
json_table	dict like {‘schema’: {schema}, ‘data’: {data}}
excel_web_query	html table compatible with Excel Web Query