Post

2 followers Follow
0
Avatar

Rest API and the exchange rate

Question from customer: We have created some external reports that use our Clarizen data via the REST API. It would be helpful if there was a way that I could get the exchange rate for our organization given currency (and date) - is that possible?

Bea Genthner Answered

Please sign in to leave a comment.

1 comment

1
Avatar

Hi Bea,

Try this:

select BaseCurrency, QuoteCurrency, ExchangeRate, EffectiveFrom from CurrencyExchangeRate

(Obviously this gives you all exchange rates, so you'll have to filter it for your currency and date but these are the basic query and fields to use)

Hope this helps,

Ophir

Ophir Kenig 1 vote
Comment actions Permalink