web query and javascript created table

[jaekma]

This is a long shot I'm sure but i'm writing a query for a website that places the table content via javascript. so if i go the page the data isnt there until you fill out the form.

Anyway. I got the url that will work with the parameters i need but excel will not import the javascript table. even though when i past the created URL in the browser it pulls it up fine.

The project:
I have a list of cities with their latitudes and longitudes. I am using these as parameters to search the website:

[URL]http://windspeed.atcouncil.org/[/URL]

for example:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]City, State[/TD]
[TD="align: center"]Zip[/TD]
[TD="align: center"]Latitude[/TD]
[TD="align: center"]Longitude[/TD]
[/TR]
[TR]
[TD]Abingdon, MD[/TD]
[TD]21010[/TD]
[TD]39.4622357[/TD]
[TD]-76.2772223[/TD]
[/TR]
</tbody>[/TABLE]

I am using the following URL for the query:

http://windspeed.atcouncil.org/domains/atcwindspeed/process/index.php?option=com_content&view=article&id=10&dec=1&latt=[B][][/B]&longt=[B][][/B]&risk_category_i=rc1&risk_category_ii=rc2&risk_category_iii=rc3&mir10&mri25&mri50&mri100&asce705&asce793&zoom=4&maptype=none

This works when i sent the proper parameters and post it in the browser but when i use it in a query in excel it wont import the javascript created data.

Is there a way to tell excel to import the javascript created table as well?

 

[crewaustin66]

You might consider having a second parameter to tell the output to be plain text with tab delimited data. Give that shot and see if it pulls in like you need.