Hey everyone,

My question is more of a personal head scratcher.  

In my finance app, I want to do a some exchange rate conversion.  I found this site, https://api.exchangeratesapi.io/latest, which provide basic csv type data of the current rates of the day (adequate for my needs, and free :-).

I was able to make a workflow using the invoke url deluge task to bring the data into a text field.  Great.  Problem is, now I can't seem to figure out what to DO with the data.  

In the text field, it's not separated data, just a long string of data.  That isn't very helpful.  What I would like to know, or get ideas for, is either how to split up/extract the data into something more workable.  Or maybe there is a better way to pull the data into Zoho with the invoke url task.  

I'm mostly interested in the US and Euro conversion rates as i do regular transfers between the 2 countries, though on very rare occasion I might purchase from the UK as well.

I'm open to any ideas, even solutions that have nothing to do with what I described above.  

Thanks everyone!