Connect PostgreSQL and Repsly

Both apps 29PostgreSQL 10Repsly 19

• 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 Audit With Items

  Triggers when a new retail audit is submitted in Repsly, returning the audit with its client, representative and audited items.

• Trigger
  New client note

  Triggers when a representative adds a new note to a client in Repsly.

• Trigger
  New Client With Details

  Triggers when a new client is added in Repsly, returning the client's code, name, address, contact details, territory and assigned representative.

• Trigger
  New Form With Details

  Triggers when a representative submits a new form in Repsly, returning the form with its client, representative and answers.

• Trigger
  New Order

  Triggers when a new order or other sales document is created in Repsly, returning the document with its client, representative, status and line items.

• Trigger
  New photo

  Triggers when a new photo is taken in Repsly, returning the photo URL, note, client and representative.

• Trigger
  New Visit Start

  Triggers when a representative starts a new client visit in Repsly, returning the visit's client, representative, start time and location.

• Trigger
  New Workday Start

  Triggers when a representative starts a new workday in Repsly, returning the workday's start time, mileage and representative.

• Action
  Add account

  Creates or updates a place account in Repsly by its unique code.

• Action
  Add pricelist

  Adds a product with its price to an existing Repsly pricelist (or updates it), via an asynchronous import job.

• Action
  Add schedule

  Creates or updates a visit schedule in Repsly for a client and representative.

• Action
  Add user

  Creates a user in Repsly, or updates the existing user with the same code.

• Action
  Create Client

  Creates a client in Repsly, or updates it when the code already exists. Repsly processes the import in the background and returns the import job ID.

• Action
  Create Product

  Creates a product in Repsly, or updates it when the code already exists. Repsly processes the import in the background and returns the import job ID.

• Action
  Get client

  Returns a single client (place) from Repsly by its client code, including address, contact, territory, representatives and custom attributes.

• Action
  Get import job status

  Returns the status of a Repsly import job, including counts of inserted, updated and invalid rows plus any warnings and errors.

• Action
  List pricelists

  Returns all pricelists in your Repsly account, with their name, default flag and active status.

• Action
  List products

  Returns the products in your Repsly account, with their codes, names, prices, barcodes, packaging and custom attributes.

• Action
  Update sales document status

  Changes the status of a Repsly sales document, such as a purchase order, to another valid status for its document type.

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