AgileApps Support Wiki Pre Release

Difference between revisions of "REST API:execSQL Resource"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
 
(11 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:'' REST API [[REST API#Conventions and Considerations|Conventions and Considerations]].
:''Learn more:'' 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 Syntax|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 37:
</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.

<syntaxhighlight lang="xml" enclose="div">

<platform> 

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

   <message>
       0
       <description>Success</description>
   </message>
   <recordCount>N</recordCount>

</platform> </syntaxhighlight>

See also: REST API:Error Codes
Retrieved from "https://agileappscloud.info/aadev-src/index.php?title=REST_API:execSQL_Resource&oldid=15809"