Connect SQL Server to GoCardless

Both apps 29SQL Server 11GoCardless 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 SQL Server database.

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected SQL Server database.

• Action
  Add Row

  Add one row to a table on the connected SQL Server database.

• Action
  Delete Row

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

• Action
  Find Row

  Find the first row in a table whose chosen column matches a value.

• Action
  Find Rows via Custom Query

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

• Action
  Find Row via Custom Query

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

• Action
  Run Custom Statement

  Runs a statement you write against the connected SQL Server database that changes data rather than returning rows, and reports how many rows it changed.

• Action
  Update Row

  Change column values on every row of a table whose chosen column matches a value.

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