Google Sheet importxml登录访问 [英] Google Sheet importxml login access

问题描述

我已经使用importxml从网站获取公共信息.但是有时，当我们访问其他国家/地区时，信息会更改.例如 http://www.ebay.com/itm/221998403138?_trksid=p2057872.m2749.l2649&var=520870142881

I've used importxml to get public info from a website. But sometimes info changed when we access though different country. For example http://www.ebay.com/itm/221998403138?_trksid=p2057872.m2749.l2649&var=520870142881

该商品在美国不可用，但是当我们从卖家发货的其他国家/地区或更改发货国家/地区访问时，我们可以找到运费.如果我使用Google表格中的importxml，则表示访问国家将是美国.据我了解我无法更改Google表格的IP.因此，我想知道是否可以通过URL发送登录详细信息.这意味着我希望特定的Google表格通过我的登录详细信息(用户名和密码)访问URL.

this item is not available in USA but when we'll access from different country where seller shipped or changed the country of shipping, we can find the shipping cost. If I use importxml from Google Sheet, that means the access country will be USA. How far I understand i can't change the IP of Google Sheet. So I would like to know if is there any way to sent login detail though URL. That means I want to specific Google Sheet to access URL though my login details(username and password).

这样，运输成本将显示在xpath下.

So that shipping cost will appear under xpath.

//* [@ id ="fshippingCost"]/span [1]-卖家发货的非美国国家/地区

//* [@ id ="shSummary"]/span [1]-美国，无法送货

请参阅图片以进行澄清.

Please see the image for clarification.

http://prntscr.com/ad6fqi

推荐答案

IMPORTXML是Google表格的内置功能，该功能使用Google服务器进行匿名运行.如果您需要登录才能访问受限访问信息，则应该使用Google Apps Script之类的其他工具来创建网络应用.

IMPORTXML is a Google Sheets built-in function that use Google servers to be ran anonymously. If you need to use to sign in in order to get access to restricted access information you should use another thing like Google Apps Script to create a web app.

这篇关于Google Sheet importxml登录访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！