Connect PostgreSQL to Ideal Postcodes

Both apps 18PostgreSQL 10Ideal Postcodes 8

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

• Action
  Cleanse address

  Returns the closest matching standardised address for a freeform address, with a confidence score and match levels for each address element.

• Action
  Find addresses by query

  Returns address suggestions matching a partial address, ordered by relevance, with optional filters and biases by postcode, town, region or location.

• Action
  Find places

  Returns up to 10 place suggestions (countries, administrative areas, towns) matching a search query, each with an id that can be resolved to the full place.

• Action
  List addresses by postcode

  Returns every address registered at a postcode (UK, Ireland, Netherlands or Singapore).

• Action
  Validate Phone Number

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

• Action
  Validate UK Address

  Checks a freeform UK address against the UK address database and returns the closest matching standardised address with a confidence score and per-element match levels.

• Action
  Verify Email

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

• Action
  Verify US Address

  Verifies a US address against the USPS address dataset and returns the closest matching standardised address with confidence and match-level indicators.

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