• Become a Power user Intro to AutoHotkey Intermediate AutoHotkey Intermediate Objects GUIs are Easy w/AutoHotkey Painlessly switch from V1 to V2

Save a ton of time by uploading a contact list using SilverPop API and SFTP

SilverPop APIUploading a contact list to Engage can be time consuming using their web interface.  Even when I focus on the task, it takes from 7-10 minutes.

SilverPop API

Most don’t know that SilverPop API is a decent API webservice.  Tie it in with a SFTP (secure file transfer) and suddenly your uploading lists in about 5 seconds!

While the video is a couple of minutes long, the actual work involved is only a few seconds. After uploading the list, the script launches a separate checker to see when the data job completes and then writes my confirmation email for me.

 

Loading contacts to SilverPop via API call & SFTP file transfer

API call & SFTP file transfer

API call & SFTP file transfer

API call & SFTP file transfer

Loading our contact lists into Engage via their Web interface (browser) takes around 7-9 minutes of focused attention per list.  Doing the same thing with an API call and Secure File Transfer (SFTP) takes seconds!  The below video demonstrates the process from using web scraping to grab the name /ID on our SharePoint server to uploading the file to Engage, creating the name in Engage and tying the new name to the contact list.  The video is longer because I also have it wait for the data job to complete and then write an email confirming the process is complete.

The API call & SFTP file transfer is free with Engage/SilverPop but it isn’t well promoted (on their website nor by their representatives.  Spending a bit of time to get it working is well worth the investment. For the SFTP file transfer I’m using WinSCP but any SFTP program will do.

 

 

API call & SFTP file transfer