API Refresh with parameters in query string

[lucaschernbeck]

Hello,

I've been trying to build a Pyton script where I refresh a query with parameters in the JSON body, check the progress and then retrieve the results - all via API calls.
I'm having some trouble with the refresh call that I run. Below you can find the call and body I am using - I have redacted any information.
My SQL query looks like this:

SELECT field1
FROM table1
WHERE field2 = '{{ param2 }}'
AND field3 = '{{ param3 }}'
AND field4 = '{{ param4 }}'
AND field 1 IS NOT NULL

My refresh call is made via:
https://myinstance.com/api/queries/<query_id>/refresh?api_key=<user_api_key>

My refresh call body looks like this:

{
    "params": {
        "param2": "value2",
        "param3": "value3",
        "param4": "value4"
    }
}

At first I was getting the following error:
{ "job": { "status": 4, "error": "Missing parameter value for: param2, param3, param4" } }

I also tried changing the parameter names in accordance to the URL query strings used on the redash website URL but this gave me the same result:

{
    "params": {
        "p_param2": "value2",
        "p_param3": "value3",
        "p_param4": "value4"
    }
}

Does anyone have any experience with running the refresh call with parameters in the JSON body?

Thank you!

[lucaschernbeck]

I realised that I used an outdated endpoint with /refresh.
Using the /results endpoint worked.