I am looking for some help with exporting client data (specifically billing information) out of campaign monitor.
Using the PHP wrapper would it be possible to export all of the clients and their details, including billing data to a .csv file. I have been able to export certain variables such as currency, company name etc already but I need a way of looping through all of my clients and exporting their data.
Any help on where to get started would be fantastic,
Hey there Dan, while it's possible to return the client's name and ID via the API, at present we don't have a way of returning their billing history. Sorry about this - it's certainly one for us to consider in the future, so I'll happily add your vote for this and keep you posted.
I may have not explained myself very well.
Using the PHP wrapper I can currently obtain specific variables such as currency and markup per recipient.
My issue is currently I can only do this for one client at a time which I enter manually. I was wandering if there would be a way to loop through all of my clients within the system that then exports to an external file.
I hope this makes my issue a bit easier to understand.
You can easily grab all the clientIDs from the API and loop through them to grab all the information.
Writing to a CSV file then looks to be fairly trivial in PHP.
Hope that helps :)