Connect Colorado Information Marketplace to FilePost

Both apps 15Colorado Information Marketplace 5FilePost 10

• Trigger
  New record

  Polling trigger: fires when a new row appears in a specified Colorado Information Marketplace (Socrata SODA API) dataset. GET https://data.colorado.gov/resource/{dataset_id}.json ordered by a rowid/created/updated system field ($order=:id DESC or an updated_at column) with $limit, dedup by the row's system id (:id) or an updated_at watermark since datasets vary in whether they expose a stable update timestamp column.

• Action
  Find datasets

  Search the Colorado Information Marketplace open-data catalog for datasets by keyword/category. GET https://data.colorado.gov/api/catalog/v1?q={query}&limit=... (Socrata Discovery API) returning dataset id, name, description, category, and update timestamps. Used to locate the dataset identifier that other ops (List/Get/Find records) require as input.

• Action
  Find records by criteria

  Query a Colorado Information Marketplace (Socrata SODA API) dataset with a SoQL $where/$select/$order filter. GET https://data.colorado.gov/api/v3/views/{dataset_id}/query.json (or resource/{dataset_id}.json on older SODA2 endpoints) with SoQL query params ($where, $select, $order, $limit, $offset). Requires the dataset identifier (8-char alphanumeric, e.g. ydr8-5enu) as input plus the SoQL clauses.

• Action
  Get record

  Get a single row from a Colorado Information Marketplace (Socrata SODA API) dataset by its row identifier. GET https://data.colorado.gov/resource/{dataset_id}/{row_id}.json (or a $where=:id='{row_id}' query when the dataset has no explicit row identifier). Requires dataset_id and row_id.

• Action
  List records

  List all rows in a Colorado Information Marketplace (Socrata SODA API) dataset, paginated. GET https://data.colorado.gov/resource/{dataset_id}.json with $limit/$offset params. Requires the dataset identifier (8-char alphanumeric, e.g. ydr8-5enu).

• Action
  Create Intake Link

  Creates a FilePost intake link — a public upload page you can send to someone so they can drop files to you, with your own limits on file type, size, count and how long it stays open.

• Action
  Delete File

  Permanently deletes a file from FilePost. The stored file and its public link are removed and cannot be recovered.

• Action
  Delete intake link

  Closes a FilePost intake link so it stops accepting uploads. Files already uploaded through it are untouched, and the slot frees up against your plan's limit on active links.

• Action
  Get file

  Returns the details FilePost holds about one stored file — its name, size, type, download link and when it expires.

• Action
  Get intake link

  Returns one intake link from your FilePost account, looked up by its intake link ID. FilePost has no single-link endpoint, so the link is selected out of your full list of intake links.

• Action
  List Files

  Returns the files stored in your FilePost account, newest first, together with the total number of files.

• Action
  List intake links

  Returns the intake links on your FilePost account, with each link's label, public upload page, limits and expiry.

• Action
  Update file

  Changes whether a stored file's name appears in its public link, and returns the file with its new link.

• Action
  Upload File

  Uploads a file to FilePost and returns its shareable link.

• Action
  Upload File From URL

  Stores a file from a public web link in FilePost and returns its shareable link.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.