Import Foreign Exchange Rates

Last updated
Save as PDF

The Upload Foreign Exchange Rates mass action allows you to bulk upload custom foreign currency exchange rates through the Mass Updater. This article describes the columns supported in the upload file and the columns added to the response file.

See Foreign Currency Conversion for using custom foreign exchanges rates in Zuora.

See Get Custom Foreign Currency Exchange Rates for using the REST API to query exchanges rates uploaded with this mass action.

Upload File Columns

The following table describes the columns supported in the upload file.

To enable the Exchange Rate Set option, submit a request at Zuora Global Support.

Type: string

Column	Required?	Description
Group ID	Optional	ID of the group that the record belongs to. If a record with a Group ID fails, all the following records with the same Group ID will be skipped and marked with an error message “A previous row with the same Group ID failed”. If no Group ID is provided in the uploaded file, all the records are processed independently. So, if one record fails during the processing, other records will still be processed. Type: string Character limit: 255
Rate Set Name	Optional	The name of the exchange rate to use.
Provider Exchange Rate Date	Required	The date of the exchange rate to use. Must be in the "YYYY-MM-DD" format, e.g. 2016-02-16. Type: date
Currency (From)	Required	The source currency. Must be value of supported currency code, e.g. USD or CNY. Type: enum Character limit: 3
Currency (To)	Required	The target currency. Must be value of supported currency code, e.g. USD or CNY. Type: enum Character limit: 3
Exchange Rate	Required	The exchange rate used to convert the Currency (From) to Currency (To). Must be a number, cannot put a formatted amount, for example '($100)' or '100,000.50'. Type: decimal

Response File Columns

The following table describes the columns added to the response file.

Column	Description
Success	Returns `Y` if the record was successful. Returns `N` if the record failed. Remains blank if the record was not processed.
Error Message	Displays a brief description of the error if the record failed.