Specifies the insert method that the provider uses when writing data to Microsoft Project.

Possible Values

Data Type

string

Default Value

"ADD"

Remarks

Set this property to control how the connector performs insert operations. Leave the value as ADD unless your scenario requires OData-specific behavior.

Available options:

• ADD (recommended): Uses the standard Microsoft Project Add functions for insert operations. This mode performs validation based on Microsoft Project’s object model and is appropriate for most write scenarios.
• ODATA: Uses the service’s OData insert functionality. This mode provides more direct write access, but does not validate that the insert was successful and does not support deep inserts. Use this option only when you are certain a column is writable and inserting into fields that cannot be written using ADD mode.

The ODATA mode may result in incomplete or partially written data if the service cannot validate inserts. In such cases, in the status-indicating resultset the connector returns after executing an INSERT, the AffectedRows column returns a value of "-1" to indicate that the success of the operation couldn't be verified. The ODATA mode is also unable to verify the success of UPDATE queries.

ADD mode generally provides more reliable write operations and reduces the likelihood of inconsistent data states.