About the API Functions in the API can be divided into two broad categories: Generic functions that can operate on multiple types of objects. For example, the<create>function can be used to add a new account in General Ledger, a new vendor in Accounts Payable, a new bill in Accounts Rece...
API Company and Console Users UsersUsers Get User Object Definition Query and List Users Query and List Users (Legacy) Get User Get User by ID Create User Update User Delete User User Permissions Get User Effective Permissions Get User Permission Object Definition Query and List User ...
Connect to and Query Sage Intacct in QlikView over ODBC Automated Continuous Sage Intacct Replication to Microsoft Access How to connect Amazon QuickSight to Sage Intacct Use the CData Software JDBC Driver for Sage Intacct in MicroStrategy Web ...
See query structures here: https://developer.intacct.com/web-services/queries/ Warning: Operators can only be used once in a given logical context. and_filter cannot accept multiple 'equalto' operators for example. This is an API limitation. # # Returns Data Structure of object to perform qu...
NetSuite also empowers developers to query and analyze data by issuing SQL statements via REST API with SuiteQL. This enables RESTful access to NetSuite datasets created with SuiteAnalytics tools. The Sage Intacct accounting platform also offers customization and integrations through open, XML-based ...
Using query Let’s take a closer look at the query that lists AP bills where the vendor name isRegal Services. <query>APBILL<filter><equalto><field>VENDORNAME</field><value>Regal Services</value></equalto></filter><field>RECORDNO</field><field>VENDORNAME</field></query> The type of...
<query> RATETABLE <filter> <equalto> <field>STATUS</field> <value>active</value> </equalto> </filter> <field>RATETABLEID</field> <field>NAME</field> <field>RECORDNO</field> </query>ParametersNameRequiredTypeDescription object Required...
Starting with the 2024 R2 release, users with appropriate permissions can create, edit, and delete Accounts Receivable payments in a draft state using the XML API or the Sage Intacct user interface. Draft payment functionality provides more control, flexibility, and accuracy when managing payments, ...
API Construction Change Requests Change RequestsChange Requests Get Change Request Object Definition Query and List Change Requests Query and List Change Requests (Legacy) Get Change Request Get Change Request by ID Create Change Request Update Change Request Delete Change Request Change Request Entries...
API Order Entry Order Entry Transactions Order Entry TransactionsOrder Entry Transactions Get Order Entry Transaction Object Definition Query and List Order Entry Transactions Query and List Order Entry Transactions (Legacy) Get Order Entry Transaction Get Order Entry Transaction PDF Data Create Order ...