topic Extract XML data from web query (JQL - JIRA query language) in Talend Studio

Extract XML data from web query (JQL - JIRA query language)

Anonymous — Thu, 13 Apr 2017 11:33:31 GMT

HI,

I am using JIRA from atlassion. We can use query in JIRA and get the reports in XML format. I want to get the XML input in Talend using web address. Which component is suitable for this. My link is like this -

https://jira.abcd.com/sr/jira.issueviews:searchrequest-xml/temp/SearchRequest.xml?jqlQuery=project+%3D+%22FUEL+DAILY+SUPPORT%22+and+fixVersion+%3D+null&tempMax=1000

Please advise.

Re: Extract XML data from web query (JQL - JIRA query language)

Anonymous — Thu, 13 Apr 2017 13:20:26 GMT

Hi
Take a look at tJiraInput component that can be used to extract jira issues and returns the records in json format, afterwards, use a tExtractJsonFields to extract data from the response.

Regards
Shong

Re: Extract XML data from web query (JQL - JIRA query language)

Anonymous — Sat, 15 Apr 2017 18:13:49 GMT

Hi Shong,

Thanks for your response. I have used tJiraInput component for this purpose. But it is not creating correct Json file.

It is created like this:

{"data":[{"json":"{"value":"\\"Acceptance Criteria\\"

In the Host URL field, the address should be till what level? Login Page or the page where we put JQL in JIRA. Please help.

Re: Extract XML data from web query (JQL - JIRA query language)

Anonymous — Mon, 17 Apr 2017 09:40:36 GMT

Hi
The screenshot is not available, can you try to upload it again?
What data do you want to extract the response? In addition, can you have a try to use tHttpRequest to access the link? Let me know if it returns the response.
Regards
Shong

Re: Extract XML data from web query (JQL - JIRA query language)

vapukov — Tue, 18 Apr 2017 02:38:30 GMT

also (in addition to above)

if any system haven't pre-defined component, but support REST API, like Jira - https://developer.atlassian.com/jiradev/jira-apis/jira-rest-apis

You can use tRESTClient for direct work with system