Example: Add Event Enrichment Fields with Tooling API

Query Enriched Fields

To find out which channel members and fields you configured, query the EnrichedField object in Tooling API. For example, this query returns the selected enriched field and the channel member ID.

1SELECT ChannelMemberId,Field FROM EnrichedField ORDER BY ChannelMemberId

You can perform a query using the Query Editor in the Developer Console and by checking Use Tooling API. For more information, see Developer Console Query Editor in Salesforce Help.

Alternatively, you can run a query using REST API. Perform a GET request to the following URI. The URI includes the query with spaces replaced with +.

1/services/data/v56.0/tooling/query/?q=SELECT+ChannelMemberId,Field+FROM+EnrichedField+ORDER+BY+ChannelMemberId

In these query results, the rows returned are for the same channel member. They contain these enriched fields: Industry, the External_Account_ID__c custom field, whose value is an ID, and BillingAddress.

Update a Channel Member with Enriched Fields

If there’s an existing channel member for the same selected entity and channel, you can’t create a duplicate channel member with a POST request. Instead, update the channel member with a PATCH request. Alternatively, you can delete the channel member and recreate it with the enriched fields.

To update a channel member, follow these steps.

1. If you’re using a custom channel, get the channel ID by running this query:
   1SELECT Id FROM PlatformEventChannel WHERE DeveloperName=Channel_Name

   DeveloperName doesn’t contain the __chn suffix of a custom channel name. For example, for the SalesEvents__chn channel, the query would be:
   1SELECT Id FROM PlatformEventChannel WHERE DeveloperName='SalesEvents'

2. Get the channel member ID with this Tooling API query. For a custom channel, replace Channel_ID with the ID you got in the previous step, or for the standard ChangeEvents channel, replace Channel_ID with ChangeEvents. Replace EntityChangeEvent with the selected entity name.
   1SELECT Id,DeveloperName,EventChannel,SelectedEntity FROM PlatformEventChannelMember 
   2    WHERE EventChannel='Channel_ID' AND SelectedEntity='EntityChangeEvent'

   For example, for AccountChangeEvent on custom channel ID 0YLRM00000000434AA, the query looks as follows.

   1SELECT Id,DeveloperName,EventChannel,SelectedEntity FROM PlatformEventChannelMember WHERE EventChannel='0YLRM00000000434AA' AND SelectedEntity='AccountChangeEvent'

   Or for the standard ChangeEvents channel, the full URI would be:

   1SELECT Id,DeveloperName,EventChannel,SelectedEntity FROM PlatformEventChannelMember 
   2    WHERE EventChannel='ChangeEvents' AND SelectedEntity='AccountChangeEvent'

3. Make a PATCH request to this URI and append the channel member ID you got in the previous step.
   1/services/data/v56.0/tooling/sobjects/PlatformEventChannelMember/Channel_Member_ID

   In the request body, include the JSON definition of the channel member. For example, to update AccountChangeEvent on the channel member ID of 0v8RM00000000JsYAI and set the enriched fields to be the Phone field only, make a PATCH request to this URI:
   1/services/data/v56.0/tooling/sobjects/PlatformEventChannelMember/0v8RM00000000JsYAI

   With this request body:

   1{
   2  "FullName": "SalesEvents_chn_AccountChangeEvent",
   3  "Metadata": {
   4    "enrichedFields": [
   5      {
   6        "name": "Phone"
   7      }
   8    ],
   9    "eventChannel": "SalesEvents__chn",
   10    "selectedEntity": "AccountChangeEvent"
   11  }
   12}

   If the channel member was previously configured with enriched fields, the update clears them and replaces them with the fields specified in the request body. This example specifies only one enriched field, the Phone field. If the channel member didn’t contain enriched fields, the update adds the specified enriched fields.

   For PATCH requests, include the full definition of a PlatformEventChannelMember. Partial definitions with only the enriched fields aren’t supported.