Connect PostgreSQL and Vouchery.io

Both apps 25PostgreSQL 10Vouchery.io 15

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

• Trigger
  New Voucher

  Triggers when a new voucher is created in the selected Vouchery campaign.

• Action
  Add campaign

  Creates a promo campaign in Vouchery — either a main campaign or a sub campaign under an existing main campaign — and returns the new campaign.

• Action
  Assign vouchers to customer

  Assigns one or more voucher codes to a customer and returns the customer's updated record.

• Action
  Cancel redemption

  Cancels a redemption by its redemption ID, marking it as cancelled.

• Action
  Confirm redemption

  Confirms a redemption so it counts toward the campaign's budget and total redemptions. Returns the confirmed redemption.

• Action
  Create Customer

  Creates a customer in Vouchery with their unique identifier, contact details, segment categories and metadata.

• Action
  Create Redemption

  Redeems a voucher code for a purchase, recording the order total or line items and returning the redemption with the discount and rewards granted.

• Action
  Delete customer

  Deletes a customer from your Vouchery project by their identifier.

• Action
  Find Voucher

  Finds a voucher by its code and returns its status, campaign, customer and redemption details.

• Action
  Get campaign

  Returns a single Vouchery campaign by its ID, including its rules, rewards, budget and voucher statistics.

• Action
  Get customer

  Returns a single customer by their identifier, including profile details, segments, loyalty points and voucher/redemption statistics.

• Action
  Get redemption

  Returns a single redemption by its ID, including its voucher, campaign, customer, confirmation status and granted rewards.

• Action
  List campaigns

  Returns the campaigns in your Vouchery project, optionally filtered by name, team, status, template or loyalty program.

• Action
  List customers

  Returns the customers in your Vouchery project, optionally filtered by identifier or email.

• Action
  Update customer

  Updates an existing customer's name, email, referral code, birthdate, segments or metadata. Only the values you provide are changed.

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