I am writing a small app on our side to general some csv files for some Lookup table extensions. Is the a web service api or ftp site to automate the loading of the lookup table files so the user does not have to manually update them through the web interface? And if so, is there another web service api to publish the changes in both our common and production profiles?
I'm afraid we don't have any APIs or FTP sites for that purpose. Right now you still have to manually upload your CSVs, and you still have to manually publish the changes for your profiles. I do appreciate that it would be easier on you to automate a lot of this through API calls, but that also opens up a lot of risks. Someday we may open up an API to allow users to programmatically publish (and other tasks), but I can't promise anything. If you have very large CSVs to upload, or a huge number of profiles to publish, reach out to your account manager and they may be able to help you out.