Curl with filter returns '400 Bad Request'

User Support API
, ,
#1

When i try to download data in json with parameter filter:

curl --compressed -g -X GET ‘https://kc.kobotoolbox.org/api/v1/data/902546?query={"_submission_time":{"$gt": “2022-01-17T17:14:45:30”}}’

I have the error 400 Bad Request

But this same request work last week. Are the a update on koboToolBox plateforme?

Thanks for reply

#3

I have a problem downloading the JSON database with CURL.
The same script curl market several days ago, but since yesterday it shows me this error in the downloaded file:

<html>
<head><title>400 Bad Request</title></head>
<body>
<center><h1>400 Bad Request</h1></center>
<hr><center>nginx/1.21.6</center>
</body>
</html>

Command:
curl -X GET ‘https://kc.kobotoolbox.org/api/v1/data/902546?query={"_submission_time":{"$gt": “2022-01-17T17:14:45:30”}}’ -H …

Thanks for your helps!

#5

@momou28, have you checked your data to see if it’s public?

#6

@Kal_Lam , I use my administrator account which hosts the form and I am the owner. When I remove the query filter, there is no problem. But with the filter it generates the error. Last week no problem.
Where do I check if the data is public?
For information, I use the administrator account in the command for downloading.

Thanks a lot KAL

#7

This post discussed previously should help you make your data public:

#8

Hi @momou28, it looks like the issue is with the type of quotes surrouding the date in your query. If I replace “2022-01-17T17:14:45:30” with "2022-01-17T17:14:45:30" then it works :+1:

1 Like
#9

Thank a lot

1 Like