ASP.Net: Need strategy to read from 4 cascading/related data/api feeds using VB.net, and display them all in a single page

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:

http://xyz.com/abc.php?action=list_clients
http://xyz.com/abc.php?action=list_locations&clientid=1
http://xyz.com/abc.php?action=list_assets&locationid=1000
http://xyz.com/abc.php?action=list_assets&locationid=1001
http://xyz.com/abc.php?action=list_assets&locationid=1002

And for each asset found:
http://xyz.com/abc.php?action=list_properties&assetid=2000
http://xyz.com/abc.php?action=list_properties&assetid=2001
http://xyz.com/abc.php?action=list_properties&assetid=2002
etc.

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!
LVL 3
Jon JaquesInformation TechnologistAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kyle SantosCustomer RelationsCommented:
Hi,

I am following up on your question.  Do you still need help?

If you solved the problem on your own, would you please post the solution here in case others have the same problem?

Regards,

Kyle Santos
Customer Relations
0
Jon JaquesInformation TechnologistAuthor Commented:
I finally resolved this on my own; what I discovered was that the customer only needed a once-daily report generated, and meanwhile the hosts of the API didn't want a ton of traffic, either, so I found it easiest to simple connect to each service, and then download its contents to a cache folder, where I was then able to process the data. Not the most elegant, but it works for now.
0
Jon JaquesInformation TechnologistAuthor Commented:
Cached all data, then processed XML files as needed.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Kyle SantosCustomer RelationsCommented:
Thank you for letting us know!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP.NET

From novice to tech pro — start learning today.