XQUERY missing fields?

Q&A
1

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.

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/ has most of the missing fields.

How can I access these via Velixo?

Thanks

Ben

2

Can’t edit my post, but meant to say SI.OBJECTDEFINITION not SI.OBJECTIONDEFINITION.

3

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.

4

Thanks Zilvinas.

Do you have any ETA on the updated functions?

Do you need beta testers :slight_smile:

Ben

5

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.

6

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.