Solved

IMPORTXML from jscript

Posted on 2014-10-16
10
84 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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Cloud file services can fill many different roles for your business. Often, the use of cloud file services begins with employees using consumer products, like Dropbox, to share files with customers and each other. While sync-and-share can be an effe…
: 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 importing calendar invites from events such as webinars into your Google Calendar.
This Micro Tutorial will demonstrate how to analyze your website's back links using a network graph powered by a fusion table.

860 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