Hi. I’ve been investigating a couple of posts that talk about connecting to the google api. I think I’ve got the general idea, but I can’t seem to find to do a couple of things in particular:
Open a folder and get a list of files
Open CSV files to process them
Basically I want to update a database with CSV files, but I don’t want to use Wix tools to do it since I want it to be an automated process. I’ll write a program that will leave the CSV files inside a Drive folder periodically and then I want to schedule a job in wix to read that folder to process the file and update my database.
To get the list of files and open files I understand I can use these from the googleapi
https://www.googleapis.com/drive/v3/files/fileId & https://www.googleapis.com/drive/v3/files
I am not sure how to do the second part: reading the file I’ve just downloaded from Drive. Can I do something like that? Or should I scratch everything and resign to do the updates manually once per day?
My initial idea was to publish a webservice in my site, but it seems that I cannot publish a secure webservice in Wix. I don’t want a public WS since it’s important data for the site.
Thanks in advance.