JSON to CSV with Mirth
JSON to CSV to Excel for Data Analysis...
I had a huge JSON that contained detailed provider data; however, I only needed each provider's last name and NPI. Realizing our proprietary system didn't allow me to run a report to export this simple provider data, I quickly thought of my favorite engine - Mirth Connect! It was pretty easy to do - especially when I used the Mirth Iterator. It just took me 20 minutes :-)
- You will need Mirth Connect 3.5.2 or above to follow along with this lesson.
- I hope this lesson helps you understand that you can use Mirth for so many things!
- You will learn to install the free Mirth Connect engine.
- You will transform JSON to CSV then open with Excel.
The json to csv solution is all done for you...just follow along, play, and do the bonus!
Enroll now. See you inside :-)