I have a simple requirement for test data. I want to be able to create a set of data records in a table from a file. For example I want to be able to add a range of Orders. I envisage it as CSV something like this:
contactID; cardID; planID; productIDs; subscriptionIDs; processSpecials; promoCodes; leadAffiliateID; saleAffiliateID 1234; 0; 0; 4321; 2341; false; ; 0; 0
This is straightforward using the ‘legacy xml-rpc’ data API:
DataService.add. So what I’d want is a command line tool that I’d use like this:
infusionsoftupload %MyAPIKey% Orders < data.csv
Clearly I could write it in Python or something. But it seems a very general purpose tool – has anyone written it (and perhaps corresponding tools to modify records, and select and download records as well)?