server-client-python/samples/create_extract_task.py at development · tableau/server-client-python · GitHub

History

89 lines (73 loc) · 2.83 KB

Raw

####

# This script demonstrates how to create extract tasks in Tableau Cloud

# using the Tableau Server Client.

# To run the script, you must have installed Python 3.7 or later.

####

import argparse

import logging

from datetime import time

import tableauserverclient as TSC

def main():

parser = argparse.ArgumentParser(description="Creates sample extract refresh task.")

# Common options; please keep those in sync across all samples

parser.add_argument("--server", "-s", help="server address")

parser.add_argument("--site", "-S", help="site name")

parser.add_argument("--token-name", "-p", help="name of the personal access token used to sign into the server")

parser.add_argument("--token-value", "-v", help="value of the personal access token used to sign into the server")

parser.add_argument(

"--logging-level",

"-l",

choices=["debug", "info", "error"],

default="error",

help="desired logging level (set to error by default)",

)

# Options specific to this sample:

parser.add_argument("resource_type", choices=["workbook", "datasource"])

parser.add_argument("resource_id")

parser.add_argument("--incremental", default=False)

args = parser.parse_args()

# Set logging level based on user input, or error by default

logging_level = getattr(logging, args.logging_level.upper())

logging.basicConfig(level=logging_level)

tableau_auth = TSC.PersonalAccessTokenAuth(args.token_name, args.token_value, site_id=args.site)

server = TSC.Server(args.server, use_server_version=False)

server.add_http_options({"verify": False})

server.use_server_version()

with server.auth.sign_in(tableau_auth):

# Monthly Schedule

# This schedule will run on the 15th of every month at 11:30PM

monthly_interval = TSC.MonthlyInterval(start_time=time(23, 30), interval_value=15)

print(monthly_interval)

monthly_schedule = TSC.ScheduleItem(

None,

monthly_interval,

)

my_workbook: TSC.WorkbookItem = server.workbooks.get_by_id(args.resource_id)

target_item = TSC.Target(

my_workbook.id, # the id of the workbook or datasource

"workbook", # alternatively can be "datasource"

)

refresh_type = "FullRefresh"

if args.incremental:

refresh_type = "Incremental"

scheduled_extract_item = TSC.TaskItem(

None,

refresh_type,

None,

monthly_schedule,

None,

target_item,

)

try:

response = server.tasks.create(scheduled_extract_item)

print(response)

except Exception as e:

print(e)

if __name__ == "__main__":

main()

server-client-python/samples/create_extract_task.py at development · tableau/server-client-python · GitHub

Uh oh!

Expand file tree

Breadcrumbs

create_extract_task.py

Latest commit

History

Breadcrumbs

create_extract_task.py

File metadata and controls