San Francisco Open Data - DataSF

Search hundreds of datasets from the City and County of San Francisco

Go to site
Explore
/
Apps
/
San Francisco Open Data - DataSF

San Francisco Open Data - DataSF API Integrations

Build and run workflows using the San Francisco Open Data - DataSF API. Use 1000s of open source triggers and actions across 800+ apps. Or write custom code to integrate any app or API in seconds.

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    san_francisco_open_data_datasf: {
      type: "app",
      app: "san_francisco_open_data_datasf",
    }
  },
  async run({steps, $}) {
    // Below, we fetch a range of COVID-19 case data from DataSF. You can
    // run this to see how the results are displayed on Pipedream, or modify it 
    // in any way to fetch data from another dataset or modify the Socrata 
    // query. See the docs below for Socrata docs and examples.
    
    // COVID-19 Cases Summarized by Date, Transmission and Case Disposition
    // https://dev.socrata.com/foundry/data.sfgov.org/tvq9-ec9w
    
    return await axios($, {
      url: `https://data.sfgov.org/resource/tvq9-ec9w.json`,
      headers: {
        "X-App-Token": `${this.san_francisco_open_data_datasf.$auth.app_token}`,
      },
      params: {
        "$where": `date between '2020-05-18T00:00:00' and '2020-05-20T00:00:00'`,
      },
    })
  },
})

Authentication

San Francisco Open Data - DataSF uses API keys for authentication. When you connect your San Francisco Open Data - DataSF account, Pipedream securely stores the keys so you can easily authenticate to San Francisco Open Data - DataSF APIs in both code and no-code steps.

Sign up for a DataSF account, visit your Developer Settings, and click the button to Create New App Token under the App Tokens section.

Once you generate your app token, add it below.