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

Last updated