en:dataexchange:export_channel_optins

Automatic export: Type 'Channel Optins'

Every change in optins (additions and removals) of all channels are exported.

Filename:
[SENDER-ID]_channelOptins_[full|incremental].csv (respectively with individual date suffix)

Example:

"id";"status";"channelId";"ts";"interfaceId";"userId";"custId";"ip";"data"
"542";"1";"1";"2023-02-08 17:35:42";"244";"30";"CUSTOMERCODE";"192.168.0.1";"{"mail":"mail@mail.com","__log":"website"}"
"509";"-1";"3";"2023-01-05 16:47:26";"0";"29";"CUSTOMERCODE";"192.168.0.2";""
"468";"1";"3";"2023-01-05 15:25:50";"41";"21";"CUSTOMERCODE";"192.168.0.6";"{"phoneNumber":"4917234567","__log":"register test sms"}"
"450";"1";"1";"2023-01-05 14:55:25";"70";"19";"CUSTOMERCODE";"192.168.0.6";"{"mail":"mail@mail.com","firstName":"Max","lastName":"Mustermann","gender":"1","__log":"register test mail"}"
"369";"1";"6";"2022-12-27 16:38:29";"76";"20";"CUSTOMERCODE";"192.168.0.6";"{"providerAddressIdentifier":"23333a-5b6c-4332-afae-ecxxx6b11","providerId":"4","__log":"register test webpush"}"
"300";"1";"7";"2022-09-21 09:33:30";"219";"84";"CUSTOMERCODE";"192.168.0.2";"{"phoneNumber":"4919876543","__log":"register test voice"}"
"243";"1";"5";"2022-07-29 14:56:21";"78";"55";"CUSTOMERCODE";"192.168.0.3";"{"mail":"mail@mail.com","firstName":"Maxi","lastName":"Musterfrau","street":"Mustergasse 22","postcode":"53113","city":"Bonn","countryCode":"de","__log":"register test print"}"
  • id [int]: ID of process (promio internal)
  • status [int, -1|1]: status of optin
    -1: optin removed
    1: optin added
  • channelId [int]: ID of channel
    1: E-Mail
    2: App Push
    3: SMS
    4: WhatsApp
    5: Print
    6: Web Push
    7: Voice
  • ts [datetime]: timestamp of addition/removal (YYYY-MM-DD HH:MM:SS)
  • interfaceId [int]: ID of interface
  • userId [int]: ID of user (promio internal, unique)
  • custID [string]: ID of customer (customer code)
  • ip [string]: IP address of optin
  • data [text]: data transferred with optin (channel address etc.)

If interested or for questions regarding the automatic export, please contact our support team via ticket.
You find more export types in the article Export: Which specifications has the batch process?.

en/dataexchange/export_channel_optins.txt · Last modified: 2023/06/19 11:08 by fw