?
Solved

IMPORTXML from jscript

Posted on 2014-10-16
10
Medium Priority
?
104 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
Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

 
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

The choice of selecting a perfect productive suite for one’s organization is a critical decision that an IT Manager or a CIO has to make. And when it comes to choosing a cloud-based productivity suite, the choice gets all the more difficult. This is…
: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
This Micro Tutorial will demonstrate using Google Doc how to import live data to another spreadsheet in Google Spreadsheets using the IMPORTRANGE function.
In this Experts Exchange video Micro Tutorial, I'm going to show how small business owners who use Google Apps can save money by setting up what is called a catch-all email address in their Gmail accounts. By using the catch-all feature, small busin…

762 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