SDE
JSON and XML API for Sage 100

Frequently Asked Questions

A Resource is a link to a Sage 100 Business Object. For example, the Customer Resource links to AR_Customer_BUS. Many Resources can point to the same Sage 100 Business Object in order to set up different Defaults and Returns.

Yes! You can set the Sage 100 Company Code in SDE in three different areas. You can enter the default Company Code in the SDE Application Setup. You can enter a Company Code in SDE User Maintenance, overriding the Company Code in Setup. Finally, you can pass the Company Code in the posted JSON or XML document, overriding both.

Yes! You can retrieve data from, and post data to, User Defined Tables and Fields. In Resource Maintenance, just select the User Defined Table and enter the table name. User Defined Fields are read or written like any other field in the selected business object.

See the Advanced Demo page to perform GET's and POST's to the Territory UDT. Select Territory UDT from the Resource dropbox. Or watch the Sage User Defined Tables video.

Yes! You may want several Customer Resources that return different datasets. You can also create Resources for Business Objects you've created as a Sage 100 Master Developer.

Yes! With your SDE License you can post from several different application and/or websites. Your posts can target one company or different companies.

No, retreiving data does not tie up a Sage 100 License. However, SDE uses a Sage 100 License when it's posting data into Sage 100.

Yes! Security is maintained by Sage 100 business objects when posting data to Sage 100. When retrieving data from Sage 100, security is checked by SDE prior to accessing the data.

Yes! You can find the Sage 100 Business Object Reference and Data File Layouts here.

Developer Support

Company  
Name
 
Email
Phone
 
Comments or Questions
 
What is 10 plus 10? (WebBot Protection)
Answer
 
Blue labels indicate required fields.
 
 

Installation Test

If you followed the instructions in our Getting Started document, you can test your connection here.

Enter your Sage Serial number, SDE License and the IP Address of your server to test your installations connection.

Sage Serial Number 
Server IP Address