Skip to main content

Import Foreign Exchange Rates

Zuora

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, 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

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.