Measurements get API; when I am using country=IN Is Show Error.

[heetu]

When I was trying to hit this API::

https://api.openaq.org/v1/measurements?country=IN&date_from=2021-02-01T00:00:00Z&date_to=2021-02-05T23:00:00Z&format=csv

Got this error :: "column reference "country" is ambiguous"

https://ibb.co/gw9nq0Q

As per my t research problem is now we are getting city and country in one column, so the search is not working. but in old data(CSV), there is a separate filed for city and country

New Csv::
https://ibb.co/rtLh7f9

Old Csv::
https://ibb.co/64mGJXy

Heet Bhimani
India.

[sruti]

Hi @heetu! That column reference error should be fixed now. With the API request you shared I am getting a CSV with city and country in separate columns. Does it work for you now as well? If not, could you share exactly how you are accessing that data and not getting separate columns. Also, this repo is deprecated now and issues should be added to the v2 repo. Thanks!