#Print0 utenti parlano di questo argomento

@Bhavana Khairnar​ 

Hi, in this case you can use:

import tableauserverclient as TSC
import csv
 
tableau_auth = TSC.PersonalAccessTokenAuth('TOKEN_NAME', 'TOKEN_VALUE', 'SITENAME')
server = TSC.Server('https://SERVER_URL', use_server_version=True)
 
#Create the csv file and open it in write mode
f = open('usuarios.csv', 'w', encoding='UTF8', newline='')
 
#delimiter with semicolon if needed change to comma
writer = csv.writer(f, delimiter=";")
 
#write the header
header = ['User','Site Role','Last Login']
writer.writerow(header)
 
#tableau_auth = TSC.PersonalAccessTokenAuth('TOKEN_NAME', 'TOKEN_VALUE', 'SITENAME')
#server = TSC.Server('https://SERVER_URL', use_server_version=True)
with server.auth.sign_in(tableau_auth):
    # get specified the group
    req_option = TSC.RequestOptions()
    req_option.filter.add(TSC.Filter(TSC.RequestOptions.Field.Name,
                                 TSC.RequestOptions.Operator.Equals,
                                 'Modux'))
    all_groups, pagination_item = server.groups.get(req_option)
    mygroup = all_groups[0]
    print(mygroup.name,mygroup.id)
    #print(mygroup[0])
    # get user information from the group
    pagination_item = server.groups.populate_users(mygroup)
    # print the names of the users
    for user in mygroup.users:
#        if user.last_login is None:
            row=[user.name,user.site_role,user.last_login]
            print(user.name, user.site_role, user.last_login)
            #write the row
            writer.writerow(row)
#Close file connection
f.close()
#Don't forget to sign out
server.auth.sign_out()

If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.

Regards,

Diego

Tableau Ambassador

@Hafiz Naim Bin Sahidi​ 

Hi, use the following code to run flows on Tableau Server:

####
# This script demonstrates how to use the Tableau Server Client
# to run the flow
#
# For signing into server, this script uses personal access tokens. For
# more information on personal access tokens, refer to the documentations:
# (https://help.tableau.com/current/server/en-us/security_personal_access_tokens.htm)
#
# If you don't know the flow name, the script list the flows name. If you need the list
# of flows, just enter any name in the flow parameter
#
# To run the script, you must have installed Python 3.5 or later.
####
import argparse
import logging
import tableauserverclient as TSC
def main():
    parser = argparse.ArgumentParser(description='Publish a datasource to server.')
    parser.add_argument('--server', '-s', required=True, help='server address')
    parser.add_argument('--site', '-i', help='site name')
    parser.add_argument('--token-name', '-p', required=True,
                        help='name of the personal access token used to sign into the server')
    parser.add_argument('--token-value', '-v', required=True,
                        help='value of the personal access token used to sign into the server')
    parser.add_argument('--flow-name', '-f', required=True,
                        help='The name of the flow')
    args = parser.parse_args()
    # Sign in to server
    tableau_auth = TSC.PersonalAccessTokenAuth(args.token_name, args.token_value, site_id=args.site)
    server = TSC.Server(args.server, use_server_version=True)
    with server.auth.sign_in(tableau_auth):
        all_flow_items, pagination_item = server.flows.get()
        print("There are {} flows on site:" .format(pagination_item.total_available))
        print([[flow.id, flow.name] for flow in all_flow_items])
        for flow in all_flow_items:
            if flow.name == args.flow_name:
                print('Run Flow', flow.name, 'Now')
                # run the flow and get the JobItem
                job = server.flows.refresh(flow)
    print("Thanks for using this python script by www.modux.co")
if __name__ == '__main__':
    main()

We can modify this flow to not use args:

####
# This script demonstrates how to use the Tableau Server Client
# to run the flow
#
# For signing into server, this script could use personal access tokens. For
# more information on personal access tokens, refer to the documentations:
# (https://help.tableau.com/current/server/en-us/security_personal_access_tokens.htm)
#
# If you don't know the flow name, the script list the flows name. If you need the list
# of flows, just enter any name in the flow parameter
#
# To run the script, you must have installed Python 3.5 or later.
####
 
import tableauserverclient as TSC
 
 
def main():
    SERVER = "www.yourserver.com"
    #Use "" for default site
    SITE = ""
    USER = "youruser"
    PWD = "yourpassword"
    FLOW_NAME = "Your Flow Name"
    #Use the following for PAT Sign in
    #TOKEN_NAME = ""
    #TOKEN_VALUE = "" 
 
    # Sign in to server with PAT
    #tableau_auth = TSC.PersonalAccessTokenAuth(TOKEN_NAME, TOKEN_VALUE, site_id=SITE)
    # Sign in to server with USER/PWD
    tableau_auth = TSC.TableauAuth(USER, PWD)
    server = TSC.Server(SERVER, use_server_version=True)
    with server.auth.sign_in(tableau_auth):
        all_flow_items, pagination_item = server.flows.get()
        #print("There are {} flows on site:" .format(pagination_item.total_available))
        #print([[flow.id, flow.name] for flow in all_flow_items])
        for flow in all_flow_items:
            if flow.name == FLOW_NAME:
                print('Run Flow', flow.name, 'Now')
                # run the flow and get the JobItem
                job = server.flows.refresh(flow)
    print("Thanks for using this python script by www.modux.co")
 
if __name__ == '__main__':
    main()

If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.

Regards,

Diego Martinez

Tableau Visionary and Forums Ambassador

Hi Bhavana,

You only want to use Postman for testing; it is not a tool for production work. I have used the REST api natively, but if you can use the TSC Python library you definitely should!

Using the Python library is quite simple.

If you want to remove all unlicensed users this should work:

import tableauserverclient as TSC

tableau_auth = TSC.TableauAuth('USER', 'PASSWORD')

server = TSC.Server('SERVER')

with server.auth.sign_in(tableau_auth):

  all_users, pagination_item = server.users.get()

   for user in all_users:

        print(user.name)

        print(user.site_role)

        if (user.site_role == 'Unlicensed'):

             print(user.id)

             server.users.remove(user.id)

             print("user deleted") 

This is dangerous - so make sure to test it and make backups!

Kind regards

Johan de Groot

Hi @Abdullah Noor​ ,

You can reference the documentation here: https://tableau.github.io/server-client-python/docs/page-through-results

The default page size 100, but you can expand this or use a different method to grab all workbooks.

It may be worth making a new post as well! :)

Best,

Bryce

Hi Neha,

In your Python code you'd need to turn the data frame into a string of numbers (and potentially text) with defined separators, maybe something like:

1.0~23~~3.14~~~red

Then you'd need a set of N calculations (four in this example) to get each value, here's a screenshot:

As noted in the comment the formula is more complicated because (as of at least Tableau v2018.3) SPLIT, FINDNTH, and REGEX_EXTRACT_NTH aren't supported by table calculations (and the SCRIPT functions that Python is executed in are table calculations), vote up if you'd like to get that.

Note that if the Python script is returning a changing number of variables in each run there's no automatic way to parse out into a variable number of calculated fields - you'll need to build as many calculations as you expect to have variables.

I've attached a v10.5 workbook I used to make the screenshot above.

Jonathan

PS: I know this is really painful, I had a conversation with a Tableau developer last month and I know they are looking into this. I'll also forward this thread as an example.

Hi,

I updated our Samples for the Metadata API with a sample using TSC: metadata-api-samples/metadata-api-with-python-and-TSC.py at master · tableau/metadata-api-samples · GitHub

I hope it is helpful,

Gigi

Hey everyone,

Enable Ask Data for Data Sources - Tableau

This throttle is limited to the data source. However, we are actively working on the broader enable/disable settings (at the server and site level). I will share an update in a few weeks but we are targeting 2019.4 with this added capability.

Thanks,

Ruhaab Markas

Sr. Product Manager - Ask Data

@Serkan Arslan​ 

Hi, in this case you may use Tableau Server Client:

import tableauserverclient as TSC
import csv
 
# server admin creds
HOST = "https://prod-useast-b.online.tableau.com/"
TOKEN_NAME = "Test"
TOKEN_VALUE = "cjcvCg==:45pE9"
CONTENT_URL = "yoursite"
 
tableau_auth = TSC.PersonalAccessTokenAuth(TOKEN_NAME, TOKEN_VALUE, site_id=CONTENT_URL)
server = TSC.Server(HOST, use_server_version=True)
 
 
#Create the csv file and open it in write mode
f = open('views.csv', 'w', encoding='UTF8', newline='')
 
#delimiter with semicolon if need change to comma, and write header
writer = csv.writer(f, delimiter=";")
header = ['content URL','name','Owner_id','total_views']
writer.writerow(header)
 
today_date = datetime.now(timezone.utc)
 
with server.auth.sign_in(tableau_auth):
    for view in TSC.Pager(server.views,usage=True):
        row=[view.content_url,view.name,view.owner_id,view.total_views]
        #print(view.conten_url,view.name,view.owner_id,view.total_views)
        #write the row
        writer.writerow(row)
#Close file connection and sign out
f.close()
server.auth.sign_out()

To use this code, you will need a PAT:

https://help.tableau.com/current/pro/desktop/en-us/useracct.htm#create-a-personal-access-token

If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.

Regards,

Diego Martinez

Tableau Visionary and Forums Ambassador