Connect PostgreSQL to Unleashed Software

Both apps 24PostgreSQL 10Unleashed Software 14

• 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
  Add customer
• Action
  Add product

  Adds a new product

• Action
  Add purchase order
• Action
  Add sales order
• Action
  Add stock adjustment

  Creates a stock adjustment in Unleashed for a warehouse, setting new quantities and values for one or more products.

• Action
  Get stock adjustment

  Returns one Unleashed stock adjustment by its GUID, with its number, warehouse, reason, status and adjusted product lines.

• Action
  List customers

  Lists customers in Unleashed, optionally filtered by code, name, email, type, currency and more. Returns the first page (up to 200 customers).

• Action
  List products

  Lists products in your Unleashed account, optionally filtered by code, description, barcode, brand, group, customer or modified date.

• Action
  List purchase orders

  Lists purchase orders in Unleashed, optionally filtered by status, dates, supplier, warehouse or order number.

• Action
  List sales invoices

  Lists sales invoices in Unleashed, optionally filtered by customer, dates, status, invoice or order number, and payment status.

• Action
  List sales orders

  Lists a page of sales orders, newest-modified first, optionally filtered by customer, status, warehouse or date range.

• Action
  List suppliers

  Lists suppliers in the Unleashed account, optionally filtered by supplier code, contact email or modified date.

• Action
  Update product

  Updates an existing product by GUID. Only the fields you fill in are changed; every other field keeps its current value.

• Action
  Update sales order

  Updates an existing sales order in Unleashed. Only the fields you fill in are changed; everything else on the order keeps its current value.

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