PostgreSQL + Xero

Create or update Xero contacts from new PostgreSQL rows

Maintain your contact list effortlessly with this handy workflow. Whenever a new row is added in PostgreSQL, it prompts an immediate creation or update of a contact in Xero. This automation not only saves time but also ensures that your contact list in Xero stays current and accurate with the data in your PostgreSQL database. Make your database maintenance faster and more efficient with this seamless process.

When this happens...
New Row
Triggered when you add a new row.
TriggerScheduled
automatically do this!
Create/Update Contact
Triggers when you add a new contact.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

What does this mean?

- Table/ViewRequired
Trigger
Scheduled
Try It
- QueryRequired
Trigger
Scheduled
Try It
- Table/ViewRequired
- Primary KeyRequired
- Order ByRequired
- Trigger Column
Trigger
Scheduled
Try It
- TableRequired
- ID ColumnRequired
Action
Write
- QueryRequired
Action
Search

- OrganizationRequired
- Status
Trigger
Scheduled
Try It
- OrganizationRequired
- Status
- Type
Trigger
Scheduled
Try It

- OrganizationRequired
- Purchase Order Status
Trigger
Scheduled
Try It
- OrganizationRequired
Trigger
Scheduled
Try It
- OrganizationRequired
Trigger
Scheduled
Try It
- OrganizationRequired
- InvoiceRequired
Action
Write
- OrganizationRequired
- From AccountRequired
- To AccountRequired
- AmountRequired
- Date
Action
Write
- OrganizationRequired
- ContactRequired
- Date
- Expiry
- Quote Number
- Reference
- Theme
- Title
- Summary
- Currency
- Amounts Are
- Terms
Action
Write
- OrganizationRequired
- Invoice NumberRequired
Action
Write
- OrganizationRequired
- Contact NameRequired
- Email Address
- Status
- Date
- Due Date
- Currency
- Url
- Attachment
- Branding Theme
- Reference
- Line Items Type
- Item Code
- Description
- QuantityRequired
- Unit Price
- Account
- Tax Rate
- Tracking
Action
Write
- OrganizationRequired
- Document Type
- Document ID or NumberRequired
- Paid ToRequired
- Date
- Currency Rate
- AmountRequired
- Reference
Action
Write
- OrganizationRequired
- Contact (supplier)Required
- Date
- Delivery Date
- Order Number
- Reference
- Theme
- Currency
- Tax Type
- Delivery Address
- Attention
- Telephone
- Delivery Instructions
- Attachments
- Purchase Order Status
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- OrganizationRequired
- Search ByRequired
Action
Search

- Table/ViewRequired
- Order By
- Dedupe Key
Trigger
Scheduled
Try It
New Table
Triggered when you add a new table.
Trigger
Scheduled
Try It
- TableRequired
Action
Write
- TableRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- OrganizationRequired
Trigger
Scheduled
Try It
- OrganizationRequired
Trigger
Scheduled
Try It
- OrganizationRequired
- Payment Type
Trigger
Scheduled
Try It
- OrganizationRequired
- Quote Status
Trigger
Scheduled
Try It
- OrganizationRequired
- Status
Trigger
Scheduled
Try It
- OrganizationRequired
- Status
Trigger
Scheduled
Try It
- OrganizationRequired
- Transaction TypeRequired
- ContactRequired
- Bank AccountRequired
- Date
Action
Write
- OrganizationRequired
- Contact NameRequired
- Account Number
- Primary Person - First Name
- Primary Person - Last Name
- Primary Person - Email
- Phone - Country Code
- Phone - Area Code
- Phone Number
- Fax - Country Code
- Fax - Area Code
- Fax - Number
- Mobile - Country Code
- Mobile - Area Code
- Mobile - Number
- Direct Dial - Country Code
- Direct Dial - Area Code
- Direct Dial - Number
- Address Type Of
- Address - Attention
- Address - Line 1
- Address - Line 2
- Address - City/Town
- Address - State/Region
- Address - Postal/Zip Code
- Address - Country
- Tax Number
- Bank Account Number
- Groups
Action
Write
- OrganizationRequired
- TypeRequired
- ContactRequired
- Date
Action
Write
- OrganizationRequired
- Mark Item as a Sales Item?
- Mark Item as a Purchase Item?
- Item Name
- Item CodeRequired
Action
Write
- OrganizationRequired
- Status
- Date
- Due Date
- Currency
- Url
- Attachment
- Branding Theme
- Number
- Reference
- Sent To Contact
- Line Items Type
- Item Code
- Description
- QuantityRequired
- Unit Price
- Discount %
- Discount Amount
- Account
- Tax Rate
- Tracking
Action
Write
- OrganizationRequired
- ContactRequired
- Project NameRequired
- Deadline for the project
- Project Estimate
Action
Write
- OrganizationRequired
- ContactRequired
- StatusRequired
- Currency
- Branding Theme
- Reference
- Mark as approved for sending?
- Email a copy to Sender?
- Include PDF
- Line Amount Types
Action
Write
- OrganizationRequired
- Search ByRequired
Action
Search
- OrganizationRequired
- Search ByRequired
- Contact NameRequired
- Account Number
- Primary Person - First Name
- Primary Person - Last Name
- Primary Person - Email
- Phone - Country Code
- Phone - Area Code
- Phone Number
- Fax - Country Code
- Fax - Area Code
- Fax - Number
- Mobile - Country Code
- Mobile - Area Code
- Mobile - Number
- Direct Dial - Country Code
- Direct Dial - Area Code
- Direct Dial - Number
- Address Type Of
- Address - Attention
- Address - Line 1
- Address - Line 2
- Address - City/Town
- Address - State/Region
- Address - Postal/Zip Code
- Address - Country
- Tax Number
- Bank Account Number
- Groups
Action
Search or write

About PostgreSQL

PostgreSQL is a powerful, open-source database engine with a uniquely advanced query optimizer and dozens of built in features, making it an easy choice for production databases.

Learn more Help

Related categories

Databases

Similar apps

MySQL

Databases

SQL Server

Databases

Amazon Relational Database Services (RDS)

Amazon, Databases

About Xero

Xero is an accounting app that lets you track businesses expenses and accounting with intuitive mobile apps and web interfaces for point-of-sale, ecommerce, time-tracking, and more.

Learn more Help

Related categories

Accounting

Similar apps

QuickBooks Online

Accounting

FreeAgent

Accounting

Wave

Accounting

PRODUCTS

CAPABILITIES

By team

PostgreSQL + Xero

Create or update Xero contacts from new PostgreSQL rows

New Column

New Row (Custom Query)

QueryRequired

New or Updated Row

Table/ViewRequired

Primary KeyRequired

Order ByRequired

Trigger Column

Update Row

TableRequired

ID ColumnRequired

Find Row via Custom Query

QueryRequired

New Bill

OrganizationRequired

Status

New Credit Note

OrganizationRequired

Status

Type

New Purchase Order

OrganizationRequired

Purchase Order Status

New Expense Claim Receipt

OrganizationRequired

New or Updated Contact

OrganizationRequired

Add Items to Existing Sales Invoice

OrganizationRequired

InvoiceRequired

Create Bank Transfer

OrganizationRequired

From AccountRequired

To AccountRequired

AmountRequired

Date

Create New Quote Draft

OrganizationRequired

ContactRequired

Date

Expiry

Quote Number

Reference

Theme

Title

Summary

Currency

Amounts Are

Terms

Send Sales Invoice by Email

OrganizationRequired

Invoice NumberRequired

Create Bill

OrganizationRequired

Contact NameRequired

Email Address

Status

Date

Due Date

Currency

Url

Attachment

Branding Theme

Reference

Line Items Type

Item Code

Description

QuantityRequired

Unit Price

Account

Tax Rate

Tracking

Create Payment

OrganizationRequired

Document Type