Import Mode Processing Examples

The following example shows how objects are updated in the database depending on the import mode you choose to use.

The values represented in the feed are:

Note: Absent from the XML file is an object that already exists in the database (E).
XML FIle Objects Pre-Import Database Objects Import Mode Post-Import Database Objects
A+a, B-a, C, D, FΔa A, B, C, E, F MERGE A+a, B, C, D, E, FΔa
    UPDATE A+a, B, C, E, FΔa
    REPLACE A+a, B-a, C, D, E, FΔa
    DELETE E

For MERGE and UPDATE, attributes not specified in the feed are not removed, which is why you see B, rather than B-a. If you wish to remove an attribute, you might need to change the attribute value to none or blank, rather than changing the import mode. The correct value to specify differs, depending on the attribute. See the Framework section for more information on how specific attributes are processed.

For UPDATE, the object D isn't created.

You might note that in none of the table scenarios is the object "E" removed. There is no mode that deletes objects not included in the feed. You must decide on a strategy to explicitly remove outdated objects. For more information, see Removing Outdated Objects.

X Privacy Update: We use cookies to make interactions with our websites and services easy and meaningful, to better understand how they are used and to tailor advertising. By continuing to use this site you are giving us your consent to do this.