tJiraInput - expand parameter in JQL

[KHouwald1674725066]

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.

[Anonymous]

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"

[KHouwald1674725066]

Hi @Richard Hall​ ,

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

and getting :

[Anonymous]

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?

[KHouwald1674725066]

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!

[Anonymous]

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

[KHouwald1674725066]

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?

[Anonymous]

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.

[KHouwald1674725066]

Thank you a lot for your help!