CREATE TABLE `data_cmtelecom` (
`IntegrationName` CHAR(50) NOT NULL COLLATE 'latin1_general_ci',
`payload` TEXT NULL DEFAULT NULL COLLATE 'latin1_general_ci',
`endpoint` CHAR(255) NULL DEFAULT NULL COLLATE 'latin1_general_ci',
`extractsql` CHAR(255) NULL DEFAULT NULL COLLATE 'latin1_general_ci',
`active` CHAR(255) NULL DEFAULT 'N' COLLATE 'latin1_general_ci',
PRIMARY KEY (`IntegrationName`) USING BTREE
)
COLLATE='latin1_general_ci'
ENGINE=InnoDB
;
{
"messages":{
"authentication":{
"productToken":"$producttoken$"
},
"msg":[
{
"body":{
"type":"auto",
"content":"FallbackTextforSMS"
},
"to":[
{
"number":"$tonumber$"
}
],
"from":"$fromnumber$",
"allowedChannels":[
"WhatsApp"
],
"richContent":{
"conversation":[
{
"text":"$text1$"
},
{
"text":"$text2$"
},
{
"media":{
"mediaName":"$medianame$",
"mediaUri":"$mediauri$",
"mimeType":"image/jpeg"
}
}
]
}
}
]
}
}