AgileApps Support Wiki

Difference between revisions of "REST API:execSQL Resource"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
 
(13 intermediate revisions by the same user not shown)
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:''
:''Learn more:'' REST API [[REST API#Conventions and Considerations|Conventions and Considerations]].
:* [[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]] (categorized) page
# Add an entry to the [[REST API:REST Resources (alphabetical)|REST Resources]] page
}}


===Permissions===
===Permissions===
{{TBD|Are the permission(s) right?}}
{{permissionRef|Customize Objects|use this resource.}}
:* [[Develop Tools]] permission must be enabled for the tenant.
{{permissions|Manage Develop Features|use this resource.}}


===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
   
   
;URI:<tt><nowiki>https://{domain}/networking/rest/execSQL?sql={query}</nowiki></tt>  
;URI:<tt>{{platformURL}}/rest/execSQL?sql={query}</tt>  


{{Query Parameters|
{{Query Parameters|
:*<tt>sql</tt> - The SQL language query to execute.}}
:*<tt>sql</tt> - The [[SQL Syntax|SQL language query]] to execute, with special characters encoded}}


;Response:
;Response:
The tag names (shown here as field1, field2, etc.) are the column names specified in the query, or their aliases.
:<syntaxhighlight lang="xml" enclose="div">
:<syntaxhighlight lang="xml" enclose="div">
<platform>
<platform>
     <execSQL>
     <record>
         <id>...</id>
         <field1>...data...</field1>
         <field>data</field>
         <field2>...data...</field2>
         ...
         ...
     </execSQL>
     </execSQL>
Line 38: Line 34:
         <description>Success</description>
         <description>Success</description>
     </message>
     </message>
     <recordCount>N</recordCount>      <!-- Number of __ records returned -->
     <recordCount>N</recordCount>      <!-- Number of records returned by the query -->
</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]]

Latest revision as of 20:34, 29 March 2013

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

Learn more: REST API Conventions and Considerations.

Permissions

Lock-tiny.gif

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://{yourDomain}/networking/rest/execSQL?sql={query}
Query Parameters
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
Retrieved from "https://agileappscloud.info/aawiki-src/index.php?title=REST_API:execSQL_Resource&oldid=15809"