API for currency exchange rate

[Rahul_Analyst]

Hi,

I want to make a macro which should convert multiple currencies into US dollar on the current date. I know we can use download tool to get it. However, I am finding difficulty in finding API address or URL address which we can put in formula tool. 

Any help would be appreciated! 

[Rahul_Analyst]

@Luke_C , thanks a lot! It resolved the issue. Can you share the link where I can learn about this type of date format?

[Luke_C]

Hi @Rahul_Analyst Take a look at this thread:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Convert-Epoch-time-to-actual-date-form...

[Theja_G]

Hi @Luke_C,

May i know how should i tweak the URL in the highlighted part controls the date to the current year?

[Luke_C]

Hi @Rahul_Analyst  You'd have to convert the date range you want to unix format (see above link) using a formula like this: datetimediff([_CurrentField_],'1970-01-01 00:00:00','seconds')

Then you'd substitute those in the URL for period1= and period2=

[Theja_G]

Thanks, @Luke_C.

[raj_kiran]

How to modify this URL to fetch for today's date?

[Luke_C]

Hi @raj_kiran  - you'd convert it the same way mentioned above. 

datetimediff(DateTimeNow(),'1970-01-01 00:00:00','seconds')