tableEditsRequest

The VertiGIS Integrator uses the tableEditsRequest to edit data in standard database table rows (e.g. Oracle, PostgreSQL). It retrieves the data from the endpoints specified in the request.

Attributes:

•The endPoint is the name of the database outbound endpoint configured in the Service endpoints from the VertiGIS Integrator (e.g. UtilityNetwork).

•The priority of requests takes place based on a specified order.

•The tableRows can be either a tableRow or a tableRowXML element.        

tableRow

For the tableRow attribute you can specify the:

•The attributes are a collection of keys and values representing the field names and their corresponding values in the feature layer or table, which should be updated or inserted.

•The tableName represents the name of the database table from where rows should be deleted.

•If the whereClause is defined request will search for the specific features or rows and update them. If the whereClause is empty, the request will make an insert in the table.

tableRowXML

You can use the tableRowXML to check whether there are some differences between 2 tables by comparing the ID and XML fields. The tableRowXML writes or updates a table but does not write the attribute directly in the field. It gets instead the foreignKeyValue attribute and writes it in the ID field, then it creates an XML string and writes it in the XML field.

For the tableRowXML attribute you can specify the:

•attributes: This is a collection of keys and values representing the field names and their corresponding values in the feature layer or table, which should be updated or inserted.

•foreignKeyFieldName: It takes the attribute name and values from the XML and will write them in the ID fields.

•idFieldName: The usual default value is ID but you can change it by specifying it in the request.

•tableName: It represents the name of the table.

•whereClause: If defined, the request will search for the specific features or rows and update them. If the whereClause is empty, the request will make an insert in the table.

•xmlFieldName: The usual default value is XML but you can change it by specifying it in the request.