[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Excel data from web not able to select JSON table data

Posted on 2014-08-19
6
Medium Priority
?
197 Views
Last Modified: 2014-08-26
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?
0
Comment
Question by:intoxicated_curveball
  • 3
  • 3
6 Comments
 
LVL 111

Expert Comment

by:Ray Paseur
ID: 40271231
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
 

Author Comment

by:intoxicated_curveball
ID: 40271305
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
 
LVL 111

Expert Comment

by:Ray Paseur
ID: 40271376
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Accepted Solution

by:
intoxicated_curveball earned 0 total points
ID: 40277241
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
 
LVL 111

Expert Comment

by:Ray Paseur
ID: 40278887
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
 

Author Closing Comment

by:intoxicated_curveball
ID: 40285200
I found a workable solution on my own.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will give core knowledge of JavaScript and will head in to your first JavaScript program. I am Durvesh Naik and I am here to deal with this series of JavaScript. I will teach you JavaScript in part wise , as its quite boring to read big…
This article discusses how to implement server side field validation and display customized error messages to the client.
Video by: Zack
Viewers will learn about various customizable options in Excel 2013.
Viewers will learn how to find and create templates in Excel 2013.

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question