XpathOnUrl on a Google page

Support
#1

Hello,
Thank you for this very nice tool. it's a fantastic idea to use this kind of function inside excel.
I have one difficulty with XpathOnUrl trying to grab the ticket price for one flight with Google.
I have tried several solutions and I always have an empty cell.

I would like to use :
=XPathOnUrl(N4;"//div[contains(@class,'AGUW54C-d-zb')]";HttpSettings(VRAI;;;"2000|6000|Host"))

with in N4 : https://www.google.fr/flights/#search;f=TLS;t=PMI;d=2016-04-05;r=2016-04-12;a=VY;s=0

Could you have a look on it and tell me what's wrong ?
Thks very much

#2

They build the page using javascript and fetch data from external services. Simple webscraping won't work on this page.

#3

In Google Shopping by eg, you can try a alternative with importxml... just adjust the code:

=IMPORTXML("https://www.google.fr/shopping/product/1477236448974417346?q=4690k&bav=on.2,or.&biw=1680&bih=949&tch=1&ech=1&psi=kHJUVc_mFIHjUPHCgZAG.1431597706129.3&prds=paur:ClkAsKraXyxz2p18-iAZ0wlnH3E10d8gt8CA-cTTdpSCp3d03w8Bqkw7NPCPK6oZ5aKxE4VVr5AcdkLaMPCr4JgOYmRdsAJGHj4Cv7tHHbYe6G730x75JdywTxIZAFPVH70c9-rchIPBkBga67fTSaxtCaGoUQ&ved=0CAQQpis&ei=kXJUVejgBYX1UJPRgegF";"//td[@class='os-total-col']")

1 Like
#4

Thanks for your help but it doesn't seem to work with importxml as well.