Connect Colorado Information Marketplace to Stripe

Both apps 37Colorado Information Marketplace 5Stripe 32

• 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 Charge

  Triggers when a new charge is created.

• Trigger
  New Charge (instant)

  Fires instantly when a charge succeeds in Stripe, via a self-registered webhook (charge.succeeded). The platform registers/deletes the Stripe webhook endpoint automatically at automation activation/deactivation. Payload binds as {{ trigger.body.* }}.

• Trigger
  New Customer

  Triggers when a new customer is created.

• Trigger
  New Event

  Triggers when a new Stripe event is created (covers all event types via the Events API).

• Trigger
  New Invoice

  Triggers when a new invoice is created.

• Trigger
  New paid and available charge

  Triggered when a new paid and available charge is created.

• Trigger
  New paid charge

  Triggered when a new paid charge is created.

• Trigger
  New plan

  Triggered when a new plan is created.

• Trigger
  New Product

  Triggers when a new product is created.

• Trigger
  New Refund

  Triggers when a new refund is created.

• Trigger
  New Subscription

  Triggers when a new subscription is created.

• Action
  Cancel Subscription

  Cancels a subscription by its ID.

• Action
  Create Charge

  Creates a charge. Amount is in the smallest currency unit (e.g. cents).

• Action
  Create charges (bulk charge creation)

  Creates a charge in Stripe.

• Action
  Create Customer

  Creates a new customer in Stripe.

• Action
  Create Payment Intent

  Creates a PaymentIntent (the modern Stripe payment flow). Amount is in the smallest currency unit.

• Action
  Create Price

  Creates a price for a product. unit_amount is in the smallest currency unit.

• Action
  Create Product

  Creates a product (a good or service) in Stripe.

• Action
  Create Refund

  Refunds a charge or payment intent. Provide charge or payment_intent; amount optional for partial refund.

• Action
  Create refund by charge id (distinct from Create Refund)

  Creates a refund for a specific charge id.

• Action
  Create Subscription

  Creates a subscription for a customer to one or more prices.

• Action
  Delete Customer

  Permanently deletes a customer by ID.

• Action
  Find Customer by Email

  Searches for customers matching an email address.

• Action
  Get Charge

  Retrieves a charge by its ID.

• Action
  Get charge details (distinct from Get Charge)

  Retrieves a charge's details by its charge id.

• Action
  Get Customer

  Retrieves a customer by their Stripe ID.

• Action
  Get Invoice

  Retrieves an invoice by its ID.

• Action
  Get Refund

  Retrieves a refund by its ID.

• Action
  Get Subscription

  Retrieves a subscription by its ID.

• Action
  Get transaction details

  Retrieves a transaction's details by its transaction id.

• Action
  List balance transactions

  List balance transactions (txn_xxx) for the account, most recent first.

• Action
  Update Customer

  Updates an existing customer by ID.

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