The "SQL" Parameter
Fine tune your data output in line with this parameter
The SQL url parameter (?sql=
) can be used to filter, sort or group the data export. Below are examples of how it can be used to restructure your data.
Example Export URL
https://api.csvgetter.com/AADVgE0BE2k04FgjZJtX
Output (CSV)
Limit records
?sql=select * from csvgetter limit 1
(if first parameter)
&sql=select * from csvgetter limit 1
(if not first parameter)
What does it do?
Only shows the first row of data. (To show the first n
rows change to limit n
)
Example
https://api.csvgetter.com/AADVgE0BE2k04FgjZJtX
?sql=select * from csvgetter limit 1
https://api.csvgetter.com/AADVgE0BE2k04FgjZJtX
?sql=select * from csvgetter limit 1
Filter records
?sql=select * from csvgetter where <column_name>='<value>'
(if first parameter)
&sql=select * from csvgetter where <column_name>='<value>'
(if not first parameter)
What does it do?
Only shows data where <column_name>
is equal to <value>
.
Example
https://api.csvgetter.com/AADVgE0BE2k04FgjZJtX
?sql=select * from csvgetter where Occupation='Teacher'
https://api.csvgetter.com/AADVgE0BE2k04FgjZJtX
?sql=select * from csvgetter where Occupation='Teacher'
Sort records by Column
Ascending
?sql=select * from csvgetter order by <column_name> asc
(if first parameter)
&sql=select * from csvgetter order by <column_name) asc
(if not first parameter)
Descending
?sql=select * from csvgetter order by <column_name> desc
(if first parameter)
&sql=select * from csvgetter order by <column_name) desc
(if not first parameter)
What does it do?
Orders the data by the selected column name
Example
https://api.csvgetter.com/AADVgE0BE2k04FgjZJtX
?sql=select * from csvgetter order by Age asc
https://api.csvgetter.com/AADVgE0BE2k04FgjZJtX
?sql=select * from csvgetter order by Age asc
Group records by column
?sql=select Gender, count(*) as 'Number of records' from csvgetter group by Gender
(if first parameter)
&sql=select Gender, count(*) as 'Number of records' from csvgetter group by Gender
(if not first parameter)
What does it do?
Groups the records by gender, counts the number of records that matches each gender.
Example
https://api.csvgetter.com/AADVgE0BE2k04FgjZJtX
?sql=select Gender, count(*) as 'Number of records' from csvgetter group by Gender
https://api.csvgetter.com/AADVgE0BE2k04FgjZJtX
?sql=select Gender, count(*) as 'Number of records' from csvgetter group by Gender
⚠️ A SQL statement like this will introduce special characters like `
or *
into the URL. You can encode your SQL statements with our URL Encoder/Decoder tool.
With our encoder tool:
select Gender, count(*) as 'Number of records' from csvgetter group by Gender
select Gender, count(*) as 'Number of records' from csvgetter group by Gender
becomes...
select%20Gender%2C%20count(*)%20as%20'Number%20of%20records'%20from%20csvgetter%20group%20by%20Gender
and can be used like:
https://api.csvgetter.com/AADVgE0BE2k04FgjZJtX
?sql=select%20Gender%2C%20count(*)%20as%20'Number%20of%20records'%20from%20csvgetter%20group%20by%20Gender
https://api.csvgetter.com/AADVgE0BE2k04FgjZJtX
?sql=select%20Gender%2C%20count(*)%20as%20'Number%20of%20records'%20from%20csvgetter%20group%20by%20Gender
Generally speaking, CSV Getter API can accept any read-only (SELECT) SQL statements. Think of any other cool SQL to include in this page? Let us know!
FAQs
Is my CSV data liable to SQL injection?
No. We have designed the system such that SQL only works read-only, and does not interact with the underlying data.
Last updated