LineMessengerProperties
The table that defines configuration properties for LINE messenger integrations in Salesforce Marketing Cloud. These properties determine how messages are delivered and tracked within LINE communication channels. This table allows you to query and create properties to support messaging automation for the LINE platform.
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 | = |
Specifies the unique identifier (Id) of the LINE Messenger property. This Id corresponds to the LINE channel configured in Salesforce Marketing Cloud and is required for authentication and message routing. | |
| ChannelName | String | False |
Specifies the name of the LINE channel. This value matches the channel name configured in the LINE Developer Console and helps identify the messaging source within Salesforce Marketing Cloud. | ||
| ChannelSecret | String | False |
Specifies the LINE channel secret that is required to authenticate requests between Salesforce Marketing Cloud and the LINE platform. This value validates that calls originate from a trusted integration. | ||
| CustomerConnectSecret | String | False |
Specifies the LINE Customer Connect secret that validates inbound events sent through the Switcher API. This secret ensures that messages, replies, and webhook events originate from LINE and have not been tampered with. | ||
| IsTransactional | Boolean | False |
Specifies whether the LINE channel is classified as transactional or reseller. A value of 'true' designates a transactional channel that is used for direct customer messaging, and a value of 'false' designates reseller channel behavior. | ||
| IsTestChannel | Boolean | False |
Specifies whether the LINE channel is configured as a test channel. A value of 'true' indicates a sandbox or non-production configuration, and a value of 'false' indicates a live messaging channel. | ||
| EndpointUrl | String | False |
Specifies the LINE Send API URL that Salesforce Marketing Cloud uses to transmit outbound messages. The endpoint determines where message payloads are delivered for processing by LINE. | ||
| IsActive | Boolean | False |
Specifies whether the LINE Messenger resource is currently active. A value of 'true' indicates that the channel is enabled for messaging operations, and a value of 'false' indicates that the channel is disabled or not fully configured. | ||
| ApiVersion | String | False |
Specifies the version of the Open Traceability Transport (OTT) API that applies to the LINE Messenger property. This version determines the supported message formats and API capabilities. |