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
Related Articles
How to use COZYROC Acumatica Connector Actions Read, Create, Update and Delete ( Http Methods )
Acumatica is the complete Cloud ERP solution for all your business management needs today and in the future. COZYROC Acumatica Connector With COZYROC Acumatica Connector external systems can; GET data records from Acumatica ERP. PROCESS the records. ...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 ...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 ...Where can I find the documentation for the Sage Source?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the Sage Source can be found at the following link. For many of the components you can find resources ...Where can I find the documentation for the Sage Destination?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the Sage Destination can be found at the following link. For many of the components you can find ...