The ExecuteXQL operation of the ERPConnectServiceRest.svc Web service returns a JSON object. AJAX is enabled through the $.getJSON-method of jQuery (see www.jquery.com).
Result as XML
In addition to returning data JSON format, you can request the data to be returned as XML:
Use of a specific ECS Application
If the program should access a specific ERPConnect Services Application, please use the parameter applicationName.
Using the REST interface each XQL statement must return a table as a result. More than one return parameters are not supported. For the execute statement a @RETVAL parameter must be defined.
Example with RESTClient
RESTClient is an add-on for many browsers that enables you to call REST Services. The following screenshot shows how to execute an XtractQL statement using the ECS REST services.