deleteByPrimaryKey

Description

Deletes features from a table using a list of primary keys with an optional commitInterval. Each feature must have an ID (primary key) which is used to match it with the feature in the table. The response contains the number of features that were successfully deleted.

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.
The default value for the commitInterval is 50; therefore, the first 50 updates will be committed within one transaction. If the value is less than 1, the default value of 50 is used. It is not recommended to set this value to 1 as one transaction will be used for one update.
Note: This operation is supported for PostGIS, Oracle, SQL Server, GeoPackage, and generic JDBC data providers. It also supported on MapInfo native TAB and extended native TAB (NativeX) files on Windows operating systems only (the commitInterval is ignored). The tables must have a primary key or they will be considered read-only. Named tables with composite primary keys are not writable.

ACL Authorization Flow

To delete features in a named table, the user (or any roles they belong to) will need Execute and Delete permissions on the named table in the following manner:

  • “EXECUTE” for entity type “Location Intelligence.Named Resources”
  • “DELETE” for entity type “Location intelligence.Dataset.DML”

Messages

The following table lists the request and response messages for the deleteByPrimaryKey operation.

Click on a message name to get more information about the message.

Message Description
DeleteByPrimaryKeyRequest The request message for the deleteByPrimaryKey operation.
DeleteByPrimaryKeyResponse The response message for the deleteByPrimaryKey operation.

Example

Example for deleting features in an Oracle table by primary key. The FeatureKeyList defines the values to be deleted:


<?xml version="1.0"?>
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/"
		xmlns:ns4="http://www.mapinfo.com/midev/service/feature/v1">
	<S:Header/>
		<S:Body>
			<ns4:DeleteByPrimaryKeyRequest table="/Samples/OraWorld" commitInterval="50">
				<ns4:FeatureKeyList>
					<ns4:key>1</ns4:key>
					<ns4:key>2</ns4:key>
					<ns4:key>3</ns4:key>
				</ns4:FeatureKeyList>
			</ns4:DeleteByPrimaryKeyRequest>
		</S:Body>
</S:Envelope>