Connect MySQL and ProAbono

Both apps 24MySQL 10ProAbono 14

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

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected MySQL 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

  Run an author-written SELECT against the connected MySQL database and return every row it produced. Mirrors PostgreSQL 715ae2ac, SQL Server 8e0bbb5d and Oracle 2c308e4d; MySQL placeholder style is ?.

• Action
  Find Row via Custom Query

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

• Action
  Update Row

  Updates an existing row.

• Trigger
  Event(s) Related to a Customer

  Triggers when a customer is created or updated in ProAbono (name, email, status, language or other customer details change).

• Action
  Anonymize a Customer

  Anonymizes a customer in ProAbono, clearing their personal details such as name and email. Returns the anonymized customer.

• Action
  Bill a Customer

  Invoices a customer's current balance right away instead of waiting for the next billing cycle, optionally adding a note to the invoice.

• Action
  Create a Line in the Customer Balance

  Adds a one-time debit or credit line to a customer's balance in ProAbono. The line is invoiced with the customer's next billing.

• Action
  Create or Update a Customer

  Creates a customer in ProAbono, or updates the existing customer that has the same customer reference. Returns the customer record with its customer-portal links.

• Action
  Get invoice

  Returns a single ProAbono invoice by its ID, including its number, state, amounts, customer and links to view or pay it.

• Action
  List customers

  Returns the customers in your ProAbono account, optionally only those in one segment or those with an active subscription that includes a given feature.

• Action
  Retrieve a Customer

  Returns a customer by your own customer reference, including their status, segment, metadata and customer portal links.

• Action
  Retrieve Billing Address of a Customer

  Returns the billing address of a customer, looked up by your own customer reference.

• Action
  Retrieve Full Invoice (PDF)

  Returns a full invoice by its ID, including its amounts, status and a link to download the invoice PDF.

• Action
  Retrieve Payment Settings of a Customer

  Returns a customer's payment settings: payment type, billing mode, grey-list status, invoice note and next billing date.

• Action
  Suspend a Customer

  Suspends a customer so they can no longer access the customer portal, download invoices, use their payment method or receive emails. Returns the updated customer.

• Action
  Update Billing Address of a Customer

  Sets or updates the billing address of a ProAbono customer, and returns the saved address.

• Action
  Update Payment Settings of a Customer

  Updates a customer's payment settings in ProAbono, such as a manual payment method, billing mode, next billing date or the note shown on their invoices, and returns the saved settings.

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