Skip to main content

AiM Asset Management Source

AiM logo

The AiM Asset Management Source connector imports mapped place hierarchy data, assets, and work orders from AiM into the Mapped graph. It supports:

  • Place synchronization from configured place mappings
  • Asset synchronization using configurable asset-group-to-exact-type mappings
  • Scheduled work order polling
  • On-demand historical work order backfill (date range or specific proposal numbers)

Use Cases​

  • Sync AiM buildings, floors, and spaces into Mapped for place-aware operations.
  • Bring AiM asset inventory into Mapped as Thing entities with mapped exact types.
  • Keep maintenance records current by polling recently updated AiM work orders.
  • Backfill historical or specific proposal-based work orders for reporting and analysis.

Configuration​

Auth Requirements​

The connector authenticates directly to AiM with username/password and a base URL.

FieldRequiredDescription
UsernameYesAiM API username
PasswordYesAiM API password
Base URLYesAiM API base URL for your environment

Select Buildings​

After authentication, the connector loads buildings, floors, and spaces from AiM and presents a place mapping table.

FieldRequiredUniqueNotes
building.siteIdYesNoRequired to provision building hierarchy
building.nameYesNoBuilding display name
building.addressYesNoBuilding address
floor.nameYesNoFloor name (read-only from source data)
floor.levelNoNoOptional floor level
space.nameYesNoSpace name (read-only from source data)
space.refIdYesYesSpace identifier used for location linkage
space.codeNoNoOptional space code

Saving this section triggers Location Sync, which will attach AiM Source identifiers to the relevant entities via ExternalIdentity.

Asset Mappings​

The connector discovers AiM assetGroup values and lets you map each to a Mapped exact type for Thing.

  • Saved mappings are stored under the connector config and used by Asset Sync and work-order-related asset linking.
  • If no explicit mapping is selected, the asset defaults to THING.
  • Saving this section triggers Asset Sync, which will import the assets from AiM Source.

Poll​

Disabled by default, toggle to Enabled to poll for AiM Work Orders every 15 minutes, within the scope of selected Buildings.

Historical Data Backfill​

Use this section to backfill historical Work Orders from AiM. You can backfill by date range, which will poll Work Orders by their date last created or update, or by specific AiM Source proposal numbers. Backfills a maximum of 50,000 entities.

Mapped Concepts​

AiM DataMapped EntityNotes
Building mapping rowBuildingIncludes identities with AiM building URN when building.refId exists
Floor mapping rowFloorNested under building via hasPart; includes identity when floor.refId exists
Space mapping rowSpaceNested under floor via hasPart; includes AiM space URN identity
Asset recordThingCreated from asset sync; exact type from Asset Mappings, fallback THING; linked by location (isLocationOf)
Work order recordWorkOrderIncludes status/type/priority/date fields and AiM work order identity
Contact email/namePerson (+ Email)Work order reporter relationship via isReportedBy
Shop value from phase dataPeopleGroupLinked to work order via hasAssignedGroup
Phase hours and costsWorkOrderCostActual labor hours, material, tool and total cost, plus planned cost, summed over all phases of the work order. See Work Order Costs.

Work Order Costs​

AiM records booked hours and costs on each phase of a work order, not on the work order itself. The connector adds them up across all phases of the work order and attaches the totals as an actual and a planned cost. They are updated every time the work order is polled or backfilled, so open work orders show running totals.

AiM Phase FieldCostValue
Total hoursActualLabor, in hours
Total materialActualMaterial, in USD
Total equipmentActualTool, in USD
Total labor + material + equipment + otherActualTotal, in USD
Budget (or the work order budget when no phase has one)PlannedTotal, in USD
  • The labor value is hours, not dollars. Labor dollars are included in the total.
  • AiM has no tool cost, so equipment cost is reported as the tool cost.
  • The planned cost is the budget: the sum of the phase budgets, or the work order's own budget when the phases have none.
  • AiM has no estimated hours or cost, so no estimated cost is sent.
  • Values that are empty or 0 are left out, so a work order with nothing booked has no cost.
  • Hours booked on a phase after the work order was last changed, such as a timecard posted after the work order closed, are still picked up: the poll also re-syncs work orders whose phases changed.

Poll​

Enable or disable the Work Order poll on the Advanced Settings tab. The poll will regularly scan the AiM system for new or updated work orders submitted for the locations configured in the Select Buildings section.

Sample Code​

You can query Work Orders by the connector's ID and identify related assets and places.

{
workOrders(filter: {connectedDataSourceId: {eq: "CONDUfL5cDFx4u7VVE8QMDvsH"}}) {
id
name
dateCreated
relatesTo {
... on Thing {
id
name
exactType
}
... on Building {
id
name
exactType
}
}
}
}

Graph Diagram​

AiM Source Graph shape. Building hasPart Floor. Floor hasPart Space. Space isLocationOf Thing. WorkOrder relatesTo Building. WorkOrder relatesTo Thing. WorkOrder isReportedBy Person. WorkOrder hasAssignedGroup PeopleGroup.