I have a question that is very similar to (but different from) the question posted here: `DataExplorer::ValidationError: Missing parameter` when running Data Explorer queries with [params] via API. My query in Data Explorer looks like this: -- [params] -- topic_id :topic_id SELECT * FROM posts WHERE topic_id = :topic_id This works fine in Data Explorer. Then, when I try and run it via the API I get: {"success":false,"errors":["DiscourseDataExplorer::ValidationError: Missing parameter topic_id of type topic_id"]}' Here is my python request: headers = { 'Content-Type': 'multipart/form-data;', 'Api-Key': API_KEY, 'Api-Username': USERNAME_SYSTEM } params = {"topic_id": 398} response = requests.post(url="[REDACTED]/admin/plugins/explorer/queries/10/run", headers=headers, params=params) I gather from the error than I cannot pass “topic_id” as a string, but I don’t see how else I can pass it as a key. Any thoughts on this?

I had to try a lot of different alternatives, but this worked: headers=headers, data={'params': '{\"topic_id\": "398"}'})``` So, the answer is a combination of that prior post (which said you have to escape the quotes when you are sending from a Windows machine and Arkshine's post which says it needs to be passed as data and not as a params kwarg. What I find odd though, is I thought the whole point of the params kwarg in the Python requests module was to pass parameter information.

I’m glad it worked! I tried sending Linux (wsl) or Windows; I don’t have the same issue, and it worked for both. :thinking: data = { 'params': '{"topic_id": "3"}' } response = requests.post( url="http://localhost:4200/admin/plugins/explorer/queries/4/run", headers=headers, data=data ) [image]

Discourse Data Explorer SQL Query

Product Support

Arkshine March 15, 2025, 3:23am 2

The parameters are not passed in the URL.

Maybe something like: data={“params”: ‘{“topic_id”:"398"}’?

Topic		Replies	Views
`DataExplorer::ValidationError: Missing parameter` when running Data Explorer queries with [params] via API Data & reporting rest-api , sql-query	8	1390	April 10, 2022
"DataExplorer::ValidationError: Missing parameter end_date of type string Product Support	2	934	May 27, 2020
Passing params to Data Explorer using API requires enclosing a value Bug data-explorer , rest-api	3	258	January 5, 2025
Validation error even when parameter passed while running data explorer API with Curl Product Support	5	1320	May 25, 2021
How to run Data Explorer queries with Python Data & reporting rest-api	2	1208	March 30, 2020

Discourse Data Explorer SQL Query

Related topics