topic Re: How to connect Rally to read data in Talend Studio

How to connect Rally to read data

Anonymous — Tue, 11 Jun 2019 16:10:20 GMT

Hi,

I wish to connect Rally website and fetch data in JSON format. I tried using tRest component but getting authentication issue. I can login to the same URL from my browser, but getting authentication issue when I try from Talend

I have below details:

APIKey

Rally URL (not API URL) : https://rally1.rallydev.com/

I need help in framing proper URL using the API key and also how to pass the authentication details if any needed.

Immediate suggestion would be very helpful to proceed further.

Regards,

Re: How to connect Rally to read data

Anonymous — Tue, 11 Jun 2019 18:01:22 GMT

Hi,

If you do not have proper API, why don't you write custom java code to do the steps you want to perform and call this custom java code through tJava or tJavarow or routine within Talend?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: How to connect Rally to read data

Anonymous — Tue, 11 Jun 2019 19:12:26 GMT

Thank you for the reply.
But I don't have any Java knowledge. So I prefer solution using talend
components

Could you guide if I need any other details apart from API key to connect
from talend?

Re: How to connect Rally to read data

Anonymous — Mon, 17 Jun 2019 10:33:41 GMT

Can I get some response on my query please.

Currently, I assume I got stuck with my LogIn page. It might not be due to authentication issue because I was able to login Rally from my browser. I cannot see any error message but below is the output from tLogRow.

Please confirm the way to pass the login details/parameters if login is the issue.

.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------.
| tLogRow_1 |
|=-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------=|
|Body |ERROR_CODE|
|=-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------=|
|<html><head><script type="text/javascript">var w=window,l=w.location,s=l.search,h=l.href.split('#')[1];w.location=h?'/'+(s?s+'&':'?')+'hash='+encodeURIComponent(h):'/slm/login.op'; // $NON-NLS-L$</script></head></html>|null |
'--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------'

Request to consider with priority.

Re: How to connect Rally to read data

Anonymous — Mon, 17 Jun 2019 11:01:44 GMT

Adding more details/screeshots to my earlier post

If this is not an Authentication issue, how can I access my JSON data to identify the fields?

Looping @rhall : So far, your suggestions helped me a lot in other posts. Please help me in closing my issue even here.

Thanks in advance !!!

SimpleJobDesign.PNG
tJava.PNG
tRest.PNG

Re: How to connect Rally to read data

Anonymous — Mon, 17 Jun 2019 11:54:13 GMT

Do you have an API specification for this? Unfortunately it looks like you are trying to treat a login page as part of the API. This is seldom how APIs work. If you can give us more information on the API, then one of us may be able to help.

Re: How to connect Rally to read data

Anonymous — Mon, 17 Jun 2019 14:43:11 GMT

I might be facing this issue due to SSO Redirection.

I assume, its getting failed at SSO Redirection page. Could you suggest how to pass the SSO login details through tRestClient component ?

Re: How to connect Rally to read data

Anonymous — Mon, 17 Jun 2019 14:56:43 GMT

Nobody can help you with this unless you give us details about the API. This is a bit like asking a cooker manufacturer why your cake recipe is not working, but not giving any idea about the recipe. The important information here is the API documentation.

Re: How to connect Rally to read data

Anonymous — Thu, 20 Jun 2019 17:19:52 GMT

@rhall : I do have private information which I cannot share and thank you for the inputs

Anyhow I am able to achieve this and sharing the solution for the sake of other Developers.

I have set the Authentication Type to OAuth2Bearer instead of Basic HTTP which resolved the HTTP 302 Found error

Re: How to connect Rally to read data

Anonymous — Thu, 20 Jun 2019 17:36:31 GMT

Thank you for giving us your solution.