The "Type" parameter
Create custom functionality with the 'type' parameter.
The Type url parameter (?type=
) can be used to overwrite the data export type. Below are examples of how it can be used to format your data.
Example Export URL
https://api.csvgetter.com/CBIfM4nqnrj9WHqxOm3W
Output (CSV)
JSON Records
?type=json_records
(if first parameter)
&type=json_records
(if not first parameter)
What does it do?
Overwrite the data export type as data records.
Example
https://api.csvgetter.com/CBIfM4nqnrj9WHqxOm3W
?type=json_records
JSON Index
?type=json_index
(if first parameter)
&type=json_index
(if not first parameter)
What does it do?
Overwrites the data export type as indexed JSON data
Example
https://api.csvgetter.com/CBIfM4nqnrj9WHqxOm3W
?type=json_index
JSON Split
?type=json_split
(if first parameter)
&type=json_split
(if not first parameter)
What does it do?
Overwrites the data export type as indexed JSON data
Example
https://api.csvgetter.com/CBIfM4nqnrj9WHqxOm3W
?type=json_split
JSON Columns
?type=json_columns
(if first parameter)
&type=json_columns
(if not first parameter)
What does it do?
Overwrites the data export type as JSON column data.
Example
https://api.csvgetter.com/CBIfM4nqnrj9WHqxOm3W
?type=json_columns
JSON Table
?type=json_table
(if first parameter)
&type=json_table
(if not first parameter)
What does it do?
Overwrites the data export type as JSON table data.
Example
https://api.csvgetter.com/CBIfM4nqnrj9WHqxOm3W
?type=json_table
XML
?type=xml
(if first parameter)
&type=xml
(if not first parameter)
What does it do?
Overwrites the data export type as XML feed
Example
https://api.csvgetter.com/CBIfM4nqnrj9WHqxOm3W
?type=xml
Excel Web Query
?type=excel_web_query
(if first parameter)
&type=excel_web_query
(if not first parameter)
What does it do?
Returns data as html table suitable for web queries, particularly the power query required for excel mac. Example here.
Example
https://api.csvgetter.com/CBIfM4nqnrj9WHqxOm3W
?type=excel_web_query
HTML Table
?type=html_table
(if first parameter)
&type=html_table
(if not first parameter)
What does it do?
Shows the data as an HTML table. Same result as excel_web_query
.
Example
https://api.csvgetter.com/CBIfM4nqnrj9WHqxOm3W
?type=html_table
Dynamic HTML Table
?type=dynamic_table
(if first parameter)
&type=dynamic_table
(if not first parameter)
What does it do?
Shows the data as a sortable and searchable HTML table with pagination.
Example
https://api.csvgetter.com/CBIfM4nqnrj9WHqxOm3W
?type=dynamic_table
Last updated