" \
-H "Api-Username: system" \
-F 'params={"viewed_at":"2019-06-10"}'
```
CSV responses default to returning up to 10,000 rows. You can pass a `limit` parameter to reduce this.
## Additional resources
- [Create a Data Explorer query using the API](https://meta.discourse.org/t/create-a-data-explorer-query-using-the-api/394388)
- [Create and configure an API key](https://meta.discourse.org/t/create-and-configure-an-api-key/230124)
- [Reverse engineer the Discourse API](https://meta.discourse.org/t/how-to-reverse-engineer-the-discourse-api/20576)
- [GitHub - lee-dohm/execute-discourse-query: Executes a Discourse data-explorer query via the API ¡ GitHub](https://github.com/lee-dohm/execute-discourse-query)
---
### Author:  [@37Rb](https://meta.discourse.org/u/37Rb)
#### Post date: [May 10, 2024, 2:47am UTC](https://meta.discourse.org/t/run-data-explorer-queries-with-the-discourse-api/120063/52 "2024-05-10T02:47:02Z")
> [@simon](#):
>
> The `limit=ALL` support for CSV exports
This comment seems to imply that you can do CSV export from the API. Is that possible? Just curious because I need the data as CSV. I can always get it as JSON and convert to CSV but if there is a built-in way to get CSV that would be a little easier.
---
### Author:  [@francis\_exalate](https://meta.discourse.org/u/francis_exalate)
#### Post date: [January 4, 2025, 1:50pm UTC](https://meta.discourse.org/t/run-data-explorer-queries-with-the-discourse-api/120063/53 "2025-01-04T13:50:10Z")
Is it possible to do a query âlike created or updated the last 50 secondsâ?
---
### Author:  [@Canapin](https://meta.discourse.org/u/Canapin)
#### Post date: [January 4, 2025, 2:21pm UTC](https://meta.discourse.org/t/run-data-explorer-queries-with-the-discourse-api/120063/54 "2025-01-04T14:21:31Z")
đ¤ AI says
```sql
-- [params]
-- int :seconds = 50
SELECT
p.id AS post_id,
p.created_at,
p.updated_at,
p.raw AS post_content,
p.user_id,
t.title AS topic_title,
t.id AS topic_id
FROM posts p
INNER JOIN topics t ON t.id = p.topic_id
WHERE
(EXTRACT(EPOCH FROM (NOW() - p.created_at)) <= :seconds
OR EXTRACT(EPOCH FROM (NOW() - p.updated_at)) <= :seconds)
AND p.deleted_at IS NULL
AND t.deleted_at IS NULL
ORDER BY p.created_at DESC
LIMIT 50
```
Did a quick test, it seems to work đ
---
### Author:  [@Moin](https://meta.discourse.org/u/Moin)
#### Post date: [January 4, 2025, 2:34pm UTC](https://meta.discourse.org/t/run-data-explorer-queries-with-the-discourse-api/120063/55 "2025-01-04T14:34:17Z")
I donât see the âlike â¤â I added to a post using your query.
I think you need to use `post_actions`
```sql
--[params]
--string :timespan = 50 seconds
SELECT post_id,
user_id,
created_at,
updated_at,
deleted_at
FROM post_actions
WHERE post_action_type_id=2 AND updated_at > NOW() - INTERVAL :timespan
```
Version with more beautiful results
```sql
--[params]
--string :timespan = 50 seconds
--boolean :include_in_timespan_deleted = false
SELECT
post_id,
user_id,
CASE
WHEN EXTRACT(EPOCH FROM (NOW() - created_at)) < 60 THEN CONCAT(ROUND(EXTRACT(EPOCH FROM (NOW() - created_at))), ' seconds ago')
WHEN EXTRACT(EPOCH FROM (NOW() - created_at)) < 3600 THEN CONCAT(ROUND(EXTRACT(EPOCH FROM (NOW() - created_at)) / 60), ' minutes ago')
WHEN EXTRACT(EPOCH FROM (NOW() - created_at)) < 86400 THEN CONCAT(ROUND(EXTRACT(EPOCH FROM (NOW() - created_at)) / 3600), ' hours ago')
ELSE CONCAT(ROUND(EXTRACT(EPOCH FROM (NOW() - created_at)) / 86400), ' days ago')
END AS relative_created_at,
CASE
WHEN EXTRACT(EPOCH FROM (NOW() - updated_at)) < 60 THEN CONCAT(ROUND(EXTRACT(EPOCH FROM (NOW() - updated_at))), ' seconds ago')
WHEN EXTRACT(EPOCH FROM (NOW() - updated_at)) < 3600 THEN CONCAT(ROUND(EXTRACT(EPOCH FROM (NOW() - updated_at)) / 60), ' minutes ago')
WHEN EXTRACT(EPOCH FROM (NOW() - updated_at)) < 86400 THEN CONCAT(ROUND(EXTRACT(EPOCH FROM (NOW() - updated_at)) / 3600), ' hours ago')
ELSE CONCAT(ROUND(EXTRACT(EPOCH FROM (NOW() - updated_at)) / 86400), ' days ago')
END AS relative_updated_at,
CASE
WHEN deleted_at IS NULL THEN 'no'
WHEN EXTRACT(EPOCH FROM (NOW() - deleted_at)) < 60 THEN CONCAT(ROUND(EXTRACT(EPOCH FROM (NOW() - deleted_at))), ' seconds ago')
WHEN EXTRACT(EPOCH FROM (NOW() - deleted_at)) < 3600 THEN CONCAT(ROUND(EXTRACT(EPOCH FROM (NOW() - deleted_at)) / 60), ' minutes ago')
WHEN EXTRACT(EPOCH FROM (NOW() - deleted_at)) < 86400 THEN CONCAT(ROUND(EXTRACT(EPOCH FROM (NOW() - deleted_at)) / 3600), ' hours ago')
ELSE CONCAT(ROUND(EXTRACT(EPOCH FROM (NOW() - deleted_at)) / 86400), ' days ago')
END AS relative_deleted_at
FROM
post_actions
WHERE
post_action_type_id = 2
AND updated_at > NOW() - INTERVAL :timespan
AND (
:include_in_timespan_deleted = false
OR (deleted_at IS NOT NULL AND deleted_at > NOW() - INTERVAL :timespan)
)
```
---
### Author:  [@Canapin](https://meta.discourse.org/u/Canapin)
#### Post date: [January 4, 2025, 3:37pm UTC](https://meta.discourse.org/t/run-data-explorer-queries-with-the-discourse-api/120063/56 "2025-01-04T15:37:02Z")
Oooh I misread! I read the sentence as "Is it possible to do a query like âcreated or updated the last 50 secondsâ?
(notice the single quote position)
---
### Author:  [@francis\_exalate](https://meta.discourse.org/u/francis_exalate)
#### Post date: [January 4, 2025, 6:58pm UTC](https://meta.discourse.org/t/run-data-explorer-queries-with-the-discourse-api/120063/57 "2025-01-04T18:58:44Z")
Thanks all,
I posted here because that is where ask.discourse pointed me to.
What Iâm looking for is if the API is providing this capability.
---
### Author:  [@Canapin](https://meta.discourse.org/u/Canapin)
#### Post date: [January 4, 2025, 7:09pm UTC](https://meta.discourse.org/t/run-data-explorer-queries-with-the-discourse-api/120063/58 "2025-01-04T19:09:12Z")
Yes, of course.
You create the query in [data explorer](https://meta.discourse.org/t/32566?silent=true), then you run the query through the API as described in this guide.
I just ran Moinâs query via the API and it properly returned the expected results.
---
### Author:  [@tanya\_byrne](https://meta.discourse.org/u/tanya_byrne)
#### Post date: [January 14, 2025, 10:57pm UTC](https://meta.discourse.org/t/run-data-explorer-queries-with-the-discourse-api/120063/59 "2025-01-14T22:57:30Z")
I was wondering about this too. Is JSON the only way of exporting data via the API or is CSV export also supported for [Data Explorer](https://meta.discourse.org/t/32566?silent=true)?
---
### Author:  [@francis\_exalate](https://meta.discourse.org/u/francis_exalate)
#### Post date: [January 19, 2025, 11:18pm UTC](https://meta.discourse.org/t/run-data-explorer-queries-with-the-discourse-api/120063/60 "2025-01-19T23:18:52Z")
Thanks all,
Sorry for the late response - was offline for a bit.
What Iâm currently doing is to search for all topics/posts created today, and filter out the topics/posts updated before the timestamp.
---
### Author:  [@Canapin](https://meta.discourse.org/u/Canapin)
#### Post date: [January 19, 2025, 11:35pm UTC](https://meta.discourse.org/t/run-data-explorer-queries-with-the-discourse-api/120063/61 "2025-01-19T23:35:44Z")
> [@francis\_exalate](#):
>
> What Iâm currently doing is to search for all topics/posts created today, and filter out the topics/posts updated before the timestamp.
If you donât want to get your hands dirty, you can ask the bot at [ask.discourse.com](http://ask.discourse.com). Itâs usually pretty accurate regarding Discourse-related SQL queries (but donât _assume_ itâs right, check the code to be sure).
---
### Author:  [@srinivas.chilukuri](https://meta.discourse.org/u/srinivas.chilukuri)
#### Post date: [May 6, 2025, 4:06pm UTC](https://meta.discourse.org/t/run-data-explorer-queries-with-the-discourse-api/120063/62 "2025-05-06T16:06:20Z")
> [@Discourse](#):
>
> `-H "Content-Type: multipart/form-data;" \`
* * *
**Is the `Content-Type` header correct?**
In the developer tools, when inspecting a [Data Explorer](https://meta.discourse.org/t/32566?silent=true) query with params , the `Content-Type` header appears as:
```plaintext
Content-Type: application/x-www-form-urlencoded; charset=UTF-8
```
However, the current cURL command includes:
```plaintext
-H "Content-Type: multipart/form-data;"
```
* * *
---
### Author:  [@blake](https://meta.discourse.org/u/blake)
#### Post date: [May 6, 2025, 4:30pm UTC](https://meta.discourse.org/t/run-data-explorer-queries-with-the-discourse-api/120063/63 "2025-05-06T16:30:13Z")
- `multipart/form-data`
- `application/x-www-form-urlencoded`
- `application/json`
are all valid content-types you can use when making an api request.
---
### Author:  [@srinivas.chilukuri](https://meta.discourse.org/u/srinivas.chilukuri)
#### Post date: [May 6, 2025, 4:37pm UTC](https://meta.discourse.org/t/run-data-explorer-queries-with-the-discourse-api/120063/64 "2025-05-06T16:37:01Z")
@blake
language python
library requests
Could you provide a API sample [Data Explorer](https://meta.discourse.org/t/32566?silent=true) query that includes **three parameters
refer** [Topic]( [Passing params to Data Explorer using API requires enclosing a value](https://meta.discourse.org/t/passing-params-to-data-explorer-using-api-requires-enclosing-a-value/322843) ) which says params need to be strictly in double quotes
---
### Author:  [@blake](https://meta.discourse.org/u/blake)
#### Post date: [May 6, 2025, 5:15pm UTC](https://meta.discourse.org/t/run-data-explorer-queries-with-the-discourse-api/120063/65 "2025-05-06T17:15:01Z")
Sure, here is an example using python:
```python
import json
import requests
API_KEY = "YOUR_API_KEY"
API_USERNAME = "system"
QUERY_ID = 20
SITE_URL = "https://your-site-url"
# all values must be strings
params = {
"user_id": "2",
"viewed_at": "2019-06-10",
"limit": "5"
}
# Data Explorer expects params as a JSONâencoded string
payload = {
"params": json.dumps(params)
}
url = f"{SITE_URL}/admin/plugins/explorer/queries/{QUERY_ID}/run"
headers = {
"Api-Key": API_KEY,
"Api-Username": API_USERNAME,
"Content-Type": "application/json"
}
r = requests.post(url, headers=headers, json=payload)
r.raise_for_status()
print(r.json())
```