How to read a .csv file in mulesoft

csv mule mule-studio mule-component
Hemant picture Hemant · Jan 4, 2016 · Viewed 12.7k times · Source

I am trying to read a csv file in mulesoft, can one tell me how to do that ? How to tell mulesoft which file to read ?

Answer

JoostD picture JoostD · Jan 7, 2016

Everyone is talking about transforming but you are asking how to read.

You will need the File connector, or FTP, SFTP or some SaaS applications maybe.

You can find an example of reading a CSV file with the File connector in Mule here:

https://www.mulesoft.com/exchange#!/importing-csv-into-mongodb

You will specify a path where Mule should poll for files, polling frequency and you can specify a pattern for which files Mule should look with a regex pattern.

https://docs.mulesoft.com/mule-user-guide/v/3.7/file-connector

Related questions

How to read huge CSV file in Mule

I'am using Mule Studio 3.4.0 Community Edition. I have a big problem about how to parse a large CSV file incoming with File Endpoint. The scenario is that I have 3 CSV files and I would putting the files'content into a database. …

Read More
How to concatenate text from multiple rows into a single text string in SQL server?

Consider a database table holding names, with three rows: Peter Paul Mary Is there an easy way to turn this into a single string of Peter, Paul, Mary?

Read More
Writing a pandas DataFrame to CSV file

I have a dataframe in pandas which I would like to write to a CSV file. I am doing this using: df.to_csv('out.csv') And getting the error: UnicodeEncodeError: 'ascii' codec can't encode character u'\u03b1' …

Read More