4 Replies Latest reply on Aug 18, 2015 3:49 AM by Yamini Nawlani

    Get all workbooks of a particular user

    Yamini Nawlani

      Hi, I want all the workbooks on the tableau server of a particular user(who is the owner of that workbook). I want to apply user filter on the server . Is there any way to do this apart from rest api?

        • 1. Re: Get all workbooks of a particular user
          Sankarmagesh Rajan

          Hi We can see dashboard owner name in tableau server.

          What you are going to do with workbooks.

          Thanks

          sankar

          • 2. Re: Get all workbooks of a particular user
            Yamini Nawlani

            Following are the things which is to be done:

            • Application is a asp.net application for immigration firms.
            • They want to provide ad-hoc functionality to the users.
            • Users can only do a ‘SaveAs’ from this template
            • Users will create multiple such reports on the server
            • To be able to retrieve the reports that they created, they would need a Tableau access

              Can we integrate Tableau in such a way that they can pass the control to tableau server environment with the permissions that user has on that particular project? They should be able to save / edit only within that environment. They should only see workbooks/ views that are owned by them.

            • 3. Re: Get all workbooks of a particular user
              Shankar Narayanan SGS

              Hi Yamini,

               

              From what i understand, you are trying to build a user portal which you want to access tableau server. On the user portal, users should be able to see only the reports that they are saving. There are multiple ways of doing this

               

              1. If all the users have license, you would not need to worry as the API will fetch in only the necessary worksheets and projects that the user is allowed.

              2. If there is only user having license to the tableau server (kind of like license user) which you use to access tableau from the portal, you would need to save the reports for each user in separate projects with their exact username as project name. Then you can pass the username in REST API to fetch reports only from that project.

               

              I hope this helps

               

              Shankar

              • 4. Re: Get all workbooks of a particular user
                Yamini Nawlani

                Thanks for the reply Shankar!

                 

                1. If all the users have license, you would not need to worry as the API will fetch in only the necessary worksheets and projects that the user is allowed. -

                We are giving adhoc functionality so we cannot set permissions, the workbooks saving will be dynamic.

                Which API you are talking about?

                2. If there is only user having license to the tableau server (kind of like license user) which you use to access tableau from the portal, you would need to save the reports for each user in separate projects with their exact username as project name. Then you can pass the username in REST API to fetch reports only from that project.

                Yes, using REST API it will work but client is not in favor of using it