I’m in process of creating a query with data explorer with the APIs. I’m having a hard time finding the actual API call to create a query. There is an endpoint to run the query /admin/plugins/explorer/queries/ /run ; however don’t see to create it. Can anyone help ?

Have you tried to Reverse engineer the Discourse API?

Thanks for sharing the article of Reverse engineer the discourse API ; I’ve gone through it and realised that there should be two separate calls need to be made. First should be, the POST call to /admin/plugins/explorer/queries , which will generate the ID associated with the query. Secondly, the PUT call needs to be made on /admin/plugins/explorer/queries/id to edit the default query. But I’m wondering whether there is a provision to create the query(by making the single API call) directly without knowing the ID. Let me know if that’s possible.

You should be able to make a POST request with the same payload values as PUT. Did you try?

Here is the query which I tried by making POST API call. curl -X POST https://api-discourse-XXXXXXXXXXXXX/admin/plugins/explorer/queries -H “Content-Type: multipart/form-data;” -H “Api-Key: 46811cc32XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX” -H “Api-Username: abcdefg2” -F ‘query={“name”:“test1234”, “sql”:“SELECT * FROM topics”}’ However, I’m getting an error as below. {“status”:500,“error”:“Internal Server Error”}% Not sure what could be wrong.

I think the correct way is the following: -F 'query[name]=test1234' -F 'query[sql]=SELECT * FROM topics'

איך ליצור שאילתה של data explorer עם ה-APIs?

מפתח

Tanay_Suthar (Tanay Suthar) 9 בנובמבר,‏ 2023,‏ 3:42pm 8

Thanks @Arkshine for the help.

It worked..!!

נושא		תגובות	צפיות
Can I create a new query in Data Explorer using API? Development data-explorer , rest-api	2	748	26 בינואר,‏ 2026
Access to query data from API endpoints Data & reporting sql-query	6	4333	16 במרץ,‏ 2018
How to run Data Explorer queries with Python Data & reporting rest-api	2	1208	30 במרץ,‏ 2020
Run Data Explorer queries with the Discourse API Integrations data-explorer , rest-api , how-to	14	14437	6 במאי,‏ 2025
Discourse Data Explorer Plugin official , data-explorer , included-in-core	30	87714	22 באוקטובר,‏ 2025

איך ליצור שאילתה של data explorer עם ה-APIs?

נושאים קשורים