---
schema_version: "1"
id: f73bf55f3749450cc9b709ef868192ccf3f0b34a950a180a5479543c84e320a1
title: ImportDefinitionColumnBasedAction
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/marketing-cloud/guides/mc-apis/importdefinitioncolumnbasedaction.md
canonical_url: https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/importdefinitioncolumnbasedaction.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: f4a42e18ca6097463ebe62112f661c39273760f146dcf85e8943d94f718f4082
products:
  - Marketing Cloud Engagement APIs and Programmatic Languages
  - Marketing Cloud
---
# ImportDefinitionColumnBasedAction

An object that contains multiple value and action pairs that determine the action to take in a column depending on the value in a field. For example, you can set this object to skip and not add a value of A, delete a value of B, and update a value of C.

| Name     | Data Type                                                                                | Description                                                                                                                                                                                                                                                                                                       |
| -------- | ---------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `Action` | [ImportDefinitionColumnBasedActionType](https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/importdefinitioncolumnbasedactiontype.md) object | Defines the action to take for the specified object. Valid values include:<ul><li>CREATE</li><li>DELETE</li><li>UPDATE</li></ul>                                                                                                                                                                                  |
| `Value`  | String                                                                                   | Defines the value to use in a filter or other object. In filters, the `BETWEEN` operator requires two values. The `IN` operator can handle multiple values. All other operators require only one value. If the value is `isNull` or `isNotNull`, the API ignores any supplied values and doesn't return an error. |