REST API:execSQL Resource

From LongJump Support Wiki

Use the SQL query language to access Object tables, using the REST API.

Learn more: REST API Conventions and Considerations.

Permissions

Users that have the Customize Objects permission can use this resource.

Execute a SQL Query

Use the SQL query language to execute a query against Object tables.

Learn more:

• SQL Browser
• SQL Syntax
• SQL Functions

Method

GET

URI

https://na.longjump.com/networking/rest/execSQL?sql={query}

Query Parameters

• sql - The SQL language query to execute, with special characters encoded

For more information, see: Specifying Query Parameters in REST APIs

Response

The tag names (shown here as field1, field2, etc.) are the column names specified in the query, or their aliases.

<platform>
    <record>
        <field1>...data...</field1>
        <field2>...data...</field2>
         ...
    </execSQL>

    <message>
        <code>0</code>
        <description>Success</description>
    </message>
    <recordCount>N</recordCount>      <!-- Number of records returned by the query -->
</platform>

See also: REST API:Error Codes