Nightly SFTP Events

What is SFTP (Simple File Transfer Protocol)?

Nightly Data Dumps

• Get course completion events sent in bulk nightly at 2:00 am ET via a nightly SFTP dump

Details

An SFTP Transfer is a nightly transfer of events from TI to a secure client FTP (SFTP) in CSV or JSON format. For example, every night on an automated basis, you could receive a file containing all course completions that occurred over the previous day.

• All events which occurred over the previous day will be posted at ~2am everyday. Files can be in either CSV or JSON format.

• SFTP transfers are fired at roughly 2am (based on the configured time zone) and will contain all events from the previous day. For example, the SFTP transfer sent at 2am on Friday will contain all of Thursday’s events.

• Files can be automatically detected and transformed into a format consumable by enterprise software / email marketing systems, or can be manually processed asynchronously.

• The connection will time out in 60 seconds. If your server does not respond before the connection times out, or takes longer than 5 minutes total to transfer the file, we will consider the delivery of the message as a failed attempt.

• If SFTP transfer delivery fails, we will automatically retry over time. We will retry ten times total with an exponential backoff starting from 20 seconds up to 3600 seconds, giving up approximately 3.5 hours after the first SFTP transfer attempt.

Integration Overview

1. Send Innovative Educators your SFTP URL with username, password, domain, port and path where you would like files to be sent.

   • sftp://user:pass@host:22/path

   • Usernames and passwords should have the following special characters percent-encoded:

     • ] [ ? / < ~ # ` ! @ $ % ^ & * ( ) + = } | : " ; ' , > { space

   • Double check there are no erroneous spaces or other characters in the URL.

2. Let us know your desired data format. Choices are:

   • JSON or CSV

3. Once setup, data dumps will begin at 2:00am (timezone based on instance configuration, but usually ET) and continue every 24 hours until requested otherwise.

Security

IP addresses for whitelisting:

• 54.243.7.71

• 18.209.174.66

• 3.83.213.76

• 168.245.34.51

• 167.89.97.235

Event Examples

See examples of event data here