Aimsio and Mosaic Integration
Build project management workflows between Aimsio and Mosaic on a visual canvas. Set up data fields sync between apps once and let data flow when events come automatically. Integration will work without code and your team will see the workflow inside WEXTL® builder.
- 3-day trial
- Cancel anytime
- Up to 10 minutes quick set up
- GDPR
- Data Encryption
- 2FA
- Local Data Region
Learn about Aimsio and Mosaic
Detailed info you need to know about Aimsio and Mosaic integrations in WEXTL. Explore which modules apps support and how you connect them.
How to connect Aimsio to Mosaic
Set up your Aimsio and Mosaic integration in 3 simple steps[2]. No coding required. Up to 10 minutes setup.
STEP 1
Connect Aimsio and Mosaic
Save credentials in WEXTL once. We store them encrypted and reuse the authorization across every workflow[3]. No coding or API skills required.
STEP 2
Build a workflow
Paste selected Aimsio and Mosaic nodes onto the canvas[4], or describe what you want and WEXTL wires the flow together with AI Builder.
STEP 3
Map your data
Choose which fields need to sync between Aimsio and Mosaic. Use filters or a JS custom code step in between. Everything is on the canvas.
How does the integration between Aimsio and Mosaic work in WEXTL?
WEXTL exposes actions and triggers for Aimsio and Mosaic that help you connect apps and automate repetitive tasks[1]. A trigger is an event that happens, and an action is a step that performs when the event has occurred.
Aimsio triggersMosaic actions
Aimsio modules
- Create or Update Billable Items Imports a Billable Item List into Aimsio, adding new items and editing ones that already exist. Items carry a Billable Item Name, Billable Item Category and Billable Item Default Rate. Output tallies Number Of Entities Created.
- Create or Update Companies Adds or edits companies in Aimsio. Give each one a Company Name, Company Email and Company Phone, and a Company Type Uname such as Vendor Company Type, all inside the Company List.
- Create or Update Contacts Saves contacts into Aimsio from a Contact List. Describe each with Contact First Name, Contact Last Name, Contact Email and Contact Phone, and set Contact Company Name to attach it to a company. Failures are counted separately as Number Of Entities Edited With Errors.
- Create or Update Employees Loads an Employee List, adding or editing staff. Each person can have an Employee First Name, Employee Last Name and Employee Trade Code. Employment Type and Employee Status Uname record how and whether they are employed.
- Create or Update Equipment Writes an Asset List so that pieces of equipment are added or edited in Aimsio. Each asset takes an Asset Code, Asset Serial Number, Asset Model and an Asset Status Uname of Active, Inactive or Repair And Maintenance.
- Create or Update Job Orders Submits jobs to Aimsio from a Job List. Each entry can set a Job Number, Job Name and Job Status, name its client with Job Client Code, and add work breakdown activities with WBS Activity Name.
- Create or Update Locations Syncs locations with Aimsio from a Location List. Use Location Code, Location Name and Location Type Uname to describe each place.
- Create or Update Non-recurring Billable Items Uploads an NRB List of one-off billable charges. Each can carry an NRB Name, NRB Rate, NRB Quantity and NRB Job Order Number, with NRB Vendor Code for the supplier and NRB Invoice Number once billed.
- Create or Update Pricebooks Stores a Price Book List together with the Price Item List inside each book. Use Price Book Action to add or update a book, or to replace it, and give each priced item a Price Item Rate.
- Create or Update Users Brings a User List into Aimsio. Each user takes a User Name, User First Name, User Last Name and User Email, plus User Role Names and User Areas. Turn on User Is Active to mark the account active.
- Delete Form Data Deletes one submitted form from Aimsio. Add a Deletion Reason to record why it was removed.
- Get a Billable Item Opens one billable item from Aimsio. The result includes Billable Item Code, Billable Item Name, Billable Item Type Name and its Billable Item Default Rate.
- Get a Binary File Downloads a stored file from Aimsio by its Binary File ID and returns the content as File Data.
- Get a Company Reads one company from Aimsio, including its Company Code, Company Address, Company Notes and Company Form Data.
- Get a Contact Looks up one person in Aimsio. Output has the Contact First Name, Contact Last Name and Contact Position Name, plus the Contact Company Name.
- Get a Current Timecard Reads a single open timecard, with Time Card Employee Regular Hours, Time Card Employee Over Time Hours and the Time Card Pay Type.
- Get a Field Ticket Looks up a single field ticket recorded in Aimsio, for use in later steps.
- Get a Form Data PDF Renders one submitted form as a PDF file, available afterwards as Form Data.
- Get a Job Order Fetches one job order. Output covers Job Name, Job Status, Job Client Name and Job Start Date, and lists the Job Crew Records and Job Equipment Records for the job.
- Get a Location Reads a single location from Aimsio, returning its Location Code, Location Name and Location Type Name.
- Get a Non-recurring Billable Item Opens one one-off charge, showing NRB Name, NRB Rate, NRB Quantity, NRB Vendor Code and whether NRB Is Billable.
- Get a Non-recurring Billable Item PDF Exports one non-recurring charge as a PDF, handed over as File Data.
- Get a Pricebook Reads one price book. Output has the Price Book Name and Price Book Origin Reference, along with every entry of the Price Item List.
- Get an Employee Returns one employee from Aimsio with their Employee Code, Employment Hire Date, Employee Address and Employee Payroll Type Name.
- Get an Invoice Reads an invoice from Aimsio with Invoice Number, Invoice Date, Invoice Client Name, Invoice Status, Invoice Sub Total and Invoice Total.
- Get Equipment Reads one equipment asset from Aimsio with its Asset Serial Number, Asset Model, Asset Location and Asset Activation Date.
- Get Form Data Reads one submitted form with its Form Data Status and Form Data Created By Full Name. Output also lists the Form Data Field Data List of answers and the Form Data Form Type Uname.
- List Billable Items Reads the billable items defined in Aimsio. Each record is tagged with its Dtype, GUID and Updated At. Set a Limit to fetch only part of the catalog.
- List Companies Retrieves every company stored in Aimsio. A record is identified by its GUID. Use Limit to stop the fetch at a chosen number of records.
- List Contacts Returns contacts from Aimsio. Narrow them to one company with Company GUID or Company Code, and trim the total with Limit. Each result comes with an ID.
- List Current Timecards Pulls the current timecards from Aimsio, identified by GUID. Use Limit to read only the first few.
- List Employees Gathers the employee roster from Aimsio, one record per person. Pass a smaller Limit to fetch fewer.
- List Equipment Lists the equipment assets Aimsio tracks, labelled by Dtype and GUID. Restrict the count with Limit.
- List Field Tickets Fetches field tickets recorded in Aimsio, each with a GUID and an Updated At timestamp. Use Limit to read a set number of tickets.
- List Form Data Finds submitted forms in Aimsio. Use Form Type Uname to search one form type only, and Limit to stop at a fixed count. A GUID identifies each match.
- List Invoices Reads invoices from Aimsio and returns an ID, Dtype and Updated At for every one. Adjust Limit to control how many are fetched.
- List Job Orders Collects the job orders in Aimsio. Enter a Limit to keep the list short, and read the GUID from each entry.
- List Locations Shows the locations configured in Aimsio, each keyed by a GUID. Use Limit to decide how many records you get.
- List Non-recurring Billable Items Returns the one-off billable charges in Aimsio, with GUID and Updated At on each. Use Limit when the account holds many and you want only some.
- List Payroll Periods Lists payroll periods with the Payroll Period Name, Payroll Period Amount and Payroll Period Pay Type Name of each. Use Status to see only periods in one processing state.
- List Pricebooks Loads the price books stored in Aimsio, telling them apart by GUID and Updated At. Cut the result short with Limit.
- List Timecards Retrieves timecards, each with its Time Card Employee Code, Time Card Record Date and hours. Use Payroll Period GUID to see only the cards of one payroll period, or set Limit for a fixed count.
- Make an API Call Makes an authorized free-form request to the Aimsio REST API with your saved credential.
- Reopen Form Data Sends a submitted form back to an open state again. Reopen Reason records why.
- Restore Form Data Brings a deleted form submission back into Aimsio.
- Update Form Data Writes custom field values into existing form data. Identify each form with Form Data GUID, then give every Custom Field Data Uname a Custom Field Data String Value or Custom Field Data Boolean Value.
- Update Invoices Edits invoices in bulk. Use Invoice ID to target each invoice, then change its Invoice Number or Invoice Custom Status, or set custom field values with Custom Field Data List.
- Update Payroll Period Status Moves payroll periods to a new status. Choose a Payroll Period GUID and a Payroll Period Status for each entry of the Payroll Period List. The result counts Number Of Entities Edited.
- Watch Contacts Runs on a polling schedule and emits each contact it finds, with its ID. Use Limit to bound a single poll.
- Watch Invoices At each scheduled check, reads the invoices Aimsio returns and emits each as a separate item with its Updated At. Set Limit to keep a single check small.
Mosaic modules
- Create a Client Registers a client in Mosaic under a Client Name. Add a Client Description to describe it, and API Request Metadata for custom key and value pairs.
- Create a Holiday Records a holiday running from a Start Date to an End Date. Use Holiday Name to name it, and set All Day or Daily Hours to say how many hours it covers.
- Create a Phase Adds a new phase under a project of a portfolio, labelled with a Phase Name. Add a Budget Status, Billing Type, Start Date, End Date or Estimated Hours, and nest it under another phase with Parent Phase ID.
- Create a Portfolio Opens a portfolio, the container for projects, with a Portfolio Name. Switch Is Private on to keep it private and add API Request Metadata for custom keys.
- Create a Project Sets up a project, titled with Project Title, in a portfolio. Optionally record the Client Name, Budget Status, Billing Type, Currency Code, Start Date, End Date and Total Fee.
- Create a Task Adds a task under a Task Name in a portfolio. Use Assignee Member IDs to give it people, Status for the stage it begins in, and the scheduled date fields to set when it runs.
- Create a Time Entry Logs time for a member on a Date, with Recorded Hours, Invoice Hours and a Standard Work Category ID. Add Billable, Cost Rate, Rate or Description for billing detail, and use Status to set where the entry stands in approval.
- Create a Timetracking Entry Records a time tracking entry with a Description for one member on a Date. Use Estimated Hours for the expected time and Standard Work Category ID to classify the work.
- Create an Employee Adds an employee record from an Email, First Name, Last Name and Employment Type. Pass Department IDs, Region Names and Office Names to place the employee in departments, regions and offices.
- Create an Invoice Raises an invoice for a portfolio over the Period Start to Period End range, as a Fixed Fee or Percentage Invoice Type. Add an Amount or Percentage for the value, and switch on Is Estimate to flag it as an estimate.
- Delete a Holiday Removes one holiday from your Mosaic calendar.
- Delete a Phase Deletes a project phase. Switch on Recursively Delete Sub-Phases to include its child phases.
- Delete a Portfolio Removes a portfolio. Turn on Hard Delete to destroy all projects and time entries under it.
- Delete a Project Removes a project within a portfolio. Turn on Force Destroy to delete the project and any time entered instead of archiving it.
- Delete a Task Deletes a task belonging to a project in your Mosaic portfolio.
- Delete a Time Tracking Entry Deletes one tracked-time record from Mosaic.
- Delete an Employee Deletes an employee record from your Mosaic account.
- Delete Time Entries Removes several logged time entries in one request, given their Time Entry IDs.
- Get a Portfolio Reads one portfolio together with its Color, Board modules, Column order and Custom fields.
- Get an Employee Fetches one employee, giving the Email, Employment type and archive status.
- List Clients Retrieves the clients in your Mosaic account, each with its Client name and Description. Add a Limit to hold the list to a set size.
- List Employees Returns employees with Employment type, Work groups, Regions and Offices. Turn on Include Archived Members to add archived people, and pass a Limit to stop early.
- List Holidays Finds holidays, optionally between a Start Date and an End Date, showing the Holiday type and Daily hours of each. Supply a Limit to shorten the result.
- List Invoices Shows invoices from one portfolio with their Invoice number, Invoice date and Amount. Turn on Estimates Only to see only estimates.
- List Phases Retrieves the phases of selected projects in a portfolio, along with budget numbers such as Estimated hours and Estimated cost. Apply a Limit for a shorter result.
- List Portfolios Gets portfolios with their Name and Color, plus flags like Is private and Is personal. Enter a Limit to trim the list.
- List Projects Finds projects within a portfolio. Narrow them by Budget Status, Is Archived, Archived After Date and Archived Before Date, restrict to Main Projects Only, or supply Project IDs Filter.
- List Tasks Returns tasks from one project. Use Assignee Member to see the work of one member, and Limit to set the list size.
- List Time Entries Searches logged time by Start Date and End Date, Member IDs, Client Names, Phase Names or Billable Only. Turn on Fetch All (ignore limit/offset) to retrieve every page.
- List Time Tracking Retrieves the time tracking entries for one Date. Use Member IDs to keep certain members, and set how many with Limit.
- Make an API Call Makes an authorized free-form request to the Mosaic REST API with your saved credential.
- Override Project Total Overrides the totals of a project with your own values. Set Budget Hours Override, Budget Cost Override or Fee Override for the totals you want to change.
- Search Phases Searches phases by Search Text. Narrow the matches through Is Budget, Archived After Date, Archived Before Date or Projects, and turn on Use All Projects to span every project.
- Update a Client Modifies a client. Rename it with Client Name, change the Client Description, or attach custom keys through API Request Metadata.
- Update a Holiday Edits a holiday. Rename it with Holiday Name, shift it through Start Date and End Date, and set its hours via All Day or Daily Hours.
- Update a Phase Adjusts a phase. Rename it through Phase Name, rework its budget using Budget Status or Estimated Hours, and reposition it via Parent Phase ID or Move After Phase ID.
- Update a Portfolio Changes a portfolio. Rename it with Portfolio Name, set privacy with Is Private, or move it into or out of the archive using Archive or Unarchive.
- Update a Project Changes a project. Edit the Project Title, Client Name and Description, adjust Budget Status and Total Fee, or reorder its phases with Phase Order IDs.
- Update a Task Changes a task. Edit its details with Task Name, Status and Note, add people with Assignee Member IDs, remove people with Unassignee Member IDs and move it with Position in Task List.
- Update a Task for a User Changes the Name, Completed At and scheduled dates for a user task. An Email address can be sent along.
- Update a Time Entry Edits logged time. Adjust the figures with Recorded Hours, Invoice Hours or Billable, and apply one update to several entries at once with Batch Time Entry IDs.
- Update a Time Tracking Entry Amends a time tracking entry. Use Description and Estimated Hours to change the content, and Standard Work Category ID to reclassify the work.
- Update an Employee Alters an employee record. Set First Name, Last Name and Email for identity, and Department IDs, Region Names, Office Names or Main Office ID for placement.
- Update an Invoice Changes the Invoice Type, Amount, Percentage, Invoice Number, Invoice Date or Notes of an invoice. Turn on Is Estimate to mark it as an estimate.
- Watch Clients Checks on a schedule for clients added since the last run and starts the workflow once for each. Use Limit to decide how many are handled per cycle.
- Watch Employees Triggers once per newly added employee found by a periodic check. Use Limit to hold a cycle to a set number.
- Watch Holidays Looks on a schedule for newly added holidays and emits each as a separate run. Pass a Limit to keep the cycle short.
- Watch Invoices Polls a portfolio for invoices created since the previous run. Set Limit to choose how many a cycle takes.
- Watch Phases Reviews phases at set intervals and fires for each new one. Apply Limit to keep a cycle small.
- Watch Portfolios Scans for newly created portfolios and triggers on each of them. Enter a Limit to cut a cycle short.
Explore alternative integrations
There are other apps[9] supported by WEXTL that can be paired with Aimsio and Mosaic integrations. Pick any from the list below if the current combination isn't the one you need.
Frequently asked questions
Common questions about connecting Aimsio and Mosaic.
References
List of sources used to gather information about the Aimsio and Mosaic integration.
- Aimsio and Mosaic integration source code, module specs and credentials implementation.
- Our Aimsio and Mosaic integration documentation, structured input and output parameters, scopes, and authentication methods.
- Official vendor API documentation for Aimsio and Mosaic, used to verify field meanings, authentication flows, and anything our own specs don't fully capture.
- WEXTL® visual workflow builder, anonymized data from our technical support team.
- Aimsio integration information
- Mosaic integration information
- WEXTL® Scheduling
- WEXTL® Pricing and Trial
- WEXTL® Apps Library
How we write our apps documentation
Explore how WEXTL® crafted Aimsio and Mosaic integration page documentation. Used sources, the role of AI, and how the team validates the result.

