I need to develop a good/correct strategy in ASP.Net to read from 4 cascading data/api feeds using VB, and display them all in a single page.
The first feed contains a list of clients and their id numbers, the second feed contains a list of client locations and their id numbers, the third feed contains a list of assets/equipment, and the fourth feed contains additional info about the equipment. Each feed except for the first requires an id number, so if a client has 4 locations, then the locations feed has to be queried for each location id and so forth.
The URLs are pretty predictable, as are the XML responses. The URLs looks like this:
And for each asset found:
I've played around with repeaters and xmldatasources with success, but once you try nesting them 4 layers deep, things get messy.
My need is to report on the 4th level data, flagging and displaying items which are in need of attention so that the appropriate people can act on them.
Some things I've considered:
* Caching XML results to file system
* Caching XML data to database
* Creating a class diagram with tight bound field definitions and relationships
Caching the XML results seems like it would be easier because of the way that the xmldatasource works, but would be messy, having to cache quite a few different different files to represent the whole data set.
Both the database and class approaches use tight binding, and I have no control over fields in the returned dataset, so if they change their data (again) I would have to update the data models to match.
Can anybody recommend a clean approach to this?
Your thoughts would be appreciated!