Difference between revisions of "REST API:execSQL Resource"

Revision as of 01:57, 17 November 2011

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

__TBD: Are the permission(s) right?__

Users that have the Manage Develop Features permission can use this resource.

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

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

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

</platform> </syntaxhighlight>

@@ Line 1: / Line 1: @@
 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]].
-{{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===