function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Sailor67Sailor67 

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