Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2019-06-11 12:10 PM

How to connect Rally to read data

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,

VK

 

 

 

Labels (4)
Labels
509 Views
0 Likes
1 Solution

Accepted Solutions
Anonymous
Not applicable
‎2019-06-20 01:19 PM
Author

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

 

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

View solution in original post

509 Views
0 Likes
9 Replies
Anonymous
Not applicable
‎2019-06-11 02:01 PM
Author

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 🙂

509 Views
0 Likes
Anonymous
Not applicable
‎2019-06-11 03:12 PM
Author

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?
509 Views
0 Likes
Anonymous
Not applicable
‎2019-06-17 06:33 AM
Author

Hi

 

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.

509 Views
0 Likes
Anonymous
Not applicable
‎2019-06-17 07:01 AM
Author

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
509 Views
0 Likes
Anonymous
Not applicable
‎2019-06-17 07:54 AM
Author

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.

509 Views
0 Likes
Anonymous
Not applicable
‎2019-06-17 10:43 AM
Author

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 ?

509 Views
0 Likes
Anonymous
Not applicable
‎2019-06-17 10:56 AM
Author

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. 

509 Views
0 Likes
Anonymous
Not applicable
‎2019-06-20 01:19 PM
Author

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

 

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

510 Views
0 Likes
Anonymous
Not applicable
‎2019-06-20 01:36 PM
Author

Thank you for giving us your solution. 

509 Views
0 Likes