Would need help to export files from database collection! Files as image, docx, pdf, etc.
The purpose is to migrate/duplicate the database to other database elsewhere, say Google Drive or other cloud based SQL database.
Currently there's no FTP support nor easy to export files, but only field values. The path of the data field once exported also render useless if export collection to .csv file in Wix dashboard, because it shows path in this format, "wix:document://v1/535f77_4ee652445840ba831d5431becca9fb.docx/Resume.docx" and "image://v1/535f77_c323cf5e8e2644fa3103c3b56ab2c7~mv2.jpg/320_320/535f77_c3cf5e8e26444fba3103c3b56a2c7~mv2.jpg", which cannot be downloaded directly.
So I'm assuming this need to be done in the code level. However, which function will able to perform the operation like take the path and upload the files via Google Drive API or other cloud database API?
Also the best will able to keep the database structure, because I would to migrate the files and keep other fields matched. In this case, that data contain names, resumes, profile pictures, email, etc. So the data need to be keep organized and aligned during and after data migration.
Thanks for the help in advance!