Connect Salesforce to Colorado Information Marketplace

Both apps 16Salesforce 11Colorado Information Marketplace 5

• Trigger
  New object record

  Polling trigger: fires for each new record created in the specified SObject type. Polls SOQL ordered by CreatedDate descending.

• Trigger
  New or updated object record

  Polling trigger: fires for each record created or modified in the specified SObject type. Polls SOQL ordered by SystemModstamp descending.

• Action
  Create object record

  Creates a new record of the specified SObject type (standard or custom, e.g. Account, Contact, Lead, Opportunity, Case, or MyObject__c) with the supplied field values.

• Action
  Delete object record

  Deletes an existing SObject record by object type and record ID.

• Action
  Describe object

  Returns the full field and metadata description (describe) for an SObject type — useful for discovering available fields and their API names.

• Action
  Find most recent created or updated record

  Returns the single most recently created or last-modified record for the specified SObject type (ordered by SystemModstamp DESC, LIMIT 1).

• Action
  Find object records

  Finds matching records for an SObject type by a field/value equality match via SOQL. Returns Id and the requested fields for all matches.

• Action
  Get object record

  Retrieves a single SObject record by object type and record ID. Optionally restrict returned fields with a comma-separated 'fields' list.

• Action
  List objects

  Lists all available SObject types (standard and custom) on the org.

• Action
  SOQL query

  Executes a SOQL query against the org and returns matching records. Example: SELECT Id, Name FROM Account WHERE CreatedDate = TODAY.

• Action
  Update object record

  Updates an existing SObject record by object type and record ID with the supplied field values. Salesforce returns no body on success (HTTP 204).

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

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