Solved

IMPORTXML from jscript

Posted on 2014-10-16
10
80 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
  • 6
  • 4
10 Comments
 
LVL 21

Expert Comment

by:Randy Poole
Comment Utility
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
Comment Utility
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
Comment Utility
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
 
LVL 2

Author Comment

by:aideb
Comment Utility
Unfortunately it just gives me an error
0
 
LVL 21

Expert Comment

by:Randy Poole
Comment Utility
can you attach your spreadsheet
0
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
LVL 2

Author Comment

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

Expert Comment

by:Randy Poole
Comment Utility
I do not see an attachment..
0
 
LVL 2

Author Comment

by:aideb
Comment Utility
I will try again!
Scraper.xlsx
0
 
LVL 2

Accepted Solution

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

Author Closing Comment

by:aideb
Comment Utility
No other comment was valid
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
I'm Dumb-phoned(ed) Last week, I noticed this message when adding events to my Google Calendar: On June 27th (2015), Google is removing SMS as a notification option for Google Calendar events.  Their assumption is that enough people have smart p…
This Micro Tutorial will demonstrate how to analyze your website's back links using a network graph powered by a fusion table.
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…

744 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now