Sample DataTable calls

You can construct calls to query any database object using the appropriate base call, CRUD operator, and search criterion. This section lists sample calls for common use cases. You can use the syntax of these calls to help you construct a call with the same CRUD action on a different database object.

ℹ️

Note

Many Orange Logic APIs can be run as GET or POST calls. You might find running GET calls directly in your browser convenient for testing.

However, be aware that there is a character limit for URLs, which varies by browser. A 403 error might indicate that your call is too long. In this situation, use the POST method to send the values in the body of the call as form data instead of in the URL.

With a POST request, some parameters can be passed either in in the HTTP header or in the URL. If the same parameter is present in both places, the value in the HTTP header overrides the URL.