JDBC Driver for Salesforce Marketing Cloud

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462