FacebookMessengerProperties
Defines properties for Facebook Messenger integrations in Salesforce Marketing Cloud. These properties control how messages are formatted, delivered, and tracked within Facebook channels. This table allows you to query existing properties or create new configurations to manage social messaging campaigns.
Table Specific Information
Select
Retrieve all registred facebook messenger properties:
SELECT * FROM FacebookMessengerProperties
Retrieve a specific registred facebook messenger property:
SELECT * FROM FacebookMessengerProperties WHERE PageId = '1732555047025799'
Insert
To register a new facebook messenger property you must specify PageId, ApplicationId, ApplicationSecret, PageName, PageAccessToken, CallbackVerifyToken, EndpointUrl and ApiVersion:
INSERT INTO FacebookMessengerProperties (PageId, ApplicationId, ApplicationSecret, PageName, PageAccessToken, EndpointUrl, CallbackVerifyToken, ApiVersion) VALUES ('1732555047025799', '1093076390764037', '03d537gg656gvkbe9b430f002e9c4517', 'SFMC Engineers', 'someaccesstoken4fasdcruib213123knubkdnfisdubnu12312ub3pijnb', 'https://graph.facebook.com/v2.6/me/messages', 'this_is_the_verify_token', 'v2.0')
Columns
| Name | Type | ReadOnly | References | Filters | Description |
| PageId [KEY] | String | False | = |
Specifies the unique identifier (Id) of the Facebook Page that is connected to the Messenger property. This identifier allows Salesforce Marketing Cloud to associate outgoing messages and incoming events with the correct Facebook Page. | |
| ApplicationId | String | False |
Specifies the Facebook Application Id that is registered for use with the Messenger integration. This value links the Salesforce Marketing Cloud account to a specific Facebook Application configuration for API authentication and message delivery. | ||
| ApplicationSecret | String | False |
Specifies the Facebook application secret key that is used with the ApplicationId value to authenticate API requests. This value should be stored securely because it grants access to the associated Facebook App and its Messenger permissions. | ||
| PageName | String | False |
Specifies the name of the Facebook page that is connected to the Messenger property. This name appears in user-facing interfaces and helps identify the origin of messages within Salesforce Marketing Cloud. | ||
| PageAccessToken | String | False |
Specifies the access token that is required to authenticate message send requests to the Facebook Graph API. This token allows Salesforce Marketing Cloud to post messages, retrieve replies, and handle event callbacks for the connected page. | ||
| CallbackVerifyToken | String | False |
Specifies the verification token that Facebook uses to validate webhook callbacks. This token ensures that incoming callback events originate from Facebook and have not been tampered with. | ||
| EndpointUrl | String | False |
Specifies the Send API endpoint URL of the Facebook network. Salesforce Marketing Cloud uses this URL to deliver outbound messages and event notifications through the Facebook Graph API. | ||
| IsActive | Boolean | False |
A Boolean field that returns a value of 'true' when the Facebook Messenger property is active and available for use. It returns a value of 'false' when the property is disabled, expired, or not linked to a valid page. | ||
| ApiVersion | String | False |
Specifies the Facebook Graph API version that is used for the Messenger integration. This version determines available endpoints, authentication behavior, and compatibility with Facebook's latest messaging features. |