Need To Export Open Date and Opt Out on a Regular Basis To integrate With External System
We need to integrate with another system the customer's last open date and their opt out information. I am open to the best way to do it but I thought perhaps:
1. Schedule a query or export nightly.
2. Have results go to SFTP site.
3. External system consumes the file.
Can you suggest the best way to accomplish this business requirement. I read somewhere that you can't schedule a recurring export but you can be creative to work around this. Not sure how.
You could consider automating this by using the XML API (XML API overview (goacoustic.com). It's quite easy and reliable to do. And then gives you all the flexibility of handling how you want it. The automation can be done via any language at your disposal (PHP, Java, Python, PowerShell, ..). We've used Python in our case.
We went the automated scripted way because of the lack of possibilities presented in the current GUI. The GUI does provide enough possibilities for manual actions; but it definitely lacks in automating stuff. Hence the scripting way, as it opens up possibilities simply lacking in the current GUI.
Please sign in to leave a comment.