Note: The API includes the ability to execute the SQL commands SELECT, UPDATE and INSERT. While it is possible to use these commands to perform common operations against the database, you must use the pre-defined functions wherever possible instead. This is because many operations need to be performed in a certain order to keep consistency with how Classic Sales performs these operations. In many cases, the same code is used for both Classic and web Sales operations.