Connect PostgreSQL to Foxentry

Both apps 18PostgreSQL 10Foxentry 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
  Get Company Information

  Returns public registry information about a company in Czech Republic, Hungary, Poland or Slovakia by its registration number.

• Action
  Get Location Data

  Returns full details of an address (street, number, city, ZIP, region, GPS and IDs) by its Foxentry internal ID or official external ID.

• Action
  List Addresses Around GPS

  Returns the addresses found within a radius around a GPS point, optionally falling back to the nearest addresses when none are in range.

• Action
  Validate a Company

  Validates company details (name, registration, tax or VAT number) against Czech, Hungarian, Polish and Slovak registries, returning whether they are valid plus any corrected data and suggestions.

• Action
  Validate a Location

  Validates an address (street, house number, city, ZIP or full address), corrects typos and returns the validation result with the corrected address and suggestions.

• Action
  Validate a Name

  Checks whether a first name, surname or full name is valid and real (Czech and Slovak names), returning corrections, suggestions and, in the full data scope, gender, vocative forms and name days.

• Action
  Validate an Email

  Checks whether an email address is valid and deliverable, and returns corrections, suggestions and flags such as freemail or disposable address.

• Action
  Validate a Phone Number

  Checks whether a phone number is valid and, with extended validation, whether it is connected, returning the formatted number, carrier and suggested corrections.

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