python - 使用 Tableauserverclient python 和源用户名和密码刷新数据源

Question

我正在尝试使用 tableauserverclient 库来刷新 tableau server 中的提取数据源，我设法使用 tableau desktop CLI 来做到这一点，这个

./tableau refreshExtracts --server xxxxx --username xxxx --password xxxx --project xxxx --datasource xxxxx --source-username THIS_IS_IMPORTANT --source-password THIS_IS_IMPORTANT

没有--source-username --source-password它不起作用所以我想要做的是对 tableauserverclient 库做同样的事情。

我所做的是

def main():
    parser = argparse.ArgumentParser(description='Update a connection on a datasource or workbook to embed credentials')
    parser.add_argument('--server', '-s', required=True, help='server address')
    parser.add_argument('--username', '-u', required=True, help='username to sign into server')
    parser.add_argument('--site', '-S', default=None)
    parser.add_argument('-p', default=None)

    parser.add_argument('--logging-level', '-l', choices=['debug', 'info', 'error'], default='error',
                        help='desired logging level (set to error by default)')

    parser.add_argument('resource_type', choices=['workbook', 'datasource'])
    parser.add_argument('resource_id')
    parser.add_argument('connection_id')
    parser.add_argument('datasource_username')
    parser.add_argument('datasource_password')

    args = parser.parse_args()

    if args.p is None:
        password = getpass.getpass("Password: ")
    else:
        password = args.p

    # Set logging level based on user input, or error by default
    logging_level = getattr(logging, args.logging_level.upper())
    logging.basicConfig(level=logging_level)

    # SIGN IN
    tableau_auth = TSC.TableauAuth(args.username, args.password, args.site)
    server = TSC.Server(args.server, use_server_version=True)

    with server.auth.sign_in(tableau_auth):
        endpoint = server.datasources
        update_function = endpoint.update_connection
        resource = endpoint.get_by_id(args.resource_id)
        endpoint.populate_connections(resource)
        connections = list(filter(lambda x: x.id == args.connection_id, resource.connections))
        connection = connections[0]
        connection.username = args.datasource_username
        connection.password = args.datasource_password
        connection.embed_password = True
        print(update_function(resource, connection).content)

        resource = server.datasources.get_by_id('xxxxxxxx-xxxxx-xxxx-xxxx-xxxxxx')
        results = server.datasources.refresh(resource)

但它仍然没有使用我提供的嵌入式用户名和密码。

当我转到服务器中的作业选项卡时，作业状态失败{用户“私人网络用户”登录失败。集成身份验证失败}

有什么帮助吗？

标签： pythontableau-api