topic Re: Fetch data using Xero API (Oauth2.0) in TOS - DI v7.3 in Talend Studio

Fetch data using Xero API (Oauth2.0) in TOS - DI v7.3

ananyasingh — Thu, 10 Jun 2021 13:11:52 GMT

Hi,

I want to get data from Xero API which uses OAuth2.0 authentication. Any idea how can I achieve this in TOS-DI v7.3?

Addition info:

As mentioned in the document, I need to first generate a code(refresh token) using which I will get my Bearer Token.

Xero link:

https://developer.xero.com/documentation/guides/oauth2/auth-flow/#3-exchange-the-code

Thanks in advance.

Re: Fetch data using Xero API (Oauth2.0) in TOS - DI v7.3

gjeremy1617088143 — Thu, 10 Jun 2021 13:36:14 GMT

Hi, you can use TrestClient component with Oauth2.0 as authentification parameter.

Send me Love and Kudos

Re: Fetch data using Xero API (Oauth2.0) in TOS - DI v7.3

ananyasingh — Thu, 10 Jun 2021 14:02:18 GMT

Umm yeah, but how to get the Bearer Token?

Okay, I think I need to edit my post to explain it in more detail.

Thanks anyways 🙂

Re: Fetch data using Xero API (Oauth2.0) in TOS - DI v7.3

gjeremy1617088143 — Thu, 10 Jun 2021 14:13:42 GMT

everithing is explained in your doc :

you have to make a first call with a post method

https://identity.xero.com/connect/token

with some info in the body

and a specific header for the authorization

Re: Fetch data using Xero API (Oauth2.0) in TOS - DI v7.3

gjeremy1617088143 — Thu, 10 Jun 2021 14:42:30 GMT

you have to write a String named string wich contain the grant type (authorization_code), code and redirect_uri

grant_type=authorization_code
code=The authorization code you received in the callback
redirect_uri=The same redirect URI that was used when requesting the code

with this value:

"grant_type=authorization_code&code=xxxxxx&redirect_uri=https://myapp.com/redirect"

you could do this in a trowgenerator or a tfixedflowinput for example.

Then connect it to the trestclient with a main row.

In trestclient :

URL : "https://identity.xero.com/connect/token"

HTTP Method : POST , Content Type FORM , Accept Type Any

in advanced setting :

Http Headers

name : "authorization" value : "Basic " + Base64.encode((client_id + ":" + client_secret).getBytes())

Re: Fetch data using Xero API (Oauth2.0) in TOS - DI v7.3

ananyasingh — Thu, 10 Jun 2021 15:20:02 GMT

okay, but that's step-3 but how to implement step-1 and 2?

Re: Fetch data using Xero API (Oauth2.0) in TOS - DI v7.3

gjeremy1617088143 — Thu, 10 Jun 2021 15:33:04 GMT

It's seems you can do part 1 and 2 with an app not talend cause you have redirection and not json response.

Re: Fetch data using Xero API (Oauth2.0) in TOS - DI v7.3

ananyasingh — Thu, 10 Jun 2021 15:56:57 GMT

yeah, I also kind of resonate with you on this. Although I am hoping to get an official response from Talend.

I tried doing it in thttprequest and trestclient but none of them worked.

In trestclient, there is an option to check the "Follow redirects" and "Allow non-same host redirects" which I did and I gave my Xero creds in "Basic HTTP" authentication but no luck. It's returning an HTML.

Is there any other Talend product that can handle this?

Re: Fetch data using Xero API (Oauth2.0) in TOS - DI v7.3

gjeremy1617088143 — Thu, 10 Jun 2021 16:03:00 GMT

maybe you have the info in the html , you can extact them if you can see specific pattern inside.

Re: Fetch data using Xero API (Oauth2.0) in TOS - DI v7.3

ananyasingh — Fri, 11 Jun 2021 09:35:36 GMT

nope. it was just a nonfunctional HTML doc with tags like username and password. My trestclient is just reading the content of the redirect URL and not passing the username password which I have provided in the component.