Learn R Programming

vvtableau

The vvtableau package is an R interface for interacting with Tableau Server using the Tableau REST API. It provides a convenient way to automate Tableau tasks, such as publishing workbooks, refreshing data extracts, managing users and groups, and retrieving information about server objects directly from R. Additionally, it includes functions to download filtered views, workbooks, and export them to different formats like PDF and PowerPoint.

Furthermore, methods are included to interact with Tableau desktop. These methods allow you to retrieve information from workbooks and to change them.

Features

To see which functions are available in which section based on the Tableau REST API, helper functions, and functions that work with local Tableau workbooks using XML structure, please refer to the reference page of the vvtableau package. The reference page provides a comprehensive list of functions available in the package, organized by category.

Additionally, the package includes vignettes that provide more detailed information on how to use the functions in the package.

Installation

You can install the tableauR package from GitHub using the devtools package:

devtools::install_github("vusaverse/vvtableau")
library(vvtableau)

The package is also available on CRAN:

install.packages("vvtableau")
library(vvtableau)

Contributing

Contributions to vvtableau are welcome! If you encounter any bugs, have feature requests, or would like to contribute code improvements, please open an issue or submit a pull request on the GitHub repository.

Copy Link

Version

Install

install.packages('vvtableau')

Monthly Downloads

195

Version

0.7.0

License

MIT + file LICENSE

Issues

Pull Requests

Stars

Forks

Maintainer

Tomer Iwan

Last Published

August 29th, 2024

Functions in vvtableau (0.7.0)

download_workbooks_server_pdf

Download workbook PDF from Tableau Server.
get_nodenames

Get all nodenames
get_hierarchy

Get Workbook drilldown hierarchies
get_mobile_security_settings

Get mobile security settings for the server using Tableau REST API.
get_server_groups

Get groups from Tableau Server.
get_server_datasources

Get datasources from Tableau Server.
get_revision

Get the revision number
get_server_connected_apps

Get connected applications from Tableau Server.
get_parameter

Get all parameters in workbook.
get_server_users

Get users from Tableau server.
get_server_user_favorites

Get favorites for a user from Tableau Server.
get_server_location

Get the server location.
get_server_projects

Get projects from Tableau server.
get_server_views

Get views from Tableau server.
get_variables

Get variable names from workbook.
get_workbook_id

Get workbook ID name.
get_server_workbooks

Get workbooks from Tableau server.
get_table_assets

Get table assets from Tableau Server.
get_tableau_data_source

Get Tableau data source
get_server_info

Get datasources from Tableau Server.
remove_user_from_group

Remove User from Group
get_folders

Get folder structure workbook
get_server_jobs

Get server jobs from Tableau server.
download_datasource

Download a data source in .tdsx format using Tableau REST API and save it as a file.
get_groups_for_user

Get Groups for a User
row_to_query

Dataframe row to query
%>%

Pipe operator
make_rootnodes

make_rootnodes
query_user_on_site

Query User On Site
get_users_in_group

Get Users in Group
get_variable_folders

Get folder names
update_workbook_now

Update Workbook Now
update_user

Update User
get_server_schedules

Get schedules from Tableau server.
get_server_refresh_tasks

Get extract refresh tasks from Tableau Server.
tableau_password

Get the Tableau password from the environment variable
run_extract_refresh_task

Run Extract Refresh Task
tableau_pat_name

Get the Tableau PAT name from the environment variable
get_workbook_tabs

Get workbook tabs
get_workbook_urls

Get Workbook URLs
tableau_pat_secret

Get the Tableau PAT secret from the environment variable
remove_user_from_site

Remove User from Site
tableau_base_url

Get the Tableau base URL from the environment variable
tableau_content_url

Get the Tableau content URL from the environment variable
row_to_name

Concat row to name
update_group

Update Group
update_data_source_now

Update Data Source Now
tableau_username

Get the Tableau username from the environment variable
add_user_to_group

Add User to Group
adjust_tableau_font_style

adjust_tableau_font_style
check_dashboard_names

check_dashboard_names
add_tags_to_view

Add tags to a view in Tableau Server.
add_tags_to_workbook

Add tags to a workbook in Tableau Server.
authenticate_PAT

Authenticate to Tableau Server or Tableau Cloud
create_group

Create Group
download_filtered_tableau_image

Download filtered Tableau views to PNG images from a dataframe.
authenticate_server

Authenticate on the Tableau server.
add_user_to_site

Add User to Site
delete_group

Delete Group
escape_special_chars

Escape characters for url
adjust_tableau_size

adjust_tableau_size
download_tableau_data

Download Tableau view data as Excel
get_actions

Get Workbook actions
download_workbooks_server

Download workbook from Tableau Server.
download_tableau_crosstab_excel

Download Tableau view crosstab as Excel
download_workbooks_server_powerpoint

Download workbook PowerPoint from Tableau Server.