Connect Chargebee and SQL Server

Both apps 29Chargebee 18SQL Server 11

• Trigger
  New Payment Method

  Triggers when a payment method is added.

• Trigger
  Payment Method Updates

  Triggers when a payment method is updated.

• Action
  Cancel Subscription

  Cancels a Chargebee subscription immediately, at the end of the term, or on a specific date.

• Action
  Change Next Billing Date

  Updates next billing date of a subscription.

• Action
  Create Customer

  Creates a customer in Chargebee, optionally with a billing address and a payment source (card, bank account, payment method token or payment intent).

• Action
  Create Subscription

  Creates a new subscription for an existing Chargebee customer from one or more item prices, and returns the subscription along with the customer, card and any invoice it generated.

• Action
  Delete Customer Card

  Deletes the card on file for a customer. Chargebee turns off auto collection for the customer and fires a card_deleted event. Succeeds without error when the customer has no card.

• Action
  Fetch Customer Subscription Details

  Retrieves a subscription by ID, along with the customer who owns it and their card on file.

• Action
  Fetch Subscription Invoice Details

  Fetches the invoices raised for one subscription, most recent first by default, with optional filters on status, dates and more.

• Action
  Find Existing Subscription

  Returns up to 100 subscriptions that match all of the specified criteria, such as subscription ID, customer ID, plan item or status.

• Action
  Finds an Existing Customer

  Finds customers whose details exactly match the criteria you supply (email, name, company, phone, ID and more). Returns up to 100 matches and the first match on its own.

• Action
  Get Invoice

  Retrieves a single Chargebee invoice by its ID.

• Action
  List Invoices

  Returns all invoices in the Chargebee site.

• Action
  Reactivate Subscription

  Restores a cancelled subscription to active, or to trial when a trial end is given.

• Action
  Record Offline Payment for an Invoice

  Records a payment received outside Chargebee (cash, check, bank transfer, etc.) against an invoice. The invoice must be in payment_due, posted or not_paid status.

• Action
  Update Card Payment Source

  Changes the cardholder name, expiry date or billing address on a customer's saved card.

• Action
  Update Customer

  Updates the details of an existing Chargebee customer, including custom fields. Billing address and VAT number are changed through Chargebee's separate billing-info update, not this action.

• Action
  Update Subscription

  Updates a subscription in Chargebee.

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

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