Link to home
Start Free TrialLog in
Avatar of aideb
aideb

asked on

IMPORTXML from jscript

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?
Avatar of Randy Poole
Randy Poole
Flag of United States of America image

Can you post what you have so far, also is this page you are creating also on the same domain?
Avatar of aideb
aideb

ASKER

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
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 :)
Avatar of aideb

ASKER

Unfortunately it just gives me an error
can you attach your spreadsheet
Avatar of aideb

ASKER

as requested (note, I have exported from google docs)
I do not see an attachment..
Avatar of aideb

ASKER

I will try again!
Scraper.xlsx
ASKER CERTIFIED SOLUTION
Avatar of aideb
aideb

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of aideb

ASKER

No other comment was valid