0

I'm trying to get an updating list from a store on Taobao.com

I've tried using importxml to get the list using xpath but I keep getting "import content is empty" error.

=IMPORTXML("https://shop521102007.taobao.com/search.htm?spm=a1z10.3-c.w4002-15256547076.38.642a5bedkKxVvf&_ksTS=1564798664490_1704&callback=jsonp1705&mid=w-15256547076-0&wid=15256547076&path=%2Fsearch.htm&search=y&viewType=list","//*[@id='J_ShopSearchResult']/div/div[2]/div[2]/ul/li[3]")

I think the issue is that the xpath is not from the original source, but I don't know how to find the original source and I'd prefer to find a way around it so I don't have to keep updating things manually.

Any ideas on what I am doing wrong?

| | | | | |
  • I think that your best bet is to look if the referred site offers an API, if so, you could use Google Apps Script of the Google Sheets API to send data to Google Sheets. – Rubén Aug 3 '19 at 14:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.