Excel data from web not able to select JSON table data

Excel has a nice data connection from web feature. It allows you to select a table from the URL that will load the data into Excel automatically. The problem I'm having is the following URL http://mlb.mlb.com/mlb/fantasy/injuries/ the data must be loading via JSON (or similar) as Excel is not able to view the table in order to select it with the From Web data connection feature.

Any ideas?
intoxicated_curveballAsked:
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.

Ray PaseurCommented:
The referenced URL is an HTML document.  Most of the content is loaded via JavaScript.  This design is usually chosen to prevent unwanted theft of data via "web scraping" of licensed content.

Does the MLB site have an API that provides a formal interface to retrieve the data?  If so, we might be able to help you use that.
0
intoxicated_curveballAuthor Commented:
You're probably right, but of course just as you can copy and paste the data I am looking for a way to extra it into my Excel sheet.
0
Ray PaseurCommented:
Let's go back to this.  If you're going to do this with automation, you need something that is susceptible to automation.  Does the MLB site have an API that provides a formal interface to retrieve the data?  If so, we might be able to help you use that.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

intoxicated_curveballAuthor Commented:
There is nothing formal but I've found the JSON live data feed.
http://mlb.com/fantasylookup/json/named.wsfb_news_injury.bam

I'm now parsing this data via a server-side page which generates the Table of which I'm importing it into Excel.

I will except my solution as the solution.
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
Ray PaseurCommented:
Please be aware of this:
http://gdx.mlb.com/components/copyright.txt
The accounts, descriptions, data and presentation in the referring page (the "Materials") are proprietary content of MLB Advanced Media, L.P ("MLBAM").  
Only individual, non-commercial, non-bulk use of the Materials is permitted and any other use of the Materials is prohibited without prior written authorization from MLBAM.  
Authorized users of the Materials are prohibited from using the Materials in any commercial manner other than as expressly authorized by MLBAM.
0
intoxicated_curveballAuthor Commented:
I found a workable solution on my own.
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
Spreadsheets

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.