When you use the tHttpClient/tRest/tRestClient component to pull Bloomberg numbers (URL ended with .csv extension) over API, the data is giving garbled characters.
Resolution
Using the proper operation tFileFetch component to download online application/csv file into a local temp folder firstly, and then combining with tFileInputDelimited to read data.
The job design should be: tFileFetch-->onSubjobok-->tFileInputDelimited-->Further processing
Cause
As the target source URL ends with .csv, it should be considered as a download operation for application/CSV type
Related Content
For more information about how to retrieve a file from an HTTP website and read data from the fetched file, please refer to this documentation
