Difference between revisions of "REST API:execSQL Resource"
From LongJump Support Wiki
imported>Aeric |
imported>Aeric |
||
| Line 6: | Line 6: | ||
===Execute a SQL Query=== | ===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 | ;Method:GET | ||
| Line 13: | Line 19: | ||
{{Query Parameters| | {{Query Parameters| | ||
:*<tt>sql</tt> - The [[SQL Syntax|SQL language query]] to execute.}} | :*<tt>sql</tt> - The [[SQL Syntax|SQL language query]] to execute.}} | ||
;Response: | ;Response: | ||
Revision as of 00:31, 18 November 2011
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:
- Method
- GET
- URI
- https://{domain}/networking/rest/execSQL?sql={query}
- Query Parameters
- sql - The SQL language query to execute.
- 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