FacebookMessengerProperties
Query and create Facebook messenger properties.
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 | = |
The PageId of the Facebook Messenger property. | |
| ApplicationId | String | False |
Facebook Application Id. | ||
| ApplicationSecret | String | False |
Facebook Application Secret. | ||
| PageName | String | False |
Facebook Page Name. | ||
| PageAccessToken | String | False |
Access Token required to authenticate send messages requests to Facebook networks. | ||
| CallbackVerifyToken | String | False |
Facebook Verify Token need to verify callback events. | ||
| EndpointUrl | String | False |
Send API url of the Facebook network. | ||
| IsActive | Boolean | False |
Indicate if the Facebook Messenger resource is active. | ||
| ApiVersion | String | False |
The API version of the OTT property. |