We need to update a couple of remotes tables with information provided by our clients, to our central server. Currently we're doing it by generating csv files, then uploading them via FTP (secured by VPN) or form upload, then a PHP Script process them and dump them into the database.
We'd like to implement a REST service that would be able to do that. Is it recommended that I send all the information as JSON instead of the text files?
Any suggestions would be greatly appreciated. I've been looking several solutions but none come close to what we need to do.