Connect Caspio to Represent by Open North

Both apps 15Caspio 8Represent by Open North 7

• Trigger
  Deleted Record

  Fires when a record is deleted from the selected Caspio table. Instant self-registering webhook (table.recordDelete) — picking this trigger and a Table auto-registers the Caspio webhook on activation, scoped to that table.

• Trigger
  New or Updated Record

  Fires when a record is inserted or updated in the selected Caspio table. Instant self-registering webhook registering both table.recordInsert and table.recordUpdate — picking this trigger and a Table auto-registers the Caspio webhook on activation, scoped to that table.

• Trigger
  New Record

  Fires when a new record is inserted into the selected Caspio table. Instant self-registering webhook (table.recordInsert) — picking this trigger and a Table auto-registers the Caspio webhook on activation, scoped to that table. Payload: trigger.body = {data:[record...], objectName, eventType, eventDate, eventId, ...}.

• Trigger
  Updated Record

  Fires when a record's field value changes in the selected Caspio table. Instant self-registering webhook (table.recordUpdate) — picking this trigger and a Table auto-registers the Caspio webhook on activation, scoped to that table.

• Action
  Download File from Field

  Download the file stored in an Attachment-type field of a specific record. Returns the raw file content.

• Action
  Find Records

  Query records from a selected Caspio table with an optional WHERE filter, ORDER BY, and limit. Returns the matching records.

• Action
  Find View Records

  Query records from a Caspio View (a saved joined/filtered/aggregated dataset spanning tables). Optional WHERE / ORDER BY / limit.

• Action
  Upload File to Field

  Upload a file (from a URL) into an Attachment-type field of a specific record. Table from a dropdown, the attachment field and record ID (the record's primary-key value) are supplied per call. Requires an Attachment-type column (not the legacy File type).

• Action
  Find representatives by point

  Find elected officials for a given latitude/longitude. GET /representatives/?point={lat},{lng} (optionally scoped to a representative set via /representatives/{set}/?point=...); supports filters like last_name, party_name, elected_office.

• Action
  Find representatives by postal code

  Look up elected officials and boundaries covering a Canadian postal code. GET /postcodes/{postal_code}/ — returns boundaries_centroid, boundaries_concordance, representatives_centroid, representatives_concordance; optional sets query param restricts to a boundary set.

• Action
  List boundaries

  Paginated list of electoral boundaries. GET /boundaries/ (optionally /boundaries/{boundary_set}/, or comma-separated multiple sets via ?sets=); filterable by name/external_id.

• Action
  List boundaries covering a point

  Find electoral boundaries containing a given latitude/longitude. GET /boundaries/?contains={lat},{lng} (optionally scoped to a boundary set via /boundaries/{set}/?contains=...).

• Action
  List boundary sets

  List available boundary sets (groups of electoral districts, e.g. federal-electoral-districts, toronto-wards). GET /boundary-sets/; filterable by name/domain. GET /boundary-sets/{slug}/ for a single set.

• Action
  List candidates

  Paginated list of electoral candidates for tracked elections. GET /candidates/ — behaves like /representatives/, filterable by name, first_name, last_name, gender, district_name, party_name.

• Action
  List representatives

  Paginated list of elected officials. GET /representatives/ (optionally /representatives/{representative_set}/); filterable by name, first_name, last_name, gender, district_name, elected_office, party_name.

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