Connect Avaza to Neon Postgres

Both apps 101Avaza 72Neon Postgres 29

• Trigger
  Company Updated

  Triggers when a company is updated in Avaza, delivering a snapshot of the company.

• Trigger
  Contact Updated

  Triggers when a contact is updated in Avaza.

• Trigger
  Estimate Deleted

  Triggers when an estimate (quote) is deleted in Avaza.

• Trigger
  Estimate Updated

  Triggers when an estimate (quote) is updated in Avaza.

• Trigger
  Expense Deleted

  Triggers when an expense is deleted in Avaza.

• Trigger
  Expense Updated

  Triggers when an expense is updated in Avaza.

• Trigger
  Invoice Sent

  Triggers when an invoice is sent (or marked as sent) in Avaza.

• Trigger
  Invoice Update

  Triggers when an invoice is updated in Avaza.

• Trigger
  New Bill Created

  Triggers when a new supplier bill is created in Avaza.

• Trigger
  New Company

  Triggers when a new company is created in Avaza.

• Trigger
  New Contact

  Triggers when a new contact is created in Avaza.

• Trigger
  New Estimate Created

  Triggers when a new estimate (quote) is created in Avaza.

• Trigger
  New Expense Created

  Triggers when a new expense is created in Avaza.

• Trigger
  New Invoice Created

  Triggers when a new invoice is created in Avaza.

• Trigger
  New Project

  Triggers when a new project is created in Avaza.

• Trigger
  New Schedule Series Created

  Triggers when a schedule series (a project booking or leave) is created in Avaza.

• Trigger
  New Task Created

  Triggers when a new task is created in Avaza.

• Trigger
  New Timesheet Entry

  Triggers when a timesheet entry is created in Avaza.

• Trigger
  Project Updated

  Triggers when a project is updated in Avaza.

• Trigger
  Schedule Series Deleted

  Triggers when a schedule booking or leave series is deleted in Avaza.

• Trigger
  Schedule Series Updated

  Triggers when a schedule series (a project booking or leave) is updated in Avaza.

• Trigger
  Task Deleted

  Triggers when a task is deleted in Avaza.

• Trigger
  Task Updated

  Triggers when a task is updated in Avaza.

• Trigger
  Timesheet Entry Deleted

  Triggers when a timesheet entry is deleted in Avaza.

• Trigger
  Timesheet Entry Updated

  Triggers when a timesheet entry is updated in Avaza.

• Action
  Create Bill

  Creates a new draft supplier bill in Avaza, optionally creating the supplier company and contact if no match is found.

• Action
  Create Bill Payment

  Records a payment made to a supplier, optionally allocating it against one or more bills.

• Action
  Create Company

  Creates a new customer company in Avaza with billing address, contact details and custom field values.

• Action
  Create Contact

  Creates a new contact in Avaza, optionally linked to an existing or new company.

• Action
  Create Estimate / Quote

  Creates a new draft estimate (quote) for a customer, optionally creating the customer company and contact if no match is found.

• Action
  Create Expense

  Creates a new expense entry in Avaza for a user, with a date, amount and expense category, optionally linked to a customer, project or task.

• Action
  Create Invoice

  Creates a new draft invoice for a customer company, with line items. Can create the customer company and contact if no matching company is found.

• Action
  Create Invoice Payment

  Records a customer payment in Avaza, optionally allocating it against one or more invoices.

• Action
  Create Project

  Creates a new project in Avaza under an existing customer company, or under a new company created from the name you give.

• Action
  Create Schedule Booking

  Creates a project work schedule booking for a user over a date range, with hours per day or a total duration.

• Action
  Create Section

  Creates a new section (task group) within an Avaza project.

• Action
  Create Task

  Creates a new task in an Avaza project section, optionally assigning users, dates, priority, effort, tags and custom field values.

• Action
  Create Timesheet Entry

  Creates a timesheet entry in an Avaza project, or starts a timer when no duration is given.

• Action
  Delete Estimate

  Deletes an estimate (quote) in Avaza. Estimates converted to an invoice cannot be deleted.

• Action
  Delete Schedule or Leave Series

  Deletes a schedule booking or leave series, along with all of its daily schedule assignments.

• Action
  Delete Section

  Deletes a section (task group) from a project. Sections that still contain tasks cannot be deleted.

• Action
  Delete Task

  Deletes a task, along with its subtasks and comments, from an Avaza project.

• Action
  Delete Timesheet

  Deletes a timesheet entry in Avaza by its Timesheet Entry ID.

• Action
  Get Bill

  Returns a single supplier bill by its ID, including line items, supplier and recipient address details, amounts, status and web links.

• Action
  Get Contact

  Returns a single external contact by its Contact ID, including company, contact details, roles and custom field values.

• Action
  Get Estimate

  Returns a single estimate (quote) by its ID, including line items, status, amounts, issuer/recipient details and web links.

• Action
  Get Project

  Returns a project's full details, including its sections, team members, tags and custom field values.

• Action
  Lookup Company

  Finds companies in Avaza whose name matches the search text and returns their IDs and names.

• Action
  Lookup Expense Category

  Finds an expense category in your Avaza account by its name and returns its id and unit price settings.

• Action
  Lookup Project

  Finds active projects by title, project code, or customer company and returns their ids, codes and titles.

• Action
  Lookup Project Timesheet Category

  Looks up the timesheet categories assigned to a project, optionally matching one by name.

• Action
  Lookup Task

  Returns a task by its ID, including project, section, assignees, dates, status, priority, tags, time tracking and custom field values.

• Action
  Lookup User

  Finds Avaza users (team members and customer contacts) by email address, with optional filters for role, tag and company. Returns the first match and the full list of matches.

• Action
  Mark Invoice as Sent

  Flags a draft invoice as Sent without emailing it to the customer.

• Action
  Reterive Task Comments

  Returns the comments and discussion messages on an Avaza task, including replies, attachments and system messages.

• Action
  Search Expenses

  Returns expense entries matching a search on merchant or category name, with optional filters for date range, user, customer, project, chargeable/invoiced status and approval status.

• Action
  Search Invoice

  Searches invoices by status, customer company, issue date, due date or last-updated date, and returns the matching invoices with their line items.

• Action
  Search Project

  Searches projects by title, company, category, owner, status, billing or budget type, tags and dates, and returns the matching projects.

• Action
  Search Task

  Searches tasks, filtering by project, section parent, status, priority, due date range, assigned user, completion state and last-updated date.

• Action
  Search Timesheets

  Searches timesheet entries, filtered by date range, user, project, customer, task, category, billable/invoiced and approval status.

• Action
  Stop Timer

  Stops the running timer on an existing timesheet entry, adding the elapsed time to its duration.

• Action
  Update Company

  Updates an existing Avaza company. Only the fields named in Fields To Update are changed.

• Action
  Update Contact

  Updates an existing customer contact in Avaza — name, email, phone, mobile, position title, time zone, portal roles and custom field values. Only the fields you fill in are changed.

• Action
  Update Estimate

  Updates an existing draft or sent estimate (quote) in Avaza, changing only the fields you list. Accepted, converted or void estimates cannot be updated.

• Action
  Update Expense

  Updates an existing Avaza expense entry. Only the fields you list in Fields To Update are changed.

• Action
  Update Invoice

  Updates an existing draft invoice in Avaza. Only the fields you list in Fields To Update are changed.

• Action
  Update Project

  Updates an existing Avaza project. Only the fields named in Fields To Update are changed.

• Action
  Update Project Member

  Updates a project member's rates, budget, or permissions on an Avaza project. Only the fields named in Fields To Update are changed.

• Action
  Update Project Timesheet Category

  Updates a timesheet category's settings on a project, such as billable status, hourly rate, cost rate and budget hours.

• Action
  Update Schedule Booking

  Updates an existing project work schedule booking in Avaza, such as its user, project, dates or hours.

• Action
  Update Task

  Updates an existing Avaza task. Only the fields you fill in are changed; blank fields keep their current values.

• Action
  Update Timesheet Entry

  Updates an existing timesheet entry in Avaza, changing only the fields you list as fields to update.

• Action
  Add branch

  Create a new branch in a Neon project.

• Action
  Add compute endpoint

  Creates a compute endpoint (a Neon compute instance) on a branch of a Neon project. A branch can have one read-write endpoint and multiple read-only endpoints.

• Action
  Add database

  Creates a new Postgres database in a Neon project branch, owned by an existing role.

• Action
  Add project

  Creates a new Neon Postgres project with its default branch, database, role and compute, and returns the project along with its connection details.

• Action
  Add role

  Creates a Postgres role in the specified Neon project branch. Connections to the branch's active compute are dropped while the change applies.

• Action
  Delete branch

  Delete a branch by project_id and branch_id.

• Action
  Delete compute endpoint

  Deletes a compute endpoint from a Neon project. Existing connections to the compute are dropped. If the compute does not exist or was already deleted, the step still succeeds with an empty result.

• Action
  Delete database

  Deletes the specified database from a branch of a Neon project.

• Action
  Delete project

  Deletes a Neon project and all its branches, compute endpoints, databases and roles. The project can be recovered within 7 days.

• Action
  Delete role

  Deletes the specified Postgres role from a Neon branch.

• Action
  Get branch

  Retrieves details of a branch in a Neon project.

• Action
  Get compute endpoint

  Retrieve details about a compute endpoint.

• Action
  Get connection URI

  Retrieve a Postgres connection URI for a database/role/branch/endpoint combination.

• Action
  Get database

  Retrieves details of a database on a Neon project branch.

• Action
  Get project

  Retrieves the details of a Neon project, including its settings, compute configuration, history retention, owner and current usage metrics.

• Action
  Get role

  Retrieves details about a Postgres role (user) on a Neon branch.

• Action
  Get role password

  Retrieves the password for a Postgres role on a Neon branch.

• Action
  List branches

  Retrieve a list of branches for a Neon project.

• Action
  List compute endpoints

  Lists the compute endpoints (Neon compute instances) in a project.

• Action
  List databases

  Lists the databases on a branch of a Neon project.

• Action
  List operations

  Lists the operations (asynchronous actions such as starting a compute or creating a branch) Neon performed on a project. Operations older than 6 months may no longer be available.

• Action
  List projects

  Lists the Neon projects accessible to the connected account, optionally filtered by name/ID or organization.

• Action
  List roles

  Lists the Postgres roles on a Neon project branch.

• Action
  Start compute endpoint

  Start (resume) a suspended compute endpoint.

• Action
  Suspend compute endpoint

  Suspends the specified Neon compute endpoint (scales it to zero).

• Action
  Update branch

  Update a branch's properties (e.g. name, protected) by project_id and branch_id.

• Action
  Update compute endpoint

  Updates an existing compute endpoint in a Neon project by ID.

• Action
  Update database

  Updates the name or owner of a database on a Neon project branch.

• Action
  Update project

  Update settings for a Neon project by project_id.

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