Skip to end of metadata
Go to start of metadata

Last Updated: Monday, November 18, 2019



The Current Subscriber Extract is used to show how many Subscriptions by list are active at the time of publication.


File Name

current_subscribers_YYYY-MM-DD.txt

Tab Delimited Files

Extract files will have each column delimited by a tab, as well as each record delimited by a line feed.

Contents of Each File

The extract will contain a list of mobile device numbers (MDNs), as well as other first class metadata about each Subscription for a company. This file will include all Subscriptions as of 12:00 A.M. on the day that it is run.

Note: These files may not match completely with Analytics reporting.

The File Body

The file body can contain the following fields as data separated by the delimiter and a header row.


Field Name

Data Type

Field Length

Allows Nulls

Description

mdn

String

255


Mobile number included in the Subscription List. The Mobile Directory Number (MDN) is the 10 digit number that does not include country code or "+".

person_id

String

40


Unique Vibes-specified GUID representing the Person.

external_person_id

String

40

✔︎

External system's Person identifier to include in the Subscription List.

carrier_code

String

255


The carrier code indicating specific carrier. See Appendix - Carrier Codes for all valid carriers.

mdn_e164_format

String

255


Mobile number included in the Subscription List. The Mobile Directory Number (MDN) is in E.164 format, which includes country code and "+". Example: +12295551234.

country_code

String

255


This is the current country code of the MDN associated with the Subscription.

subscription_list_id

String

255


Subscription List the Person is associated with.

Example File




  • No labels