Request

Response

    Expense Items
    GET

    v1/containers/{containerId}/expenses/{expenseId}/items

    Retrieves the expense items and subitems of the specified expenses for a given project.

    Note that this endpoint is compatible with both BIM 360 and Forma projects.

    Resource Information

    Method and URI
    GET
    https://developer.api.autodesk.com/cost/v1/containers/:containerId/expenses/:expenseId/items
    Authentication Context
    User context required
    Required OAuth Scopes
    data:read
    Data Format
    JSON

    Request

    Headers

    Authorization*
    string
    Must be Bearer <token>, where <token> is a three-legged access token obtained via an Authorization Code flow or a Secure Service Account (SSA) flow.

    The SSA flow is designed for headless server-to-server operations. While it functions like a two-legged flow (no user interaction), it is classified as three-legged because it preserves user context.

    region
    string
    Specifies the region where the project data resides.

    By default, the request is routed automatically. However, specifying the region can improve performance by avoiding lookup overhead.

    Possible values: country or region codes such as US or EMEA. For the full list of supported regions, see the Forma Regions page.

    To verify your project’s region, refer to the Working with BIM 360 Services in Different Regions section on the API Basics page.

    * Required

    Request

    URI Parameters

    containerId
    string: UUID
    The ID of the project (the container ID is the same as the project ID). To obtain the project ID, see GET projects.
    expenseId
    array: string
    A list of the object IDs of the expenses whose items you want to retrieve, separated by commas. You can obtain these IDs from the response to the POST expenses or GET expenses endpoint.

    Request

    Query String Parameters

    include
    array: string
    A list of the nested expense resources to include in the response with the expense items. For example, include=budget returns the IDs of budgets related to the expense items, include=attributes will return custom attributes which represents the “properties” in the response.

    Possible values: budget, contract, attributes, externalRelationship.

    filter[id]
    array: string: uuid
    Returns only the items that are identified by the provided list of item IDs. Separate multiple IDs with commas. For example, filter[id]=id1,id2.
    filter[lastModifiedSince]
    string
    Returns only items that were modified since the specified date and time, in ISO 8601 format. For example, filter[lastModifiedSince]=2020-03-01T13:00:00Z.
    limit
    int
    The maximum number of records returned per page. Default: 100. A page may contain fewer records than the limit if there are fewer matching items or if it is the last page of results.
    offset
    int
    The number of records to skip before returning results. Used together with limit to paginate through results, where offset specifies the starting point and limit specifies the number of records to return.
    sort
    string
    Sorts expense item results by an expense-item-level field in ascending or descending order. Supported fields: id, contractId, budgetId, number, name, description, scope, quantity, unit, unitPrice, amount, note, exchangeRate, originalExchangeRate, createdAt, updatedAt, integrationState, integrationStateChangedAt, integrationStateChangedBy, externalSystem, externalId, lastSyncTime, externalMessage. Multiple comma separated attributes are supported. Each attribute can be sorted in asc (default) or desc order. For example, sort=name,createdAt desc.
    filter[externalSystem]
    string
    Filters results to only include items from the specified external ERP system. Use this to identify or search for items synchronized from a particular integrated system. For example, filter[externalSystem]=Sage300.

    Max length: 255

    filter[externalId]
    array: string
    Filters results to only include items identified by the specified external ERP system IDs. Use this ID to track or correlate data with an integrated ERP system. Separate multiple IDs with commas. For example, filter[externalId]=id1,id2.
    filter[segmentCode]
    array: string
    Filters results to budgets or budget-linked entities (cost items, expense items, payment items) matching specified segment codes. Format each filter as <segment name>:<segment code>.

    Segment names are resolved at query time to the project’s budget code structure. Matching is case-insensitive on segment name and exact on segment code; partial matches are not supported.

    For partner integrations, use stable segment names agreed in the integration template (for example, CSI, Division, Cost Type).

    Multiple codes for the same segment are combined with OR. For example, filter[segmentCode]=CSI:03,04 matches CSI code 03 or 04. Multiple segment groups are combined with AND. For example, filter[segmentCode]=CSI:03,04,Division:10 matches (CSI is 03 or 04) and Division is 10.

    When segment names or codes contain a colon, double-URL-encode them. For example, filter[segmentCode]=CSI:033000 or filter[segmentCode]=Cost%253ACenter:03%253A30%253A00.

    On budget-linked entities, matching budget IDs are resolved first and applied as an additional filter[budgetId].

    If the project has more than one segment with the same name, this filter fails. For example, filter[segmentCode]=CSI:001 fails when the project has two segments both named CSI.

    Response

    HTTP Status Code Summary

    200
    OK
    Success
    400
    Bad Request
    The parameters are invalid.
    401
    Unauthorized
    The provided bearer token is invalid.
    403
    Forbidden
    Forbidden. The user or service represented by the bearer token does not have permission to perform this operation.
    404
    Not Found
    The resource or endpoint cannot be found.
    409
    Conflict
    The request could not be completed due to a conflict with the current state of the resource.
    429
    Too Many Requests
    Rate limit exceeded. Retry your request after a few minutes.
    500
    Internal Server Error
    An unexpected error occurred on the server.
    503
    Service Unavailable
    Service unavailable.

    Response

    Body Structure (200)

    Expand all
    pagination
    object
    Contains pagination information when data is returned page by page.
    limit
    int
    The maximum number of records returned in the response.
    offset
    int
    The number of records skipped before returning the page of results.
    totalResults
    int
    The total number of records that matched the request criteria.
    nextUrl
    string
    The URL for the next request to retrieve the next page of results. Max length: 2000.

    Max length: 2000

    results
    array: object
    id
    string: UUID
    The unique identifier of the expense item.
    budgetId
    string,null
    The ID of the budget to which the expense item belongs.
    contractId
    string: UUID
    The ID of the contract to which the expense item belongs.
    number
    string
    The sequence number for the expense item.
    name
    string
    The name of the expense item.

    Max length: 1024

    description
    string
    The detailed description of the expense item.

    Max length: 2048

    note
    string
    The note attached to the expense item, if returned. The note consists of Tiptap formatted rich text. For more information, see https://tiptap.dev.
    scope
    string,null
    The applicable scope of the expense item. Possible values: full, partial.
    quantity
    number
    The number of units of the expense item.
    unitPrice
    number,string,null
    The price per unit of the expense item.
    unit
    string
    The expense item’s unit of measure.
    amount
    number,string,null
    The total price of the expense item.
    aggregateBy
    string,null
    The aggregate type of the expense item. Possible values: workCompleted, workCompletedQty, materialsOnSite
    exchangeRate
    number,string,null
    The exchange rate that applies to the expense item’s base currency price. For example, provide the value 0.7455 for a foreign currency that’s worth 0.7455 of your base currency. Default:1. It’s also 1 if multi-currency is not enabled.
    originalExchangeRate
    number,string,null
    The original exchange rate from the expense item’s associated contract. Default:1. It’s also 1 if multi-currency is not enabled.
    realizedGainOrLoss
    number,string,null
    The gain or loss on the expense item, calculated as follows:amount * exchangeRate / originalExchangeRate - amount
    customColumns
    object
    Not relevant
    budget
    object
    Not relevant
    contract
    object
    Not relevant
    externalId
    string
    The identifier assigned to an item in its original external ERP system. Use this ID to track and look up data within the integrated system. Note that this value comes from the item’s ID in the external system.

    Max length: 255

    externalSystem
    string
    The name of the external ERP system integrated with Cost Management. Use this name to identify and search for data within the integrated system.

    Max length: 255

    externalMessage
    string
    A message generated by the external ERP system that explains the sync status of the integration. For example, common values include success or fail to indicate the result of the integration operation.

    Max length: 255

    lastSyncTime
    datetime: ISO 8601
    The date and time when the item was last synchronized with the external ERP system. This value is updated by the external system and is in ISO 8601 format.
    createdAt
    datetime: ISO 8601
    The date and time that the item was created, in ISO 8601 format.
    updatedAt
    datetime: ISO 8601
    The date and time that the item was last updated, in ISO 8601 format.
    integrationState
    string,null
    The state of the item during the integration with the external ERP system (such as SignNow). An item can be a budget, contract, main contract, main contract item, cost item, expense, expense item, change order, or schedule of value. For more details, see Integrate with External System tutorial. Possible values:

    locked: the item is currently locked within the ERP system, preventing modifications until unlocked. To unlock and modify the item, use the relevant PATCH endpoint to set integrationState to null. For example, for a budget, call PATCH budgets. For a contract, call PATCH contracts. For more details, see the Help documentation.

    integrated: the item has been successfully added to the ERP system.

    failed: the item encountered an error during the integration process and was not successfully added to the ERP system. For example, if a user tries to integrate contracts from an ERP system and the updates fail, the integrationState can be set to failed. Retry the sync process or analyze the issue if it continues to fail.

    null: The item has not been integrated with the ERP system. This is default value.

    For more information regarding integrations within the Cost Management system, see Integrations in Cost Management.

    integrationStateChangedAt
    string,null
    The date and time that the item’s integration status was last changed.
    integrationStateChangedBy
    string,null
    The user who last changed the integration status. This is the ID of a user managed by the BIM 360/Forma Admin.

    Example

    Success

    Request

    curl -v 'https://developer.api.autodesk.com/cost/v1/containers/e94b9bc8-1775-4d76-9b1d-c613e120ccff/expenses/:expenseId/items?filter[lastModifiedSince]=2020-03-01T13:00:00Z&limit=100&sort=name,createdAt desc' \
      -H 'Authorization: Bearer AuIPTf4KYLTYGVnOHQ0cuolwCW2a'
    

    Response

    {
      "pagination": {
        "limit": 20,
        "offset": 0,
        "totalResults": 1,
        "nextUrl": ""
      },
      "results": [
        {
          "id": "48934441-e392-49d7-bf58-8dea43d413ae",
          "budgetId": "48934441-e392-49d7-bf58-8dea43d413ae",
          "contractId": "48934441-e392-49d7-bf58-8dea43d413ae",
          "number": 1,
          "name": "Site Management Staff",
          "description": "Site Management Staff",
          "note": "Site Management Staff",
          "scope": "full",
          "quantity": "The quantity of the expense item. For example 1.",
          "unitPrice": "1000.0000",
          "unit": "ls",
          "amount": "1000.0000",
          "aggregateBy": "workCompleted",
          "exchangeRate": "1.0000",
          "originalExchangeRate": "1.0000",
          "realizedGainOrLoss": "1000.0000",
          "customColumns": {
            "budget": {},
            "contract": {}
          },
          "externalId": "10010-99-AB",
          "externalSystem": "Sage300",
          "externalMessage": "Success.",
          "lastSyncTime": "2019-09-05T01:00:12.989Z",
          "createdAt": "2019-01-06T01:24:22.678Z",
          "updatedAt": "2019-09-05T01:00:12.989Z",
          "integrationState": "locked",
          "integrationStateChangedAt": "2019-09-05T01:00:12.989Z",
          "integrationStateChangedBy": "CED9LVTLHNXV"
        }
      ]
    }
    
    Show More