The JSON to Table tool is stalling when I try to parse a basic result I am getting from a currency exchange website. it is basically rates for the all of the countries by all of the dates for a calendar year. I am trying to figure out the best way to break this up with JSON path before creating the final table. Any suggestions?
Attached is the full JSON result if that helps.
rates.json (1.5 MB)
Hello @aehrenworth,
This definitely was a bit challenging, but I have made a sample workflow you can tweak to fit what you want. I got pretty much most of it on there where we split each currency to a column and each row has the date.
You can download it here:
Hope this helps,
TL
Thanks for agreeing on the complexity 
– glad to hear that I wasn’t crazy trying to figure this out.
Ultimately, this is a very simple and elegant solution to my needs. Will see if I can get it to work for a larger date range.
really appreciate the support!
As an update, I added a Loop option to be able to go through 2 years of results and put them together. This was helpful because you can also do an API call for 1 year max at a time.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
