You might investigate Insert From URL as a way to insert the file into a container field. Once it is inserted there, you can use export field contents to export the file and now you have a file on your local disk that can be imported like any other csv file.
This db is hosted on a FMP13 server. Would exporting to local disk work and can it be scheduled with the FMP Server like other schedules?
Export Field contents, unfortunately, is not server side compatible.
You may need to set up a robot file on a timer or such to run this from a client session instead of a host session.
That's how we currently have it set up. That's why I asked if there was another way to do it so it would all be self contained.