[Service] Request Counts

[jmensch1]

Description

This service can provide data for both the "How People Contact 311" and "Request Types" pie charts.

Both charts require a simple count of the number of requests, grouped by a particular field in the database. "How People Contact 311" is based on a grouping of the "requestsource" field, and "Request Types" is based on a grouping of the "requesttype" field. A single endpoint can provide both counts.

Endpoint

Accepted methods

• GET
• POST

Path: server:port/requestcounts

Inputs

The inputs are all of the usual filters, plus a countFields params that lists the fields we want to count by.

{
  "startDate": "2015-01-01",
  "endDate": "2015-12-31",
  "ncList": ["SUNLAND-TUJUNGA NC"],
  "requestTypes": ["Homeless Encampment", "Graffiti Removal", "Bulky Items"],
  "countFields": ["requesttype", "requestsource"]
}

Outputs

{
  "lastPulled": "NOW",
  "data": [
    {
      "field": "requesttype",
      "counts": {
        "Homeless Encampment": 300,
        "Graffiti Removal": 500,
        "Bulky Items": 200
      }
    },
    {
      "field": "requestsource",
      "counts": {
        "Mobile App": 200,
        "Self Service": 200,
        "Driver Self Report": 200,
        "Call": 200,
        "Email": 100,
        "Other":  100
      }
    }
  ]
}