I have an XML feed (AppDynamics API) which has an auth method (so username@customer:password format) which I want to access. I would like the XML to be parsed, preferably in XML, to extract / 'grep' certain fields of the XML response out to file, preferably db.
So far my solution would be some sort of XML parser for XML which would then feed it into Redis/MySQL, and from there it would be read from the webpage.
- What is the best way to parse XML using Ruby?
- What is the ideal db to use in the backend that the app will be writing/reading from?
- Best method of a HTML/CSS framework with tables to include this data?
Basically AppDynamics is a monitoring solution, we are building a custom dashboard, in this dashboard is various tables and I would like to insert data pulled from the API which is then read into the webpage.
I hope this helps, first time poster, long time reader!