Connect MySQL to Voucherify

Both apps 32MySQL 10Voucherify 22

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

• Action
  Add Campaign

  Create a new voucher campaign (discount, gift, referral, or loyalty).

• Action
  Add Customer

  Create a new customer profile with contact info, address, and metadata.

• Action
  Add Publication

  Publishes a voucher to a customer: either a specific voucher code, or one or more codes drawn from a campaign.

• Action
  Add Voucher

  Create a new voucher, optionally with a specific or auto-generated code, discount/gift/loyalty-card type, and validity rules.

• Action
  Add Vouchers to Campaign

  Adds one or more new vouchers to an existing campaign. New vouchers inherit the campaign's settings unless overridden here.

• Action
  Check eligibility

  Returns the vouchers, promotion tiers and campaigns a customer and/or order qualifies for.

• Action
  Delete Campaign

  Deletes a campaign and all its vouchers, either moving them to the bin or removing them permanently. Deletion runs in the background.

• Action
  Delete Customer

  Deletes a customer in Voucherify. The customer is removed, so a new customer with the same source id can be created afterwards.

• Action
  Delete Voucher

  Deletes a voucher by its code, either moving it to the bin or removing it permanently. Also removes the voucher's redemptions.

• Action
  Get Campaign

  Retrieves a Voucherify campaign by its id or name.

• Action
  Get Customer

  Retrieve a single customer by ID or source_id.

• Action
  Get Redemption

  Returns a single redemption or redemption rollback by its ID, whether it succeeded or failed.

• Action
  Get Voucher

  Retrieves a voucher by its code or the id Voucherify assigned to it.

• Action
  List Campaigns

  Lists campaigns in the Voucherify project, optionally filtered by type, status or referral flag.

• Action
  List Customers

  Returns a list of customers, optionally filtered by email, city, name, segment, or created/updated dates.

• Action
  List Redemptions

  Returns a list of redemptions and redemption rollbacks, most recent first, optionally narrowed by result, campaign, customer, date and other filters.

• Action
  List Vouchers

  Returns vouchers in the project, most recent first, optionally narrowed by campaign, category, customer, code or creation/update dates.

• Action
  Redeem Voucher

  Redeems a voucher code (discount code, gift card or loyalty card) against an optional order and customer, incrementing the voucher's redemption count.

• Action
  Rollback Redemption

  Undo a single (non-stacked) redemption, returning its redemption to the voucher's pool and restoring any gift card credits or loyalty points it used.

• Action
  Update Customer

  Updates an existing Voucherify customer. Only the values you fill in are changed; blank fields are left as they are.

• Action
  Update Voucher

  Updates an existing voucher. Only the values you fill in are changed; everything else on the voucher stays as it is.

• Action
  Validate voucher

  Checks whether a voucher, gift card or loyalty card code can be applied to an order and customer, and returns the discount it would give, without redeeming it.

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