Solved

IMPORTXML from jscript

Posted on 2014-10-16
10
83 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
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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
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

ScreenConnect 6.0 Free Trial

At ScreenConnect, partner feedback doesn't fall on deaf ears. We collected partner suggestions off of their virtual wish list and transformed them into one game-changing release: ScreenConnect 6.0. Explore all of the extras and enhancements for yourself!

Question has a verified solution.

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

Suggested Solutions

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.
If your app took Google’s lash recently, here are the 5 most likely reasons.
This Micro Tutorial demonstrates how to create custom reports and the secrets of determine the metrics and dimensions for your data that works best with your needs.
By using UNIQUE function in Google Sheets, you can get around removing duplicates like in Microsoft Excel.

831 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