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.

If Batch Entry is enabled for a data entry program in Sage 100, and the JSON or XML does not contain the Batch Number, SDE will retrieve and assign the next batch for that data entry program. For example, if your Resource is associated with the business object AR_Invoice_BUS, and batches are enabled in Accounts Receivable Options, then SDE will assign the next batch number to your post.
Only one batch per day is created for a given data entry program. So if your website is creating several invoices a day through SDE, they will all be posted into a single batch. The batch will have the current date and the comment SDE.

Developer Support

Company  
Name
 
Email
Phone
 
Comments or Questions
 
What is 5 plus 8? (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 the IP Address of your SDE server, your SDE User and the Password to test your connection.

Server IP Address 
SDE User 
SDE Password