Connect Plutio and PostgreSQL

Both apps 31Plutio 21PostgreSQL 10

• Trigger
  New Block

  Triggers when a new block (content, line items, signature area) is added to a contract, proposal or invoice.

• Trigger
  New Task

  Triggers when a new task is created in your Plutio workspace.

• Trigger
  New Task Board

  Triggers when a new task board is created in your Plutio workspace.

• Trigger
  New Task Group

  Triggers when a new task group is created in Plutio.

• Action
  Create a Task

  Creates a task on a project's task board in Plutio and returns the new task.

• Action
  Create Block

  Creates a block of content or line items on a Plutio contract, proposal or invoice and returns the created block.

• Action
  Create Invoice

  Creates a draft invoice in Plutio for a client person or company. Line items are added separately.

• Action
  Create Person

  Creates a new person (client, lead or team member) in your Plutio workspace and returns the created record.

• Action
  Create Project

  Creates a new project in your Plutio workspace, optionally linked to a client. Plutio gives it a default status and a first task board.

• Action
  Create Task Board

  Creates a new task board in Plutio, optionally inside a project.

• Action
  Create Task Group

  Creates a new task group (a column or section) on a Plutio task board and returns the created group.

• Action
  Delete Block

  Permanently deletes a block (a piece of content or line items) from a Plutio contract, proposal or invoice.

• Action
  Delete Invoice

  Permanently deletes an invoice from your Plutio workspace.

• Action
  Find Person

  Finds people in your Plutio workspace by email, name, role or an advanced query, and returns the first match plus all matches.

• Action
  Get Task

  Returns a single task by its id, including its custom field values.

• Action
  Move a Task

  Moves a task to a different task group, task board or project.

• Action
  Retrieve Block/Blocks

  Returns one block by its ID, or all the blocks (text, line items) that make up a contract, proposal or invoice.

• Action
  Retrieve Person/People

  Returns one person by id, or a list of people in your Plutio workspace filtered by role, status or an advanced query.

• Action
  Update a Task

  Updates an existing task in Plutio. Only the fields you fill in are changed; everything else stays the same.

• Action
  Update Invoice

  Updates an existing invoice's name, currency, due date, client or custom field values. Fields left blank stay as they are.

• Action
  Update Person

  Updates an existing person (client, lead or team member) in Plutio. Only the fields you fill in are changed.

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

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