topic Re: tJiraInput - expand parameter in JQL in Talend Studio

tJiraInput - expand parameter in JQL

KHouwald1674725066 — Thu, 26 Jan 2023 12:54:31 GMT

Hi All ,

How can I use the 'expand' parameter in JQL in tJiraInput?

JQL : "project = XXXX and resolution = Unresolved" works fine but

JQL : ""project = ITSGD and resolution = Unresolved" and expand=changelog"

returns "Field 'expand' does not exist or you do not have permission to view it".

The same when used with specific issue number.

Re: tJiraInput - expand parameter in JQL

Anonymous — Thu, 26 Jan 2023 14:09:27 GMT

Your JQL query that doesn't work doesn't look correct. Is that just a typo here or is that what you are using? I think you need to be using....

"project = ITSGD and resolution = Unresolved and expand=changelog"

If you need to use quotes in your query, you need to escape them. This is a good example....

"summary ~ \"some word\" AND project=PROJECT_ID"

Re: tJiraInput - expand parameter in JQL

KHouwald1674725066 — Thu, 26 Jan 2023 14:24:12 GMT

Hi @Richard Hall ,

Thank you for vigilance, but it was just a typo, I'm using:

and getting :

Re: tJiraInput - expand parameter in JQL

Anonymous — Thu, 26 Jan 2023 15:06:42 GMT

The user that you are using for this component, does it have permission to view the expand field? Can you manually log in via these user credentials and use this query?

Re: tJiraInput - expand parameter in JQL

KHouwald1674725066 — Thu, 26 Jan 2023 15:25:42 GMT

You're right, in Jira it looks the same :

I'm getting the response from Jira Server platform REST API (but there is no authentication), so did not figure out that user's privileges may be the reason.

Thank you!

Re: tJiraInput - expand parameter in JQL

Anonymous — Thu, 26 Jan 2023 15:32:03 GMT

Not a problem. Permissions can be somewhat misleading when using an application via APIs.

Re: tJiraInput - expand parameter in JQL

KHouwald1674725066 — Fri, 27 Jan 2023 07:43:24 GMT

You're absolutely right.

Am I right, that Talend is also using REST API in this tJira-components to connect Jira?

On the other hand, if I would like to get the response like :

https://MyJira/rest/api/2/status/

in Talend, can I achieve it with REST API Talend components?

Re: tJiraInput - expand parameter in JQL

Anonymous — Fri, 27 Jan 2023 11:36:13 GMT

You can use ANY REST API with Talend. Sometimes this is built into components for you (like in this scenario), but that doesn't stop you doing it in your own way using the tREST components.

Re: tJiraInput - expand parameter in JQL

KHouwald1674725066 — Fri, 27 Jan 2023 11:39:12 GMT

Thank you a lot for your help!