Aimsio integration guide

Verified

How to connect Aimsio to WEXTL and use its 2 triggers and 48 actions in your workflows. About Aimsio: Manage job orders, field tickets, employees, timecards, invoices and billable items in Aimsio.

2 triggers
31 searches
17 actions
Polling
Auth: API key

AI-assisted documentation20 min read

This documentation is compiled from our integration source code, internal specs for Aimsio, its official API documentation and anonymized requests logs we collect from our support team[2].

Open Aimsio on WEXTL →

Requirements

Get your Aimsio credentials

EnvironmentselectRequired
Production (portal) is your live environment; Sandbox is the test environment used before live deployment.[1]
UsernametextRequired
Your username. An existing Admin user works, but Aimsio recommends a separate integration user. The user must have API permissions enabled - contact Aimsio support/integration team to enable them.[1]
PasswordpasswordRequired
The password for the user above.[1]

Connect Aimsio in WEXTL

Log in to your WEXTL account, add the Aimsio node module to your workflow, and click Create new credential.
Optional: In the Credential name field, enter a name for the credential.
Enter the authentication credentials you copied from your Aimsio account, or follow the on-screen instructions to create the credential.
If prompted, authenticate your account and confirm access.
If you want to make changes to your credential in the future, follow the steps in Manage credentials →

Aimsio triggers and actions on WEXTL

The list below is a reference of every Aimsio node module the integration supports. You will be able to pick any of them on the workflow canvas while building automations.

Expand any Aimsio node module below to see exactly what it takes in, what it returns, and what connection it needs.

Watch Contacts

Trigger

Output fields[3]
Field	Type
Dtype	text
ID	number
Updated At	date

Watch Invoices

Trigger

Output fields[3]
Field	Type
Dtype	text
ID	number
Updated At	date

Get Billable Item

Action

Input fields[3]
Field	Type
Billable Item GUIDRequired	choice

Output fields[3]
Field	Type
Billable Item GUID	text
Billable Item Code	text
Billable Item Name	text
Billable Item Type Uname	text
Billable Item Type Name	text
Billable Item Is Trade	boolean
Billable Item Is Equipment	boolean
Billable Item Category	text
Billable Item Description	text
Billable Item Status	text
Billable Item Default Rate	number
Billable Item Default Rate Type	text
Billable Item Default Rate Type Uname	text
Billable Item Default Rate2	number
Billable Item Default Rate Type2	text
Billable Item Default Rate Type Uname2	text
Billable Item Default Rate3	number
Billable Item Default Rate Type3	text
Billable Item Default Rate Type Uname3	text
Billable Item Default Cost	number

12other output fields

Get Binary File

Action

Input fields[3]
Field	Type
Binary File IDRequired	text

Output fields[3]
Field	Type
File Data	text

Get Company

Action

Input fields[3]
Field	Type
Company GUIDRequired	choice

Output fields[3]
Field	Type
Company GUID	text
Company Code	text
Company Name	text
Company Symbol	text
Company Type Name	text
Company Type Uname	text
Company Address	text
Company Email	email
Company Phone	text
Company Notes	text
Company Is Deleted	boolean
Company Form Data	object
Form Data Form Type Uname	text
Form Data GUID	text
Form Data Field Data List	array

Get Contact

Action

Input fields[3]
Field	Type
Contact IDRequired	choice

Output fields[3]
Field	Type
Contact ID	number
Contact GUID	text
Contact First Name	text
Contact Last Name	text
Contact Email	email
Contact Phone	text
Contact Tag	text
Contact Position GUID	text
Contact Position Name	text
Contact Company GUID	text
Contact Company Name	text
Contact Is Deleted	boolean

Get Current Timecard

Action

Input fields[3]
Field	Type
Current Timecard GUIDRequired	choice

Output fields[3]
Field	Type
Time Card GUID	text
Time Card Record Date	number
Time Card Employee GUID	text
Time Card Employee Code	text
Time Card Employment Type	text
Time Card Work Trade Code	text
Time Card Pay Type	text
Time Card Union Code	text
Time Card Time Zone	text
Time Card Description	text
Time Card Employee Regular Hours	text
Time Card Rate	text
Time Card R T Amount	text
Time Card Employee Over Time Hours	text
Time Card Rate Over Time	text
Time Card O T Amount	text
Time Card Employee Double Time Hours	text
Time Card Rate Double Time	text
Time Card D T Amount	number
Time Card Employee Travel Time Hours	number

29other output fields

Get Employee

Action

Input fields[3]
Field	Type
Employee GUIDRequired	choice

Output fields[3]
Field	Type
Employee GUID	text
Employee Code	text
Employment Type	text
Employee Status Uname	text
Employee First Name	text
Employee Last Name	text
Employee Nick Name	text
Employee Trade GUID	text
Employee Trade Code	text
Employment Hire Date	number
Employment Termination Date	number
Employment Re Hire Date	number
Employee Address	text
Employee Phone	text
Employee Email	email
Employee Notes	text
Employee Linked User GUID	text
Employee Linked User Name	text
Employee Payroll Type Name	text
Employee Payroll Union Name	text

6other output fields

Get Equipment

Action

Input fields[3]
Field	Type
Equipment GUIDRequired	choice

Output fields[3]
Field	Type
Asset GUID	text
Asset Code	text
Asset Category Code	text
Asset Serial Number	text
Asset Model	text
Asset Operator Employee Code	text
Asset Status Uname	text
Asset Created At	date
Asset Updated At	date
Asset Notes	text
Asset Location	text
Asset Activation Date	number
Asset Termination Date	number
Asset Is Deleted	boolean
Asset Form Data	object
Form Data Form Type Uname	text
Form Data GUID	text
Form Data Field Data List	array

Get Field Ticket

Action

Input fields[3]
Field	Type
Field Ticket GUIDRequired	choice

Get Form Data

Action

Input fields[3]
Field	Type
Form Data GUIDRequired	choice

Output fields[3]
Field	Type
Form Data GUID	text
Form Data Form Type Uname	text
Form Data Internal Status	text
Form Data Field Data List	array
Field Data Field Type Uname	text
Field Data Field Type Label	text
Field Data Field Type Data Type	text
Field Data String Value	text
Field Data Decimal Value	number
Field Data Date Value	date
Field Data Boolean Value	boolean
Field Data Reference Value	text
Field Data File Extension	text
Field Data File Mime Type	text
Form Type GUID	text
Form Data Form No	text
Form Data Created At	date
Form Data Updated At	date
Form Data Reviewed At	date
Form Data Review Ok	boolean
Form Data Review Comment	text
Form Data Time Zone Str	text
Form Data Time Zone Offset	number
Form Data Status	text
Form Data Sub Status	text
Form Data Location Lat	number
Form Data Location Long	number
Form Data Form Status	text
Form Data Is Deleted	boolean
Form Data Deletion Reason	text

8other output fields

Get Form Data PDF

Action

Input fields[3]
Field	Type
Form Data GUIDRequired	choice

Output fields[3]
Field	Type
Form Data	text

Get Invoice

Action

Input fields[3]
Field	Type
Invoice IDRequired	choice

Output fields[3]
Field	Type
Invoice ID	number
Invoice Number	text
Invoice Date	number
Invoice Type Uname	text
Invoice Client GUID	text
Invoice Client Code	text
Invoice Client Name	text
Invoice Billed To	text
Invoice Status	text
Invoice Custom Status	text
Invoice Private Note	text
Invoice Retainage Percent	text
Invoice Retainage Amount	text
Invoice Discount Percent	text
Invoice Discount Amount	text
Invoice Is Percent Based Discount	boolean
Invoice Tax	text
Invoice Sub Total	text
Invoice Total	text
Invoice Job Order GUID	text

9other output fields

Get Job Order

Action

Input fields[3]
Field	Type
Job Order GUIDRequired	choice

Output fields[3]
Field	Type
Job ID	number
Job GUID	text
Job Number	text
Job Name	text
Job Description	text
Job Status	text
Job Type Uname	text
Job Client Code	text
Job Client GUID	text
Job Client Name	text
Job Price Book Name	text
Job Price Book GUID	text
Job Start Date	number
Job End Date	number
Job Created At	date
Job Updated At	date
Job Show In Dispatching	boolean
Job Assignee Employee Number	text
Job Assignee Full Name	text
Job Assignee User Name	text

12other output fields

Get Location

Action

Input fields[3]
Field	Type
Location GUIDRequired	choice

Output fields[3]
Field	Type
Location GUID	text
Location Code	text
Location Name	text
Location Is Deleted	boolean
Location Type Name	text
Location Type Uname	text
Location Form Data	object
Form Data Form Type Uname	text
Form Data GUID	text
Form Data Field Data List	array

Get Non-recurring Billable Item

Action

Input fields[3]
Field	Type
NRB GUIDRequired	choice

Output fields[3]
Field	Type
NRB GUID	text
NRB External ID	text
NRB Origin Reference	text
NRB Job Order Number	text
NRB W B S GUID	text
NRB W B S Shared Identifier	text
NRB P O Number	text
NRB Purchase Order GUID	text
NRB Purchase Order Cost Item Origin Reference	text
NRB Invoice Number	text
NRB Invoice Date	number
NRB Name	text
NRB Type Uname	text
NRB Type Name	text
NRB Document Type	text
NRB Account Type	text
NRB Is Billable	boolean
NRB Vendor GUID	text
NRB Vendor Code	text
NRB Rate	number

20other output fields

Get NRB PDF

Action

Input fields[3]
Field	Type
NRB GUIDRequired	choice

Output fields[3]
Field	Type
File Data	text

Get Pricebook

Action

Input fields[3]
Field	Type
Pricebook GUIDRequired	choice

Output fields[3]
Field	Type
Price Book GUID	text
Price Book Name	text
Price Book Is Deleted	boolean
Price Book Created At	date
Price Book Created By User Name	text
Price Book Created By Full Name	text
Price Book Updated At	date
Price Book Last Modified By User Name	text
Price Book Last Modified By Full Name	text
Price Book Origin Reference	text
Price Item List	array
Price Item Billable Item GUID	text
Price Item Billable Item Name	text
Price Item Billable Item Code	text
Price Item Rate	number
Price Item Rate Type Uname	text
Price Item Rate Type	text
Price Item Rate2	number
Price Item Rate Type Uname2	text
Price Item Rate Type2	text
Price Item Rate3	number

List Billable Items

Input fields[3]
Field	Type
Limit	number

Output fields[3]
Field	Type
Dtype	text
GUID	text
Updated At	date

List Companies

Input fields[3]
Field	Type
Limit	number

Output fields[3]
Field	Type
Dtype	text
GUID	text
Updated At	date

List Contacts

Input fields[3]
Field	Type
Company GUID	choice
Company Code	text
Limit	number

Output fields[3]
Field	Type
Dtype	text
ID	number
Updated At	date

List Current Timecards

Input fields[3]
Field	Type
Limit	number

Output fields[3]
Field	Type
Dtype	text
GUID	text
Updated At	date

List Employees

Input fields[3]
Field	Type
Limit	number

Output fields[3]
Field	Type
Dtype	text
GUID	text
Updated At	date

List Equipment

Input fields[3]
Field	Type
Limit	number

Output fields[3]
Field	Type
Dtype	text
GUID	text
Updated At	date

List Field Tickets

Input fields[3]
Field	Type
Limit	number

Output fields[3]
Field	Type
Dtype	text
GUID	text
Updated At	date

List Form Data

Input fields[3]
Field	Type
Form Type Uname	text
Limit	number

Output fields[3]
Field	Type
Dtype	text
GUID	text
Updated At	date

List Invoices

Input fields[3]
Field	Type
Limit	number

Output fields[3]
Field	Type
Dtype	text
ID	number
Updated At	date

List Job Orders

Input fields[3]
Field	Type
Limit	number

Output fields[3]
Field	Type
Dtype	text
GUID	text
Updated At	date

List Locations

Input fields[3]
Field	Type
Limit	number

Output fields[3]
Field	Type
Dtype	text
GUID	text
Updated At	date

List Non-recurring Billable Items

Input fields[3]
Field	Type
Limit	number

Output fields[3]
Field	Type
Dtype	text
GUID	text
Updated At	date

List Payroll Period Timecards

Input fields[3]
Field	Type
Payroll Period GUID	choice
Limit	number

Output fields[3]
Field	Type
Time Card GUID	text
Time Card Record Date	number
Time Card Employee GUID	text
Time Card Employee Code	text
Time Card Employment Type	text
Time Card Work Trade Code	text
Time Card Pay Type	text
Time Card Union Code	text
Time Card Time Zone	text
Time Card Description	text
Time Card Employee Regular Hours	text
Time Card Rate	text
Time Card R T Amount	text
Time Card Employee Over Time Hours	text
Time Card Rate Over Time	text
Time Card O T Amount	text
Time Card Employee Double Time Hours	text
Time Card Rate Double Time	text
Time Card D T Amount	number
Time Card Employee Travel Time Hours	number

29other output fields

List Payroll Periods

Input fields[3]
Field	Type
Status	choice
Limit	number

Output fields[3]
Field	Type
Payroll Period GUID	text
Payroll Period Name	text
Payroll Period Amount	text
Payroll Period Pay Type Name	text
Payroll Period Status	text

List Pricebooks

Input fields[3]
Field	Type
Limit	number

Output fields[3]
Field	Type
Dtype	text
GUID	text
Updated At	date

Create/Update Billable Items

Action

Input fields[3]
Field	Type
Billable Item ListRequired	array
Billable Item GUID	text
Billable Item CodeRequired	text
Billable Item NameRequired	text
Billable Item Type Uname	choice
Billable Item Type NameRequired	text
Billable Item Is TradeRequired	boolean
Billable Item Is EquipmentRequired	boolean
Billable Item Category	text
Billable Item Description	text
Billable Item Status	text

Output fields[3]
Field	Type
Dtype	text
ID	number
GUID	text
Import Configuration	text
Number Of Entities Created	number
Number Of Entities Edited	number
Number Of Entities Edited With Errors	number
Number Of Entities Not Imported Due To Errors	number
Extra	text
Notices	array
Updated At	number
Import Result Type	text
Number Of Entities Imported	number

Create/Update Companies

Action

Input fields[3]
Field	Type
Company ListRequired	array
Company GUID	text
Company CodeRequired	text
Company NameRequired	text
Company Symbol	text
Company Type NameRequired	text
Company Type Uname	choice
Company Address	text
Company Email	email
Company Phone	text
Company Notes	text

Output fields[3]
Field	Type
Dtype	text
ID	number
GUID	text
Import Configuration	text
Number Of Entities Created	number
Number Of Entities Edited	number
Number Of Entities Edited With Errors	number
Number Of Entities Not Imported Due To Errors	number
Extra	text
Notices	array
Updated At	number
Import Result Type	text
Number Of Entities Imported	number

Create/Update Contacts

Action

Input fields[3]
Field	Type
Contact ListRequired	array
Contact First NameRequired	text
Contact Last NameRequired	text
Contact Email	email
Contact Phone	text
Contact Tag	text
Contact Position NameRequired	choice
Contact Company NameRequired	text
Contact Is Deleted	boolean

Output fields[3]
Field	Type
Dtype	text
ID	number
GUID	text
Import Configuration	text
Number Of Entities Created	number
Number Of Entities Edited	number
Number Of Entities Edited With Errors	number
Number Of Entities Not Imported Due To Errors	number
Extra	text
Notices	array
Updated At	number
Import Result Type	text
Number Of Entities Imported	number

Create/Update Employees

Action

Input fields[3]
Field	Type
Employee ListRequired	array
Employee GUID	text
Employee CodeRequired	text
Employment TypeRequired	choice
Employee Status UnameRequired	choice
Employee First NameRequired	text
Employee Last NameRequired	text
Employee Nick Name	text
Employee Trade CodeRequired	text
Employment Hire Date	number
Employment Termination Date	number

Output fields[3]
Field	Type
Dtype	text
ID	number
GUID	text
Import Configuration	text
Number Of Entities Created	number
Number Of Entities Edited	number
Number Of Entities Edited With Errors	number
Number Of Entities Not Imported Due To Errors	number
Extra	text
Notices	array
Updated At	number
Import Result Type	text
Number Of Entities Imported	number

Create/Update Equipment

Action

Input fields[3]
Field	Type
Asset ListRequired	array
Asset GUID	text
Asset CodeRequired	text
Asset Category CodeRequired	text
Asset Serial Number	text
Asset Model	text
Asset Operator Employee Code	text
Asset Status UnameRequired	choice
Asset Notes	text
Asset Location	text
Asset Activation Date	number

Output fields[3]
Field	Type
Dtype	text
ID	number
GUID	text
Import Configuration	text
Number Of Entities Created	number
Number Of Entities Edited	number
Number Of Entities Edited With Errors	number
Number Of Entities Not Imported Due To Errors	number
Extra	text
Notices	array
Updated At	number
Import Result Type	text
Number Of Entities Imported	number

Create/Update Job Orders

Action

Input fields[3]
Field	Type
Job ListRequired	array
Job GUID	text
Job NumberRequired	text
Job NameRequired	text
Job Description	text
Job StatusRequired	choice
Job Client CodeRequired	text
Job Price Book NameRequired	text
Job Start DateRequired	number
Job End Date	number
Job Show In Dispatching	boolean

Output fields[3]
Field	Type
Dtype	text
ID	number
GUID	text
Import Configuration	text
Number Of Entities Created	number
Number Of Entities Edited	number
Number Of Entities Edited With Errors	number
Number Of Entities Not Imported Due To Errors	number
Extra	text
Notices	array
Updated At	number
Import Result Type	text
Number Of Entities Imported	number

Create/Update Locations

Action

Input fields[3]
Field	Type
Location ListRequired	array
Location GUID	text
Location CodeRequired	text
Location NameRequired	text
Location Is Deleted	boolean
Location Type Name	text
Location Type UnameRequired	text

Output fields[3]
Field	Type
Dtype	text
ID	number
GUID	text
Import Configuration	text
Number Of Entities Created	number
Number Of Entities Edited	number
Number Of Entities Edited With Errors	number
Number Of Entities Not Imported Due To Errors	number
Extra	text
Notices	array
Updated At	number
Import Result Type	text
Number Of Entities Imported	number

Create/Update Non-recurring Billable Items

Action

Input fields[3]
Field	Type
NRB ListRequired	array
NRB GUID	text
NRB External IDRequired	text
NRB Origin Reference	text
NRB Job Order NumberRequired	text
NRB W B S Shared Identifier	text
NRB P O Number	text
NRB Invoice Number	text
NRB Invoice Date	number
NRB NameRequired	text
NRB Type Uname	text

Output fields[3]
Field	Type
Dtype	text
ID	number
GUID	text
Import Configuration	text
Number Of Entities Created	number
Number Of Entities Edited	number
Number Of Entities Edited With Errors	number
Number Of Entities Not Imported Due To Errors	number
Extra	text
Notices	array
Updated At	number
Import Result Type	text
Number Of Entities Imported	number

Create/Update Pricebooks

Action

Input fields[3]
Field	Type
Price Book ListRequired	array
Price Book GUID	text
Price Book NameRequired	text
Price Book ActionRequired	choice
Price Book Is Deleted	boolean
Price Book Origin Reference	text
Price Item ListRequired	array

Output fields[3]
Field	Type
Dtype	text
ID	number
GUID	text
Import Configuration	text
Number Of Entities Created	number
Number Of Entities Edited	number
Number Of Entities Edited With Errors	number
Number Of Entities Not Imported Due To Errors	number
Extra	text
Notices	array
Updated At	number
Import Result Type	text
Number Of Entities Imported	number

Create/Update Users

Action

Input fields[3]
Field	Type
User ListRequired	array
User GUID	text
User NameRequired	text
User First Name	text
User Last Name	text
User Role Names	array
User Role Guids	array
User Phone	text
User Email	email
User Is ActiveRequired	boolean
User Areas	array

Output fields[3]
Field	Type
Dtype	text
ID	number
GUID	text
Import Configuration	text
Number Of Entities Created	number
Number Of Entities Edited	number
Number Of Entities Edited With Errors	number
Number Of Entities Not Imported Due To Errors	number
Extra	text
Notices	array
Updated At	number
Import Result Type	text
Number Of Entities Imported	number

Delete Form Data

Action

Input fields[3]
Field	Type
Form Data GUIDRequired	choice
Deletion Reason	text

Make an API Call

universal

Input fields[3]
Field	Type
URLRequired	text
MethodRequired	choice
Headers	array
Header	object
Query String	array
Parameter	object
Body	text

Output fields[3]
Field	Type
Body	text
Headers	object
Status code	number

Reopen Form Data

Action

Input fields[3]
Field	Type
Form Data GUIDRequired	choice
Reopen ReasonRequired	text

Restore Form Data

Action

Input fields[3]
Field	Type
Form Data GUIDRequired	choice

Update Form Data

Action

Input fields[3]
Field	Type
Form DataRequired	array
Form Data GUIDRequired	text
Custom Field Data List	array

Update Invoices

Action

Input fields[3]
Field	Type
InvoicesRequired	array
Invoice ID	number
Invoice Number	text
Invoice Custom Status	text
Custom Field Data List	array

Update Payroll Period Status

Action

Input fields[3]
Field	Type
Payroll Period ListRequired	array
Payroll Period GUID	text
Payroll Period Status	choice

Output fields[3]
Field	Type
Dtype	text
ID	number
GUID	text
Import Configuration	text
Number Of Entities Created	number
Number Of Entities Edited	number
Number Of Entities Edited With Errors	number
Number Of Entities Not Imported Due To Errors	number
Extra	text
Notices	array
Updated At	number
Import Result Type	text
Number Of Entities Imported	number

Templates

Look for Aimsio templates in the WEXTL template library.

Browse templates →

Other project management integrations on WEXTL

More Project Management integrations →

References

WEXTL® Aimsio Source Code connector implementation.
Our users use cases and automations.
Official API Documentation for Aimsio.
WEXTL® visual workflow builder data.

Last updated: Oct 31, 2026 22:48

How we write our apps documentation

How we compile these docs — sources, AI's role, and how we verify.