Delete Features Using SQL
Description
Deletes features in a table by performing a query on a table using an MI SQL Delete command string. See the MapInfo SQL Language Reference for detailed information on MapInfo SQL functions.
Note: You must have View permissions on the named table as well as Create/Modify/Delete
permissions on the named table's associated dataset to perform insert, update, and
delete operations on writable tables. See Access Control for Datasets in
the Administration section for more information.
Note: Delete is supported on PostGIS, Oracle, SQL Server, SAP HANA, GeoPackage, and
generic JDBC tables. Named tables with composite primary keys are not
writable.
HTTP POST URL Format
The following format is used for HTTP POST requests:
HTTP POST: /FeatureService/tables/features.rep?
POST Data: [delete=MI SQL query]
POST BODY: Content-Type:application/json {bound parameters}
The {bound parameters} is a POST json body (Content-Type: application/json) for the MI SQL delete query containing one or multiple parameters to be included. Null values are supported; however, a type is still required.
Note: The json in the POST is optional; it is only required if the SQL query uses bound
parameters.
For information on the parameter types listed below, see Request URL Data Types.
Parameter | Type | Required | Description |
---|---|---|---|
rep | String | yes | The representation to be returned. Supported representation is json. |
delete=MI SQL query | String | yes | The delete query to perform, in MI SQL format. |
Returns
Returns the number of successfully deleted features in a named table in the repository.
Examples
Deletes features from MyTable using a bound parameter:
http://<hostname>:<port>/rest/Spatial/FeatureService/tables/features.json?
delete=DELETE FROM "/Samples/NamedTables/MyTable" WHERE Column1=@stringParam
{
"parameters" : [
{
"name" : "stringParam"
"value" : "stringVal"
}
]
}