Reading Tableau Metadata with Talend

Dobby1 — Sat, 16 Nov 2024 00:04:14 GMT

I want to use Tableau's graphql to read metadata from our Tableau Online instance.

My Tableau graphql is:

query getWorkbooks {workbooks {id, name, projectName, projectVizportalUrlId}}

I've tested it on https://us-east-1.online.tableau.com/metadata/graphiql and I get back the expected results.

I also created a Personal Authentication Token on Tableau Online which I need to pass in the body of the

tRESTClient

and that's where I'm struggling. It can either be passed as an XML or JSON.

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

The XML request body (message payload) using a Personal Access Token looks like the following example. The header of the request should contain either the key value pair

Content-Type

text/xml

, or

Content-Type

application/xml

tsRequest

credentials

personalAccessTokenName

"MY_TOKEN_NAME"

personalAccessTokenSecret

"qlE1g9MMh9vbrjjg==:rZTHhPpP2tUW1kfn4tjg8"

site

contentUrl

"MarketingTeam"

credentials

tsRequest

The same request body using JSON looks like the following. Its header should contain

Content-Type

application/json

{

"credentials"

: {

"personalAccessTokenName"

"MY_TOKEN_NAME"

"personalAccessTokenSecret"

"qlE1g9MMh9vbrjjg==:rZTHhPpP2tUW1kfn4tjg8"

"site"

: {

"contentUrl"

"MarketingTeam"

}

How would I construct the above in Talend and pass to the tRESTClient body?

Re: Reading Tableau Metadata with Talend

Anonymous — Fri, 11 Jun 2021 04:53:24 GMT

Take a look at tXMLMap component where you can build a Document as body and pass it to tRestClient, the job design looks like:

tFixeFlowInput--main--tXMLMap--out1-->tRestClient--main--tLogRow

Regards

Shong

topic Reading Tableau Metadata with Talend in Talend Studio

Reading Tableau Metadata with Talend

Re: Reading Tableau Metadata with Talend