Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

API for currency exchange rate

Rahul_Analyst
9 - Comet

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! 

16 REPLIES 16
Rahul_Analyst
9 - Comet

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

Theja_G
6 - Meteoroid

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
17 - Castor

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
6 - Meteoroid

Thanks, @Luke_C.

raj_kiran
6 - Meteoroid

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

Luke_C
17 - Castor

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

 

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

 

Labels