Connect MySQL to AddressZen

Both apps 19MySQL 10AddressZen 9

• 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
  Find addresses by search term

  Returns address suggestions (a display label and an id) matching a partial address, ranked by relevance. Use Get address with an id to retrieve the full address.

• Action
  Find places by search term

  Returns up to 10 place suggestions (countries, regions, cities and other administrative areas) matching a search term, each with an id you can pass to Get place.

• Action
  Freeform US Address Verification

  Verifies a full one-line US address against USPS CASS data and returns the standardized, corrected address with ZIP+4 and delivery details.

• Action
  Get address

  Returns the full address for an address suggestion id from Find addresses by search term. Each successful retrieval uses one lookup from your balance.

• Action
  Get place

  Returns the full details of a place (coordinates, language and the underlying GeoNames record) for a place ID taken from a Find places result.

• Action
  US Address Verification With Street Address and Zip Code

  Verifies and standardizes a US street address using its ZIP code, returning the corrected address with ZIP+4 and USPS delivery details.

• Action
  US Address Verification With Street Address, City and State

  Verifies a US street address given its street line, city and state, and returns the standardized, USPS CASS-corrected address with ZIP+4 and match scores.

• Action
  Validate email address

  Checks whether an email address is deliverable and reports whether it is disposable, free, a role address or on a catch-all domain.

• Action
  Validate phone number

  Validates a phone number and returns whether it is valid, its country, national and international formats, and its original (and optionally current) carrier.

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