SODA Query

SODA (Socrata) Query Client for Deno.

Features

Create SODA queries
Use SODA queries to fetch from Socrata Open Data API
Build complex queries with ease, in a functional way
SQL Builder, inspired by sql-builder

Installation

import { SodaQuery } from "https://deno.land/x/soda/mod.ts";

Example

import { SodaQuery } from "https://deno.land/x/soda/mod.ts";

const DOMAIN = "data.cityofnewyork.us";
const DATASET = "erm2-nwe9";

const query = new SodaQuery(DOMAIN).withDataset(DATASET)
  .select("agency", "borough", "complaint_type")
  .where("complaint_type", "LIKE", "Noise%")
  .where("created_date", ">", "2019-01-01T00:00:00.000")
  .where("created_date", "<", "2020-01-01T00:00:00.000")
  .order("created_date", "DESC")
  .limit(10)
  .execute();

API

SodaQuery

You can create a new SodaQuery instance by passing a domain and optionally an authOptions object and an options object.

import { SodaQuery } from "https://deno.land/x/soda/mod.ts";

const query = new SodaQuery("data.organization.com");

There is also a shorthand, that will use the domain and dataset ID:

import { createQueryWithDataset } from "https://deno.land/x/soda/mod.ts";

const query = createQueryWithDataset("data.organization.com", "dataset-id");

Querying data

Note: Most methods return the instance of SodaQuery. This means that you can chain methods together.

—> Documentation coming soon <---

Development

TODO:

Add case method

License

MIT