So I am having some issue's in pulling the table data from www.nextgenstats.nfl.com.
I have tried the HTMLTable reader, and I keep receiving an error message when trying to connect to it. Any suggestions would be great!
LizAtSafe wrote:
Hi @jasonberneathy what error message are you recieving?
I keep recieving a "Failed to retrieve feature types." Error...
With the following listed in the log.
HTML Table Reader: Could not open HTML file 'https://nextgenstats.nfl.com/stats/passing#yards' for reading. ' ' : 'No such file or directory'
followed by:
Failed to obtain any schemas from reader 'HTMLTABLE' from 1 dataset. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information.
+8- Contributor
If you just need the data for one time a workaround for you could be the following. The Table is accessible in the console /inspector of your browser (i used firefox for this try). I got the information you needed by going to the options - developer - inspector. Then go to the section you want and right click on it and choose edit as html and save the text. After this you can parse the data in FME and get it back into the same structure.
https://developer.mozilla.org/nl/docs/Tools/Page_Inspector/How_to/Open_the_Inspector
jeroen wrote:
If you just need the data for one time a workaround for you could be the following. The Table is accessible in the console /inspector of your browser (i used firefox for this try). I got the information you needed by going to the options - developer - inspector. Then go to the section you want and right click on it and choose edit as html and save the text. After this you can parse the data in FME and get it back into the same structure.
https://developer.mozilla.org/nl/docs/Tools/Page_Inspector/How_to/Open_the_Inspector
+12- Safer
LizAtSafe wrote:
Hi @jasonberneathy what error message are you recieving?
+43- Safer
steveatsafe wrote:
I had a look at the URL also...same error. Seems it isn't finding any Tables. I always thought this only worked with static content but I see reviewing the help that it should work with content that is created on the fly.
mark2atsafe wrote:
Although I'm not sure if it would raise that error message, is it actually a HTML "table" the web page is creating? Or are they creating something that looks like a table, but isn't a HTML table tag?
jasonberneathy wrote:
It appears to be pulling the data from json. However I am unaware of how to access it remotely with FME.
Then in FME use JSON reader, put the JSON link for JSON source dataset, then Schema Scan mode to JSON Query, and add one Feature Type 'json_featuretype' with Query 'json["stats"][*]'
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.