# XQUERY missing fields? **URL:** \ **Category:** Q&A\ **Tags:** Sage-Intacct\ **Created:** [September 18, 2025, 6:28am UTC](https://community.velixo.com/t/xquery-missing-fields/120 "2025-09-18T06:28:26Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Ben\_Perry](https://community.velixo.com/letter_avatar_proxy/v4/letter/b/7ab992/32.png) [@Ben\_Perry](https://community.velixo.com/u/Ben_Perry)\ **Post date:** [September 18, 2025, 6:28am UTC](https://community.velixo.com/t/xquery-missing-fields/120/1 "2025-09-18T06:28:26Z")
Howdy, I’m starting to look at using the SI.XQUERY function, but struggling to get the fields that I can access via SI.QUERY. In this particular case I’m looking at the PROJECT object which is now “projects/project” according to the [XML-to-REST object map](https://developer.sage.com/intacct/docs/developer-portal/getting-started/xml-rest-object-map/#project-and-resource-management). Comparing the output of SI.OBJECTIONDEFINITION to SI.XOBJECTDEFINITION there is a massive discrepancy in the number of fields: SI.OBJECTIONDEFINITION = 139 fields SI.XOBJECTDEFINITION = 35 fields. I was hoping to query various dimension values eg Department, Division/Class, Location, but none of those fields are available? Looking at the REST API I can see [/objects/projects/project/](https://developer.sage.com/intacct/docs/openapi/pa/projects.project/tag/Projects/#tag/Projects/operation/get-projects-project-key) has most of the missing fields. How can I access these via Velixo? Thanks Ben ---
**Author:** ![Ben\_Perry](https://community.velixo.com/letter_avatar_proxy/v4/letter/b/7ab992/32.png) [@Ben\_Perry](https://community.velixo.com/u/Ben_Perry)\ **Post date:** [September 18, 2025, 10:53am UTC](https://community.velixo.com/t/xquery-missing-fields/120/2 "2025-09-18T10:53:14Z")
Can’t edit my post, but meant to say SI.OBJECTDEFINITION not SI.OBJECTIONDEFINITION. ---
**Author:** ![Zilvinas\_Bucys](https://community.velixo.com/letter_avatar_proxy/v4/letter/z/cdc98d/32.png) [@Zilvinas\_Bucys](https://community.velixo.com/u/Zilvinas_Bucys)\ **Post date:** [September 19, 2025, 11:26am UTC](https://community.velixo.com/t/xquery-missing-fields/120/3 "2025-09-19T11:26:28Z")
Hi Ben, The Sage Intacct REST API is still being actively developed, and at the time we built **SI.XQUERY** , certain functionality—specifically joined fields—was not yet available. This is why the output of **SI.OBJECTDEFINITION** and **SI.XOBJECTDEFINITION** differs, and why joined fields such as **Department** , **Division/Class** , and **Location** are not currently supported in **SI.XOBJECTDEFINITION** and **SI.XQUERY**. Since then, Sage Intacct REST API has evolved and added support for joined fields, and we are planning to update our functions accordingly. Until then, we recommend using **SI.QUERY** whenever joined fields are required. ---
**Author:** ![Ben\_Perry](https://community.velixo.com/letter_avatar_proxy/v4/letter/b/7ab992/32.png) [@Ben\_Perry](https://community.velixo.com/u/Ben_Perry)\ **Post date:** [September 23, 2025, 9:34pm UTC](https://community.velixo.com/t/xquery-missing-fields/120/4 "2025-09-23T21:34:16Z")
Thanks Zilvinas. Do you have any ETA on the updated functions? Do you need beta testers 🙂 Ben ---
**Author:** ![Zilvinas\_Bucys](https://community.velixo.com/letter_avatar_proxy/v4/letter/z/cdc98d/32.png) [@Zilvinas\_Bucys](https://community.velixo.com/u/Zilvinas_Bucys)\ **Post date:** [September 24, 2025, 2:38pm UTC](https://community.velixo.com/t/xquery-missing-fields/120/5 "2025-09-24T14:38:44Z")
Hi Ben, We don’t have a firm schedule yet, but this is expected to be on our roadmap before the end of the year. Regarding beta testing, we sincerely appreciate your enthusiasm, and we’ll ensure you are among the first to receive access to the update once it’s available. ---
**Author:** ![Harry](https://community.velixo.com/user_avatar/community.velixo.com/harry/32/21_2.png) [@Harry](https://community.velixo.com/u/Harry)\ **Post date:** [September 24, 2025, 9:47pm UTC](https://community.velixo.com/t/xquery-missing-fields/120/6 "2025-09-24T21:47:00Z")
Ben - We don’t have a firm schedule yet, but this is expected to be on our roadmap before the end of the year. Regarding beta testing, we sincerely appreciate your enthusiasm, and we’ll work to ensure you are among the first to receive access to the update once it’s available.