Knowledge Center

Knowledge Center > Finance > Mass Updater > Import Foreign Exchange Rates

Import Foreign Exchange Rates

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.

Column Required? Description

Group ID

Optional

ID of the group that the record belongs to. If a record with a Group ID fails, any subsequent records in that group will not be processed.

Type: string

Character limit: 255

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.

Last modified
21:08, 12 Jun 2016

Tags

Classifications

(not set)