Happy Business Starts Here

Highlighted
Zuora Staff

How do I import Custom Foreign Exchange Rates via REST API?

Problem:

 

I've been getting the error when uploading via endpoint: https://apisandbox-api.zuora.com/rest/v1/bulk?actionType=ImportFXRate

 

Error:

 

{ "success" : false, "processId" : "B30180B83EC12345", "reasons" : [ { "code" : 57040000, "message" : "org.apache.catalina.connector.RequestFacade cannot be cast to org.springframework.web.multipart.MultipartHttpServletRequest" } ] }


If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

1 REPLY 1
Zuora Staff

Re: How do I import Custom Foreign Exchange Rates via REST API?

Solution:

 

1, First, please check with Zuora Support to see whether tenant level permission of Custom Foreign Currency is enabled.

 

2, If enabled, please check csv format against attachment "TEST.csv". Note that the date format must be "YYYY-MM-DD"

 

3, REST call via CURL to upload the csv file:

 

curl -H "apiAccessKeyId:USERNAME" -H "apiSecretAccessKey:PASSWORD" -H "Accept:application/json" --form "file=@TEST.csv" --form "params={actionType:ImportFXRate}" -X POST https://apisandbox-api.zuora.com/rest/v1/bulk

4, Upload should be successful. If not, in the UI, please go to "Finance" > "Mass Updater", there in the dropdown box "Mass Action to Perform", select "Import Foreign Exchange Rates". Then under the column "Response File", you will be able to download the result file with better error messages for troubleshooting.

 

 

Reference:

https://knowledgecenter.zuora.com/DC_Developers/C_REST_API/B_REST_API_reference/Mass_Updater/A_Perfo...

https://knowledgecenter.zuora.com/CC_Finance/Mass_Updater/Import_Foreign_Exchange_Rates

 



If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √