Search hundreds of datasets from the City and County of San Francisco
Emit new events each time a row or rows are added to the bottom of a spreadsheet. To use this source with a spreadsheet in a Shared Drive, use the New Row Added (Shared Drive, Instant) source instead.
Emit new events each time a row or rows are added to the bottom of a spreadsheet in a shared drive
Emit new event each time a row or cell is updated in a spreadsheet. To use this source with a spreadsheet in a Shared Drive, use the New Updates (Shared Drive, Instant) source instead.
Emit new event each time a row or cell is updated in a spreadsheet in a shared drive
Emit new event each time a new worksheet is created in a spreadsheet. To use this source with a spreadsheet in a Shared Drive, use the New Worksheet (Shared Drive, Instant) source instead.
Have you ever been curious about the data available in San Francisco? The
DataSF API provides you with access to dozens of datasets, giving you powerful
insights into the heart of the city. With this data, you can build and create a
variety of projects, from visualizations to exploration tools.
The DataSF API provides a wealth of data about San Francisco, from crime
statistics to building permits. Here are some example projects you can create
with this data:
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'`,
},
})
},
})
Some examples of things you can build using the Google Sheets API include:
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
google_sheets: {
type: "app",
app: "google_sheets",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://www.googleapis.com/oauth2/v1/userinfo`,
headers: {
Authorization: `Bearer ${this.google_sheets.$auth.oauth_access_token}`,
},
})
},
})