Combining URL Parameters

URL parameters can be chained together to build powerful data workflows — all from a single URL. This page shows real-world recipes for common scenarios.

How Parameters Chain

Append parameters to your endpoint URL with ? for the first and & for each additional:

https://api.csvgetter.com/abc123?param1=value1&param2=value2&param3=value3

Parameters are processed in this order:

1. Authentication — Bearer token checked (if enabled)

2. Data fetch — Full dataset retrieved from source

3. all_fields — Override field selection (if set)

4. extract_json_property — Flatten linked records (if set)

5. sql — SQL query applied to filter/transform data

6. type — Output format applied

7. nest_json — JSON output wrapped in key (if set)

8. filename_timestamp — Filename modified (if set)

9. Side effects — email_me, save_to_gdrive, save_to_gsheets, etc.

---

Recipe 1: Filter with SQL + Output as JSON + Email Notification

Scenario: You want active customers as JSON and get an email each time it runs.

https://api.csvgetter.com/abc123?sql=SELECT name, email, plan FROM csvgetter WHERE status='Active' ORDER BY name&type=json_records&email_me=true&email_tag=active-customers

Parameter	Value	Purpose
sql	SELECT name, email, plan FROM csvgetter WHERE status='Active' ORDER BY name	Filter to active, select 3 columns, sort
type	json_records	JSON array of objects
email_me	true	Email notification
email_tag	active-customers	Label the notification

---

Recipe 2: Export to Google Drive with Timestamped Filename

Scenario: Daily backup of your Airtable data to Google Drive, with each file uniquely named.

https://api.csvgetter.com/abc123?save_to_gdrive=true&filename_timestamp=true

Parameter	Value	Purpose
save_to_gdrive	true	Save to connected Google Drive
filename_timestamp	true	Append _2025-03-15T143022 to filename

Result: A file like Customers_2025-03-15T143022.csv appears in your Google Drive.

With timestamp at the start:

?save_to_gdrive=true&filename_timestamp=start

Result: 2025-03-15T143022_Customers.csv

---

Recipe 3: SQL Aggregation as Nested JSON for an API

Scenario: You're building a dashboard that expects data nested under a data key, showing department headcounts.

https://api.csvgetter.com/abc123?sql=SELECT department, COUNT(*) as headcount, AVG(salary) as avg_salary FROM csvgetter GROUP BY department ORDER BY headcount DESC&type=json_records&nest_json=data

Parameter	Value	Purpose
sql	SELECT department, COUNT(*) as headcount...	Aggregate by department
type	json_records	JSON output
nest_json	data	Wrap result in {"data": [...]}

Response:

{
  "data": [
    {"department": "Engineering", "headcount": 42, "avg_salary": 95000},
    {"department": "Marketing", "headcount": 18, "avg_salary": 72000}
  ]
}

---

Recipe 4: Interactive Table for Stakeholders

Scenario: Share a browsable, searchable view of your data with non-technical team members.

https://api.csvgetter.com/abc123?type=dynamic_table&sql=SELECT name, role, department, start_date FROM csvgetter ORDER BY start_date DESC

Parameter	Value	Purpose
type	dynamic_table	Interactive HTML with search + pagination
sql	SELECT name, role, department, start_date...	Select relevant columns, sort by date

Share this URL directly — recipients see a searchable table in their browser.

---

Recipe 5: Excel Import with Loading Page

Scenario: Large dataset that takes a few seconds to load. You want a "please wait" page rather than a browser timeout.

https://api.csvgetter.com/abc123?type=excel_web_query&show_wait_page=true

Parameter	Value	Purpose
type	excel_web_query	Format for Excel's "From Web"
show_wait_page	true	Show loading page while data fetches

---

Recipe 6: Top 10 Records as XML

Scenario: Your integration requires XML and you only need the most recent 10 entries.

https://api.csvgetter.com/abc123?sql=SELECT * FROM csvgetter ORDER BY created_at DESC LIMIT 10&type=xml

Parameter	Value	Purpose
sql	...ORDER BY created_at DESC LIMIT 10	Latest 10 records
type	xml	XML output

---

Recipe 7: Filtered Data to Google Sheets

Scenario: Update a specific Google Sheet with only high-priority items.

https://api.csvgetter.com/abc123?sql=SELECT * FROM csvgetter WHERE priority='High'&save_to_gsheets=true&spreadsheet=SPREADSHEET_ID&sheet=Sheet1

Parameter	Value	Purpose
sql	...WHERE priority='High'	Filter to high priority
save_to_gsheets	true	Write to Google Sheets
spreadsheet	Your spreadsheet ID	Target spreadsheet
sheet	Sheet1	Target sheet/tab

---

Recipe 8: Flattened Linked Records as JSON

Scenario: Your Airtable has linked record fields that return as JSON arrays. You want to extract just the names.

https://api.csvgetter.com/abc123?extract_json_property=name&type=json_records

Parameter	Value	Purpose
extract_json_property	name	Extract name from linked record objects
type	json_records	JSON output

Before:

[{"assignee": "[{\"id\":\"rec1\",\"name\":\"Alice\"},{\"id\":\"rec2\",\"name\":\"Bob\"}]"}]

After:

[{"assignee": "Alice, Bob"}]

---

Recipe 9: Upload Training Data to OpenAI

Scenario: Send a filtered dataset to OpenAI for use with the Assistants API.

https://api.csvgetter.com/abc123?sql=SELECT question, answer FROM csvgetter WHERE verified='true'&save_to_openai=true&save_to_openai_filename=qa_training_data.csv

Parameter	Value	Purpose
sql	...WHERE verified='true'	Only verified Q&A pairs
save_to_openai	true	Upload to OpenAI
save_to_openai_filename	qa_training_data.csv	Custom filename

---

Recipe 10: Authenticated Export with Email + Drive Backup

Scenario: Secure endpoint that also saves to Drive and notifies you.

curl -H "Authorization: Bearer my-secret-token" \
  "https://api.csvgetter.com/abc123?save_to_gdrive=true&filename_timestamp=end&email_me=true&email_tag=secure-backup"

Parameter	Value	Purpose
Auth header	Bearer my-secret-token	Authenticate the request
save_to_gdrive	true	Backup to Drive
filename_timestamp	end	Unique filename
email_me	true	Notification
email_tag	secure-backup	Label for the notification