Skip to main content
MX has halted SFTP enablement. New integrations should use the API endpoints as outlined in Using The Reporting API. Current integrations will remain supported.
You may optionally have us deliver your daily reporting files to an SFTP (Secure File Transfer Protocol) server rather than retrieving them through the API endpoints. In order to do so, there are certain requirements.
  • You must provide an SFTP server.
  • You must provide a public GPG key.
  • SFTP server must use a non-standard port, i.e., not port 22
  • You must provide a username and password to MX for authentication to the SFTP server.
  • We need to whitelist any IP addresses for your SFTP server.
If a particular resource has no data for a given day, an Avro file with headers but no body is generated and delivered.
When using an SFTP, if your IP addresses ever change, you will need to contact MX to have them updated or you will not receive the daily avro files.

​
Daily Files Manifest

Using SFTP also sends an encrypted manifest file in CSV format containing information about each daily file being delivered. This includes the resource type, the event type (created, updated, etc.), the date, number of records, and file size. Each row in the manifest file represents one daily file in the bunch. Each manifest file is named according to the following format: client_guid.snapshot_date-manifest.csv.pgp. Manifest files are encrypted using the same public key as the daily files.

​
Manifest File Fields

​
Resource Types

New resource types may be added at any time.
  • ACCOUNTS
  • ANALYTICS_EVENTS
  • ANALYTICS_PAGEVIEWS
  • ANALYTICS_SCREENVIEWS
  • ANALYTICS_TIMED_EVENTS
  • BEAT_FEEDBACK
  • BEAT
  • BUDGETS
  • CATEGORIES
  • DEVICES
  • DISCOVERED_ACCOUNTS
  • DISCOVERED_TRANSACTIONS
  • GOALS
  • HOLDINGS
  • MEMBERS
  • NOTIFICATION_PROFILES
  • TAGGINGS
  • TAGS
  • TRANSACTIONS
  • USER_COMMUNICATION_PROFILES
  • USERS

​
Event types

  • CREATED
  • DELETED
  • UPDATED
Example manifest file contents

​
Providing a Public PGP Key

To enable the Reporting API, you must provide a public PGP key in PEM format. MX uses this key to encrypt the files you will receiving. PGP (Pretty Good Privacy) is an encryption program that provides cryptographic privacy and authentication for data communication. PGP is used for signing, encrypting, and decrypting texts, e-mails, files, directories, and to increase the security of e-mail communications. If you are unfamiliar with using PGP keys, reach out to your development and IT teams or ask your MX representative or our support team for help. There are many tools available for generating PGP keys, including the commonly used GnuPG. GnuPG is a complete and free implementation of the OpenPGP standard.