Hello everyone,
I'm trying to figure out how I might be able to get data from a CSV file, preferably from Google Drive, and use that data to input records into my app. I would like to have a CSV file of bank transactions import into my app, and hopefully via workflow/automation, rather than add transactions via mobile app/form one by one each time a transaction happens, or having to use the standard import function.
At a minimum, I at least need a way to retrieve the data from the CSV. I could likely figure out the right way to use and import the data, I just can't seem to GET it first.
I have played at using the Invoke URL deluge task, and the getFileContent deluge function, but the best I seem able to get is the html data of the folder containing the CSV, not the CSV. I tried using the URL of the folder, and the URL of the file itself, but all I receive is null data.
I played around with Zoho flows but I'm not really sure if that has the proper capability. It seems that I could use it to fetch the latest CSV file ID from Google, but I would still need to use deluge script (Invoke URL again, likely) to fetch that file data using the flow generated ID.
Wish Zoho just connected with Drive, that would be easiest of all, but that doesn't seem to work either.
All ideas, thoughts, are welcome and would would be well appreciated.