How to connect to MySQL table and transform it to JSON using MuleSoft?

How to connect to MySQL table and transform it to JSON using MuleSoft?

1. Create a simple project as below.

2. Listener Configuration is below

3. Select configuration.

Note:
a. Download MySQL connector – https://dev.mysql.com/downloads/connector/j/.
b. Select Local file and add it.
c. The password is also mule.

4. Transform Configuration.

a. Create a json file with the below.

  1. [  
  2. {  
  3.     “ID”:1,  
  4.     “code1”:“test1”,  
  5.     “code2”:“testing1”,  
  6.     “airlineName”:“testing1”,  
  7.     “toAirport”:“testing1”,  
  8.     “fromAirport”:“testing1”,  
  9.     “takeOffDate”:“2011/11/11”,  
  10.     “price”:100,  
  11.     “planeType”:“testing1”,  
  12.     “setatsAvailable”:10,  
  13.     “totalSeats”:250  
  14. },  
  15. {  
  16.     “ID”:2,  
  17.     “code1”:“test”,  
  18.     “code2”:“testing”,  
  19.     “airlineName”:“testing”,  
  20.     “toAirport”:“testing”,  
  21.     “fromAirport”:“testing”,  
  22.     “takeOffDate”:“2010/10/10”,  
  23.     “price”:100,  
  24.     “planeType”:“testing”,  
  25.     “setatsAvailable”:10,  
  26.     “totalSeats”:250  
  27. }  
  28. ]  

b. While adding metadata type, use the json file created in above step.

c. Drag and drop to match.

5. Logger Configuration.

6. Run the application.

Output:

Open http://localhost:8081/db in the browser to view the result from the table

Leave a Reply