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.
0 Votes
5 Comments
Sorted by
H
Harry Lewisposted
22 days ago
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.
0 Votes
Z
Zilvinas Bucysposted
23 days ago
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.
1 Votes
B
Ben Perryposted
23 days ago
Thanks Zilvinas.
Do you have any ETA on the updated functions?
Do you need beta testers :)
Ben
0 Votes
Z
Zilvinas Bucysposted
28 days ago
Answer
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.
0 Votes
B
Ben Perryposted
29 days ago
Can't edit my post, but meant to say SI.OBJECTDEFINITION not SI.OBJECTIONDEFINITION.
0 Votes
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/<key> has most of the missing fields.
How can I access these via Velixo?
Thanks
Ben
0 Votes
Zilvinas Bucys posted 28 days ago Best Answer
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.
0 Votes
5 Comments
Harry Lewis posted 22 days ago
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.
0 Votes
Zilvinas Bucys posted 23 days ago
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.
1 Votes
Ben Perry posted 23 days ago
Thanks Zilvinas.
Do you have any ETA on the updated functions?
Do you need beta testers :)
Ben
0 Votes
Zilvinas Bucys posted 28 days ago Answer
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.
0 Votes
Ben Perry posted 29 days ago
Can't edit my post, but meant to say SI.OBJECTDEFINITION not SI.OBJECTIONDEFINITION.
0 Votes
Login or Sign up to post a comment