Connect PostgreSQL to GoCardless

Both apps 28PostgreSQL 10GoCardless 18

• Trigger
  New or Updated Row

  Triggers when a new row is added or modified.

• Trigger
  New or Updated Row (Custom Query)

  Fires for each new or changed row returned by a SELECT statement you write against the connected PostgreSQL database.

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected PostgreSQL database.

• Action
  Add Row

  Adds a new row.

• Action
  Delete Row

  Delete the rows in a table whose chosen column equals a value.

• Action
  Find Row

  Finds a row in a table via a lookup column.

• Action
  Find Rows via Custom Query

  Runs a SELECT statement you write against the connected PostgreSQL database and returns every row it matches.

• Action
  Find Row via Custom Query

  Runs a SELECT statement you write against the connected PostgreSQL database and returns the first row it matches.

• Action
  Update Row

  Updates an existing row.

• Action
  Add billing request

  Creates a GoCardless billing request to collect a Direct Debit mandate, a one-off payment, or both from a customer.

• Action
  Add customer

  Creates a new customer record in GoCardless with their name, contact details and address.

• Action
  Add customer bank account

  Creates a bank account for an existing GoCardless customer, using local bank details or an IBAN.

• Action
  Cancel mandate

  Cancels a Direct Debit mandate so no further payments can be collected against it, and returns the cancelled mandate.

• Action
  Cancel payment

  Cancels a pending GoCardless payment so it is not collected, and returns the updated payment.

• Action
  Cancel subscription

  Cancels a GoCardless subscription so no further payments are collected under it, and returns the cancelled subscription.

• Action
  Create Direct Debit Payment

  Collects a one-off Direct Debit payment from a customer against their existing mandate.

• Action
  Create Instant Bank Payment

  Creates a billing request for a one-off instant bank payment (Pay By Bank) for the given amount and currency.

• Action
  Create Mandate Authorisation Request

  Creates a Direct Debit mandate request for a payer and returns a hosted authorisation link you can send them to set up the mandate.

• Action
  Create Subscription

  Creates a recurring subscription that collects a fixed amount on a schedule against an existing GoCardless mandate.

• Action
  Get customer

  Returns a single GoCardless customer by its ID, including contact details, address and metadata.

• Action
  Get mandate

  Returns a single Direct Debit mandate, including its status, scheme, reference and linked customer bank account and creditor.

• Action
  Get payment

  Returns a single GoCardless payment by its ID, including amount, status, charge date and linked mandate.

• Action
  Get subscription

  Returns the details of a single GoCardless subscription, including its amount, schedule, status and upcoming payments.

• Action
  Retry payment

  Retries a failed payment, resubmitting it for collection on the next available date or a date you choose.

• Action
  Search for a Billing Request

  Searches billing requests, optionally filtered by customer, status and creation date, and returns the matches.

• Action
  Search for a Customer

  Searches your GoCardless customers by email, company name, surname, currency or creation date and returns the matches.

• Action
  Update customer

  Updates an existing GoCardless customer's name, contact details, address or metadata. Fields left blank are not changed.

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