# Data Streams: Bulk Disable Salesforce CRM Fields

**Business Goal**: Keep your Salesforce CRM connector data streams healthy by removing fields that are inaccessible or no longer needed.

Source fields can become unavailable when a standard field deprecates, a custom field is deleted, or the Platform Integration User (PIU) loses field-level access. When these cases occur, Data 360 repeatedly attempts to extract the field and fails. Disabling the field stops these attempts.

Disabling fields one at a time triggers a separate deploy cycle per field, during which no other field operations can proceed. Bulk disabling processes all fields in a single deploy cycle regardless of how many fields you select.

**Use Case**: A data stream is in error state because of missing permission or fields in the corresponding CRM org. A data engineer uses the Connect API to identify which fields are affected, then disables them in a single operation. In this example, the engineer disables one standard field (Annual Revenue) and one custom field (Is Enrolled).

For limit information, see [Data 360 Limits and Guidelines](https://help.salesforce.com/s/articleView?id=data.c360\_a_limits_and_guidelines.htm).

![Sequence diagram showing the requests for disabling Salesforce CRM fields with the Data Stream Connect API.](https://a.sfdcstatic.com/developer-website/sfdocs/data-cloud/media/connectapi/data-stream-seq-diag.png)

## Considerations for Field Disablement

- Don't disable these critical fields: Id, SystemModstamp, SfdcOrganizationId, DataSource, DataSourceObject, and cdp_sys_PartitionDate.
- Before you disable a field, determine whether you can restore field access. For example, check field existence in your source org.
- When you disable a field, new data stops populating it. Downstream consumers such as data model object (DMO) mappings, transforms, segments, and activations receive null or stale values.
- To re-enable Salesforce CRM disabled fields, use the [UpdateDataStream endpoint](https://developer.salesforce.com/docs/data/connectapi/references/spec#tag/Data-Streams/paths/\~1ssot\~1data-streams\~1%7BrecordIdOrDeveloperName%7D/patch).

## Step 1: Get field name values

Find the name value of the fields you want to disable.

### Request

Use the [get data stream](https://developer.salesforce.com/docs/data/connectapi/references/spec#tag/Data-Streams/paths/\~1ssot\~1data-streams\~1%7BrecordIdOrDeveloperName%7D/get) endpoint to get a list of all fields in your data stream. Pass the record ID or developer name of the data stream in the URL.

```
GET https://{dne_cdpInstanceUrl}/services/data/v67.0/ssot/data-streams/0dkRM000000001XYAQ
```

### Response

The API call lists all your data stream fields. To find the `name` property for the relevant fields, open the `dataLakeObjectInfo` section, and then the `fields` section. Under `fields`, note the `name` property value for each field you want to disable. Use this value to bulk disable the fields on Step 2.

For standard fields like `IsEnrollmentRequired`, the name value has no suffix. For custom fields like `customField`, it ends in `_c`.

```json
{
  "advancedAttributes": {},
  "capabilities": {},
  "connectorInfo": {},
  "dataAccessMode": "INGEST",
  "dataLakeObjectInfo": {
    "capabilities": {},
    "category": "Other",
    "dataLakeFieldInfoRepresentation": [],
    "dataSpaceInfo": [],
    "fields": [
      {},
      {
        "dataType": "Text",
        "isPrimaryKey": false,
        "label": "IsEnrollmentRequired",
        "name": "IsEnrollmentRequired"
      },
      {},
      {},
      {},
      {
        "dataType": "Text",
        "isPrimaryKey": false,
        "label": "customField",
        "name": "customField_c"
      }
    ]
  }
}
```

## Step 2: Disable data stream fields

Use the [update data stream](https://developer.salesforce.com/docs/data/connectapi/references/spec#tag/Data-Streams/paths/\~1ssot\~1data-streams\~1%7BrecordIdOrDeveloperName%7D/patch) endpoint to disable one or more fields in a single operation.

### Request

For each field, include the `name` value you obtained in Step 1 as `targetFieldName`, and set `transformationFormula` as null. For custom fields, include the `_c` suffix. In this example, one standard field `IsEnrollmentRequired` and one custom field `customField_c` are disabled.

```
PATCH https://{dne_cdpInstanceUrl}/services/data/v67.0/ssot/data-streams/0dkRM000000001XYAQ
```

```json
{
  "datastreamType": "SFDC",
  "mappings": [
    {
      "targetFieldName": "IsEnrollmentRequired",
      "transformationFormula": null
    },
    {
      "targetFieldName": "customField_c",
      "transformationFormula": null
    }
  ]
}
```

### Response

The API returns the updated data stream. The data lake object (DLO) field count remains unchanged. The API removes only the source field link and sets the formula as null. Disabled fields are tagged as **Disabled** in the Data 360 UI.

```json
{
  "dataLakeObjectInfo": {
    "capabilities": {},
    "category": "Other",
    "dataLakeFieldInfoRepresentation": [],
    "dataSpaceInfo": [],
    "fields": []
  },
  "id": "0g0SB1234B6y3R0ZAI",
  "label": "Promotion_Home",
  "name": "Promotion_Home__dll",
  "recordModifiedFieldName": "SystemModstamp",
  "status": "PROCESSING",
  "recordId": "1dsSB1234567CPuoYAG"
}
```