Difference between revisions of "REST API:execSQL Resource"
From AgileApps Support Wiki
imported>Aeric |
imported>Aeric |
||
| Line 1: | Line 1: | ||
Use the SQL query language to access Object tables, using the [[REST API]]. | Use the SQL query language to access Object tables, using the [[REST API]]. | ||
:''Learn more:'' | |||
:* [[SQL Syntax ]] | |||
:* REST API [[REST API#Conventions and Considerations|Conventions and Considerations]]. | |||
{{TBD|<br/> | |||
{{ | |||
# Add an entry to the [[REST API:REST API CheatSheet|REST API CheatSheet]] | # Add an entry to the [[REST API:REST API CheatSheet|REST API CheatSheet]] | ||
# Add an entry to the [[REST API]] (categorized) page | # Add an entry to the [[REST API]] (categorized) page | ||
# Add an entry to the [[REST API:REST Resources (alphabetical)|REST Resources]] page | # Add an entry to the [[REST API:REST Resources (alphabetical)|REST Resources]] page | ||
}} | }} | ||
===Permissions=== | ===Permissions=== | ||
| Line 19: | Line 16: | ||
===Execute an SQL Query=== | ===Execute an SQL Query=== | ||
;Method:GET | ;Method:GET | ||
| Line 43: | Line 41: | ||
</platform> | </platform> | ||
</syntaxhighlight> | </syntaxhighlight> | ||
where: | |||
:* The column names are the columns from the queried rows, or their aliases. | |||
:See also: [[REST API:Error Codes]] | :See also: [[REST API:Error Codes]] | ||
Revision as of 01:38, 16 November 2011
Use the SQL query language to access Object tables, using the REST API.
- Learn more:
- SQL Syntax
- REST API Conventions and Considerations.
__TBD:
- Add an entry to the REST API CheatSheet
- Add an entry to the REST API (categorized) page
- Add an entry to the REST Resources page
__
Permissions
__TBD: Are the permission(s) right?__
- Develop Tools permission must be enabled for the tenant.
Users that have the Manage Develop Features permission can use this resource.
Execute an SQL Query
- 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
- <syntaxhighlight lang="xml" enclose="div">
<platform>
<execSQL>
<id>...</id>
<field>data</field>
...
</execSQL>
<message>
0
<description>Success</description>
</message>
<recordCount>N</recordCount>
</platform> </syntaxhighlight> where:
- The column names are the columns from the queried rows, or their aliases.
- See also: REST API:Error Codes