Populate JIRA issues Keys in a Confiform dropdown

[abidaliahmed]

Hii,

I would like to get all the issues from jira and show the keys in a dropdown in a confiform.

I wrote the jql and it works fine 

My confluence is already integrated with my JIRA server 

and I create a webservice in ConfiForms app configuration

but when I tried to use it in webservice dropdown field I got null json 

Any idea ?? do I need to enable some configuration ??   

[Alex Medved _ConfiForms_ · Accepted solution]

Hi

How is your field (webservice dropdown) is configured?

Do you have something like this

Assuming your connection is pointed at Jira server (root)

Alex

[abidaliahmed]

Hi Alex

I set up as the images 

issues and key

regards,

Abid

[Alex Medved _ConfiForms_]

How about the JQL you use? Is it properly URL encoded?

If you put the same URL into the browser url - do you see the results?

[abidaliahmed]

MyJIRAServer/rest/api/2/search?jql=status%20in%20(open)&fields=key

exactly .. I got json result but it doesn't work within the field configuration 

[Alex Medved _ConfiForms_]

But you have specified limit fields via

&fields=key

Of course it doe snot load fields!

As you ask it not to load anything but the "key"...

Alex

[abidaliahmed]

yes that's right, I only need a key to show it on the dropdown 

no need for the other fields 

[Alex Medved _ConfiForms_]

And what is the mapping for "label" in your web service dropdown field?

[abidaliahmed]

I left it empty

[Alex Medved _ConfiForms_]

Well, should not you put key there to show the key?

I understand that you dont want an empty label... 

[abidaliahmed]

I think the problem in the connection to jira server 

because when "See the service mapping" in the dropdown configuration I got [] 

an empty json ,so no data is loaded here.

[Alex Medved _ConfiForms_]

Cannot tell about the connection itself... you need to check that yourself

And you need to put a mapping for "label" parameter as key

[abidaliahmed]

I did that but I got nothing.

[Alex Medved _ConfiForms_]

Empty results (json array) means you have no results returned

So it is either the Jira permissions thing or incorrect (web service) connection

How is this configured? You can open support ticket directly with us  - so it will be more safe to share the config details

Alex

[abidaliahmed]

Hi Alex

As I said it was a connection error confluence server couldn't see JIRA server.

Now it's working fine.

Many Thanks,

Abid