how to create tableau extract using talend 6.4

[Anonymous]

how to create tableau extract using talend 6.4.

[vapukov]

You can not create Tableau Extract (or report) with Talend

but You can create Tableau Report with Tableau Desktop, publish it on Tableau Server or Tableau Cloud

and using tRESTClient - refresh extract at any time (Tableau scheduler is flexible, but still not cover all)

If You go by this ways, it will take 3 step:
- Login - receive a token

- call API

- Logout

https://onlinehelp.tableau.com/current/api/rest_api/en-us/help.htm

[Anonymous]

Hi @vapukov ,

I need to do what you wrote:

- Login - receive a token   --> (http://{{server}}/api/{{api}}/auth/signin)

- call API   --> (GET /api/api-version/sites/site-id/views/view-id/pdf)

- Logout

I am testing the conection to the Tableau API with Postman and everything works fine, I can get the pdf.

Do you have any example how to do it with Talend?

I tried to use the tRESTClient and tREST but I get always the same error trying to sign in: HTTP 301 Moved Permanently.

Any help?

Thank you.

[vapukov]

Hi,

it is hard to tell - what wrong

generally - if it works in postman/SoapUI/Paw it will work in Talend with tRESTClient (if all the same settings defined)

you could share you design, settings and error messages might be seen what wrong

regards, Vlad

[Anonymous]

Hi @vapukov , thanks for the reply.

In the tRESTClient Basic settings I am filling the properties URL, Relative Path, Username and Password (using Basic HTTP):

In the Advanced settings I am not changing anything.

In postman, to signin, I also use some xml in the request body, but I am not sure where I can put it or if I need it:
<tsRequest>
         <credentials name="{{username}}" password="{{password}}">
                    <site contentUrl="{{siteContentUrl}}" />
         </credentials>
</tsRequest>

Error message that I getting:
[statistics] connected

Exception in component tRESTClient_1 (get_tableau_workbooks)
javax.ws.rs.WebApplicationException: HTTP 301 Moved Permanently
at project.get_tableau_workbooks_0_1.get_tableau_workbooks.tRESTClient_1Process(get_tableau_workbooks.java:1082)
at project.get_tableau_workbooks_0_1.get_tableau_workbooks.runJobInTOS(get_tableau_workbooks.java:1960)
at project.get_tableau_workbooks_0_1.get_tableau_workbooks.main(get_tableau_workbooks.java:1809)
[statistics] disconnected

Any idea? Maybe I am missing to define some settings.

[vapukov]

Hi you do not need use authorization in tRESTClient,

you need do all same as Postman

you need to prepare body (before tRESTClient) and send this body as XML document as input for tRESTClient

useful links:

https://community.talend.com/t5/Design-and-Development/POST-request-with-JSON-data-to-tRESTClient-co...

https://community.talend.com/t5/Design-and-Development/tRestClient-how-to-set-body-in-POST-request/t...