You need to sign in to do that
Don't have an account?
![Sailor67 Sailor67](https://dfc-org-production.my.site.com/img/userprofile/default_profile_45_v2.png)
How to modify existing query to get CurrencyType.ConversionRate?
Hi,
My project involves multiple currency feature and the ISO codes and conversion rates are stored in CurrencyType.
Via the API I am running the following query to retreive a data dump into an SQL:
SELECT Account.Name, Account.Owner.Name, ExpectedRevenue, CurrencyIsoCode, (SELECT PriceBookEntry.Product2.Name, TotalPrice, Description, CurrencyIsoCode FROM OpportunityLineItems) FROM Opportunity
So far it works fine, but I have failed in numereous ways to modify this query to also lookup CurrencyType.ConversionRate using the CurrencyIsoCode from Opportunity and OpportunityLineItem respectively..
I have checked the API documentation but I am unable to find a relation between CurrencyType and to any of the other common objects - what am I missing here?
thanks