Excel Add-In for Salesforce Marketing Cloud

Build 20.0.7695

LineMessengerProperties

Query and create Line messenger properties.

Table Specific Information

Select

Retrieve all registred line messenger properties:

SELECT * FROM LineMessengerProperties

Retrieve a specific registred line messenger property:

SELECT * FROM LineMessengerProperties WHERE ID='23493453984234345'

Insert

To register a new line messenger property you must specify ChannelId, ChannelName, ChannelSecret, IsTransactional, IsTestChannel, EndpointUrl and ApiVersion:

INSERT INTO LineMessengerProperties(ChannelId,ChannelName,ChannelSecret,EndpointUrl,IsTransactional,IsTestChannel,IsActive,ApiVersion) VALUES('23493453984234345','SFMC Engineers','03d537gg656gvkbe9b430f002e9c4517','https://example.com/1732555047025799',true,false,true,'v2.0')");

Columns

Name Type ReadOnly References Filters Description
ChannelId [KEY] String False =

The Id of the LINE Messenger property.

ChannelName String False

LINE channel name.

ChannelSecret String False

LINE channel secret.

CustomerConnectSecret String False

LINE Customer Connect Secret needed for validating LINE inbound events when using Switcher API.

IsTransactional Boolean False

Indicate if LINE channel is Transactional or Reseller.

IsTestChannel Boolean False

Indicate if LINE channel is a Test channel.

EndpointUrl String False

Send API url of the LINE network.

IsActive Boolean False

Indicate if the LINE Messenger resource is active.

ApiVersion String False

The API version of the OTT property.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7695