我正在尝试使用Tableau提供的示例代码使用Tableau Rest API身份验证和生成受信任的令牌。我正在使用Python v2.7
以下是代码(与Tableau提供的样本相同) - :
try:
from urllib.request import urlopen, Request
except ImportError:
from urllib2 import urlopen, Request
import xml.etree.ElementTree as ET # For parsing XML responses
server_name = "http://dashboard.crgroup.com"
user_name = "abc"
password = "abc"
site_url_id = "default_site"
signin_url = "http://{server}/api/2.4/auth/signin".format(server=server_name)
request_xml = ET.Element('tsRequest')
credentials = ET.SubElement(request_xml, 'credentials',
name=user_name, password=password)
site_element = ET.SubElement(credentials, 'site',
contentUrl=site_url_id)
request_data = ET.tostring(request_xml)
req = Request(signin_url, data=request_data)
req = urlopen(req)
server_response = req.read()
response_xml = ET.fromstring(server_response)
token = response_xml.find('.//t:credentials',
namespaces={'t': "http://tableau.com/api"}).attrib['token']
site_id = response_xml.find('.//t:site',
namespaces={'t': "http://tableau.com/api"}).attrib['id']
print('Sign in successful!')
print('tToken: {token}'.format(token=token))
print('tSite ID: {site_id}'.format(site_id=site_id))
headers = {'X-tableau-auth': token}
signout_url = "http://{server}/api/2.4/auth/signout".format(server=server_name)
req = Request(signout_url, headers=headers, data=b'')
req = urlopen(req)
print('Sign out successful!')
但是我遇到了以下错误 - :
Traceback (most recent call last):
File "C:/Extract Api/testapi.py", line 42, in <module>
req = urlopen(req)
File "C:Python27liburllib2.py", line 154, in urlopen
return opener.open(url, data, timeout)
File "C:Python27liburllib2.py", line 429, in open
response = self._open(req, data)
File "C:Python27liburllib2.py", line 447, in _open
'_open', req)
File "C:Python27liburllib2.py", line 407, in _call_chain
result = func(*args)
File "C:Python27liburllib2.py", line 1228, in http_open
return self.do_open(httplib.HTTPConnection, req)
File "C:Python27liburllib2.py", line 1198, in do_open
raise URLError(err)
URLError: <urlopen error [Errno 11001] getaddrinfo failed>
我很肯定我正在使用正确的用户名/密码。另外,我可以使用浏览器访问URL。
请建议。
您的.format()
调用正在创建不良的URL。在python repl中测试这一点,我得到以下内容:
$ server_name = "http://dashboard.crgroup.com"
$ "http://{server}/api/2.4/auth/signin".format(server=server_name)
(output): 'http://http://dashboard.crgroup.com/api/2.4/auth/signin'
您需要从server_name
或从呼叫.format()
的字符串开头删除" http://"。<urlopen error [Errno 11001] getaddrinfo failed>
的错误使我陷入了这样一个事实,可能是一个URL问题,而不是Tableau问题。
它已解决。
i与API v2.4一起使用Tableau V10.0。我将API更改为版本2.3,并且可以使用。
感谢您的帮助。