topic Re: how to create tableau extract using talend 6.4 in Talend Studio

how to create tableau extract using talend 6.4

Anonymous — Thu, 05 Oct 2017 04:27:07 GMT

how to create tableau extract using talend 6.4.

Re: how to create tableau extract using talend 6.4

vapukov — Thu, 05 Oct 2017 06:19:34 GMT

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

Re: how to create tableau extract using talend 6.4

Anonymous — Fri, 05 Apr 2019 17:18:39 GMT

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.

Re: how to create tableau extract using talend 6.4

vapukov — Tue, 09 Apr 2019 13:39:52 GMT

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

Re: how to create tableau extract using talend 6.4

Anonymous — Tue, 09 Apr 2019 16:43:46 GMT

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.

Re: how to create tableau extract using talend 6.4

vapukov — Wed, 10 Apr 2019 11:20:59 GMT

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-component/td-p/103167

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