Connect Colorado Information Marketplace to SparrowDesk

Both apps 24Colorado Information Marketplace 5SparrowDesk 19

• 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).

• Trigger
  New Contact

  Fires when a new contact is created. Poll GET /contacts sorted by creation date, or via new webhook subscription on contact-created event.

• Trigger
  New Ticket

  Fires when a new conversation (ticket) is created. Poll GET /conversations sorted by creation date, or via new webhook subscription on ticket-created event.

• Action
  Add Company

  Create a company. POST /companies

• Action
  Add Ticket Reply

  Create a reply on a conversation (ticket). POST /conversations/{id}/reply

• Action
  Create Contact

  Creates a new contact in your SparrowDesk account.

• Action
  Create Ticket

  Creates a new ticket (conversation) in your SparrowDesk account.

• Action
  Delete Contact

  Delete a contact by ID. DELETE /contacts/{id}

• Action
  Delete Ticket

  Delete a conversation (ticket) by ID. DELETE /conversations/{id}

• Action
  Get Company

  Retrieve a company by ID. GET /companies/{id}

• Action
  Get Contact

  Retrieve a single contact by ID. GET /contacts/{id}

• Action
  Get Ticket

  Retrieve a single conversation (ticket) by ID. GET /conversations/{id}

• Action
  List Companies

  List all companies. GET /companies

• Action
  List Contacts

  List all contacts. GET /contacts

• Action
  List Members

  List all team members on the account. GET /members

• Action
  List Tags

  List all tags on the account. GET /tags

• Action
  List Tickets

  List all conversations (tickets). GET /conversations

• Action
  Update Company

  Update a company by ID. PATCH /companies/{id}

• Action
  Update Contact

  Update a contact by ID. PATCH /contacts/{id}

• Action
  Update Ticket

  Update a conversation (ticket) by ID. PATCH /conversations/{id}

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