How to use COZYROC Sage Intacct Connector Actions Read, Create, Update and Delete Http (Methods)
Overview
- Sage Intacct Accounting and financial management ERP built for a true cloud architecture.
- Sage Intacct Bring tangible value to your organization’s strategy with cloud solutions.
- Sage Intacct Leading Accounting software for companies of any size.
COZYROC Sage Intacct Connector
By using COZYROC Sage Intacct Connector external systems can;
- GET data records from Sage Intacct instance.
- PROCESS the records.
- DELETE existing records.
- SAVE new or UPDATE current records into Sage Intacct instance.
Functions
Sage Intacct provides generic or open functions that can operate on multiple types of objects. The older, object-specific functions are labeled as legacy in the documentation, which means they are typically not enhanced. There are no plans to deprecate legacy functions, and in fact, there are cases in which they are the only functions available.
Below are few examples of how you can pass query in JSON format to read data from Resources that are using open or generic function
- { "readByQuery" : { "object" : "EMPLOYEETYPE", "fields": "*", "query": "FORM1099TYPE = 'DIV'", "pagesize": "100" } }
- { "query": { "object": "ITEM", "select": { "field": [ "ITEMID", "NAME", "RECORDNO" ] } } }
Below are few examples of how you can pass query in JSON format to read data from Resources that are using object-specific functions
- {"object": "GLACCOUNTBALANCE", "fields": "*", "query": "PERIOD = 'Month Ended Aug 31, 2008'", "pagesize": 10 }
- { "startdate": { "year": "2016", "month": "01", "day": "01" },"enddate": { "year": "2017", "month": "06", "day": "30"},"startaccountno": "xxxx","endaccountno": "xxxx", "showzerobalances": "false" }
In Below screen shot 1.0 you can see there is a by default parameters with the name JSON, you can use this parameter and pass the query in the value column as mentioned below highlighted in red.
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
How to use COZYROC Acumatica Connector Actions Read, Create, Update and Delete ( Http Methods )
CozyRoc Acumatica Connector Guide Acumatica is the complete Cloud ERP solution for all your business management needs today and in the future. With CozyRoc Acumatica Connector external systems can get data records from Acumatica ERP, process these ...Where can I find the documentation for the Sage Intacct Connection?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the Sage Intacct Connection can be found at the following link. For many of the components you can find ...Where can I find the documentation for the Sage Connection?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the Sage Connection can be found at the following link. For many of the components you can find resources ...How to Add List Members using Dataverse Connector into Dynamic CRM
This idea to generate this KB-Article is to explain with an example how you can execute actions like AddListMemebersList, AddCampaignItem etc. There is a special Resource Action available in Rest Destination for create action that can be use to ...Optimize Your Sage Intacct Data Processes
Sage Intacct Connection, just one of over 250+ components in COZYROC's SSIS+ Component Suite Connect Sage Intacct with SSIS+ seamlessly for efficient data integration. Explore COZYROC's solution for streamlined workflows. Book a Presales Call to ...