function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

How to modify existing query to get CurrencyType.ConversionRate?

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?