en:dataexchange:export_blocklist_audit

This is an old revision of the document!


Export Types

Blocklist Audition

Every change (additions and losses) of blocklists are exported.

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

Example:

"blocklistId";"ts";"userId";"custID";"mail";"status";"sourceType";"sourceId";"remark"
"80347";"2011-01-26 00:10:04";"522503";"CUSTOMERCODE";"mail@mail.com";"1";"1";"13011";""
  • blocklistId [int]: internal, unique
  • ts [datetime]: YYYY-MM-DD, date of change
  • userId [int]: internal, unique per user
  • custID [string]: external, ID of customer
  • mail [string]: external, e-mail address
  • status [int, -1|1]:
    -1: removed from blocklist
    1: added to blocklist
  • sourceType [int]: source of change
    1: address generation
    2: not used
    3: not used
    4: promio.mail cronjob (autom. processes)
    5: promio.mail manual change
    6: not used
    7: holiday block
    8: auto-campaign
    9: hardbounce cleaning
    10: blacklist cleaning
    11: removal due to feedbackloop complaint
    12: SOAP addUserToBlocklist, removeUserFromBlocklist
    13: SOAP general
  • sourceId [int]: optional, corresponding to sourceType
  • remark [string]: optional, additional information
en/dataexchange/export_blocklist_audit.1438184037.txt.gz · Last modified: 2015/07/29 17:33 by fw