Solved

IMPORTXML from jscript

Posted on 2014-10-16
10
86 Views
Last Modified: 2014-11-12
I am trying to use IMPORTXML to read in some values from this page

https://www.fundingcircle.com/loans/44801/auction

I am looking to collect the 'time left' as displayed on the page which is
attr('data-close-date');
within the jscript

Can anyone help?
0
Comment
Question by:aideb
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 4
10 Comments
 
LVL 21

Expert Comment

by:Randy Poole
ID: 40383956
Can you post what you have so far, also is this page you are creating also on the same domain?
0
 
LVL 2

Author Comment

by:aideb
ID: 40383959
Ah, sorry. I am doing this in a spreadsheet....

URL      https://www.fundingcircle.com/loans/43037/auction
XPATH      //tr

And then doing IMPORTXML(URL,XPATH)

I cannot get the correct XPATH to get the data I am looking for
0
 
LVL 21

Expert Comment

by:Randy Poole
ID: 40383963
the xpath for what you are trying to do would be
//div[@data-close-date]

Open in new window

but I am not sure the page will resolve correctly.  But you can try it :)
0
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
LVL 2

Author Comment

by:aideb
ID: 40383978
Unfortunately it just gives me an error
0
 
LVL 21

Expert Comment

by:Randy Poole
ID: 40384283
can you attach your spreadsheet
0
 
LVL 2

Author Comment

by:aideb
ID: 40384388
as requested (note, I have exported from google docs)
0
 
LVL 21

Expert Comment

by:Randy Poole
ID: 40384434
I do not see an attachment..
0
 
LVL 2

Author Comment

by:aideb
ID: 40384617
I will try again!
Scraper.xlsx
0
 
LVL 2

Accepted Solution

by:
aideb earned 0 total points
ID: 40391912
I decided to use IMPORTHTML instead and hide the columns I didn't need.
0
 
LVL 2

Author Closing Comment

by:aideb
ID: 40403708
No other comment was valid
0

Featured Post

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

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

Learn new improvements released by Google for Google Calendar. Noted in this article are simple tips and tricks that can make your everyday use of Google Calendar better.
Whether you’re looking to gather data for research or gather feedback on an idea, being able to build and distribute your own online survey is not only cost-effective, but allows you to reach a larger audience and receive results in real-time. Googl…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Shows how to create a shortcut to site-search Experts Exchange using Google in the Chrome browser. This eliminates the need to type out site:experts-exchange.com whenever you want to search the site. Launch the Search Engine Menu: In chrome, via you…

738 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