How to query api with filter options

Question

I am trying filter the response city wise. I am not able to understand how to query filter parameters.

I have tried different ways but with no success. This is the response without applying filter. But I want filter it for a particular city.

{
  "index_name": "3b01bcb8-0b14-4abf-b6f2-c1bfd384ba69",
  "title": "Real time Air Quality Index from various location",
  "desc": "Real time Air Quality Index from various location",
  "org_type": "Central",
  "org": [
    "Ministry of Environment and Forests",
    "Central Pollution Control Board"
  ],
  "sector": [
    "Industrial Air Pollution"
  ],
  "source": "data.gov.in",
  "catalog_uuid": "a3e7afc6-b799-4ede-b143-8e074b27e0621",
  "visualizable": "1",
  "active": "1",
  "created": 1543320551,
  "updated": 1559683085,
  "created_date": "2018-11-27T17:39:11Z",
  "updated_date": "2019-06-05T02:48:05Z",
  "target_bucket": {
    "index": "air_quality",
    "type": "a3e7afc6-b799-4ede-b143-8e074b27e0621",
    "field": "3b01bcb8-0b14-4abf-b6f2-c1bfd384ba69"
  },
  "field": [
    {
      "id": "id",
      "name": "id",
      "type": "double"
    },
    {
      "id": "country",
      "name": "country",
      "type": "keyword"
    },
    {
      "id": "state",
      "name": "state",
      "type": "keyword"
    },
    {
      "id": "city",
      "name": "city",
      "type": "keyword"
    },
    {
      "id": "station",
      "name": "station",
      "type": "keyword"
    },
    {
      "id": "last_update",
      "name": "last_update",
      "type": "date"
    },
    {
      "id": "pollutant_id",
      "name": "pollutant_id",
      "type": "keyword"
    },
    {
      "id": "pollutant_min",
      "name": "pollutant_min",
      "type": "double"
    },
    {
      "id": "pollutant_max",
      "name": "pollutant_max",
      "type": "double"
    },
    {
      "id": "pollutant_avg",
      "name": "pollutant_avg",
      "type": "double"
    },
    {
      "id": "pollutant_unit",
      "name": "pollutant_unit",
      "type": "keyword"
    }
  ],
  "status": "ok",
  "message": "Resource detail",
  "total": 1000,
  "count": 10,
  "limit": "10",
  "offset": "8",
  "records": [
    {
      "id": "13",
      "country": "India",
      "state": "Andhra_Pradesh",
      "city": "Rajamahendravaram",
      "station": "Anand Kala Kshetram, Rajamahendravaram - APPCB",
      "last_update": "05-06-2019 02:00:00",
      "pollutant_id": "CO",
      "pollutant_min": "2",
      "pollutant_max": "50",
      "pollutant_avg": "28",
      "pollutant_unit": "NA"
    },
    {
      "id": "14",
      "country": "India",
      "state": "Andhra_Pradesh",
      "city": "Rajamahendravaram",
      "station": "Anand Kala Kshetram, Rajamahendravaram - APPCB",
      "last_update": "05-06-2019 02:00:00",
      "pollutant_id": "OZONE",
      "pollutant_min": "37",
      "pollutant_max": "132",
      "pollutant_avg": "71",
      "pollutant_unit": "NA"
    }
    {
      "id": "16",
      "country": "India",
      "state": "Andhra_Pradesh",
      "city": "Tirupati",
      "station": "Tirumala, Tirupati - APPCB",
      "last_update": "05-06-2019 02:00:00",
      "pollutant_id": "PM10",
      "pollutant_min": "33",
      "pollutant_max": "72",
      "pollutant_avg": "55",
      "pollutant_unit": "NA"
    }
  ],
  "version": "2.1.0"
}

This is only documentation on how to do filtering.

properties: OrderedMap { "id": OrderedMap { "type": "integer" }, "date": OrderedMap { "type": "integer" } }

How to form request url for filtering the response?

Api Webpage Link

h4rdw1r3
– h4rdw1r3

2019-06-04 21:42:14 +00:00
Commented Jun 4, 2019 at 21:42 — h4rdw1r3
– h4rdw1r3, Commented Jun 4, 2019 at 21:42
Check here: stackoverflow.com/a/57556943/1844056

swateek
– swateek

2020-03-25 09:02:13 +00:00
Commented Mar 25, 2020 at 9:02 — swateek
– swateek, Commented Mar 25, 2020 at 9:02

Raghav7890 · Accepted Answer · 2019-07-07 03:54:51Z

3

yes the documentation is very poor, but still out of many trials I got it work like this

https://api.data.gov.in/resource/3b01bcb8-0b14-4abf-b6f2-c1bfd384ba69?api-key=<your key>&format=json&offset=0&limit=10 &filters[pollutant_id]=NO2

answered Jul 7, 2019 at 3:54

Raghav7890

4583 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Anshul Bansal Over a year ago

How to have multiple queryparams?

swateek Over a year ago

@AnshulBansal check here: stackoverflow.com/a/57556943/1844056

Bharath Ram Over a year ago

@Raghav7890 @swateek How to filter by date field. I tried filter[last_update] = 17-05-2020 but its not working

Raghav7890 Over a year ago

@ErBharathRam, I haven’t tried it with a date but just a thought, try providing Unix time as value for that last_update.

avatar Over a year ago

@ErBharathRam Are you able to filter based on Date? If yes, can you please give me which method worked for you

|

Collectives™ on Stack Overflow

How to query api with filter options

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related