Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,298,093
Community Members
 
Community Events
165
Community Groups

Custom Field - pull data from external source

Hello!

I need to pull data that will populate some custom dropdowns in Jira Cloud, so I was wondering what would be the best/easiest ways/options to go about it.

I am looking into a couple of plugins that do that, but was also wondering if there are any other alternatives out there that I could make use of without having to develop my own connector app.

One of the integrations we need is stored in a MSSQL in SharePoint, but we could also move it somewhere else if that makes it easier.

I was also wondering if I can populate a dropdown field based on data that is stored in Jira (say from an JQL query result, for instance).

Any thoughts would be greatly appreciated.

Cheers!

1 answer

1 accepted

0 votes
Answer accepted

Posting here after a lot of research just in case someone has the same use case -

Found 3 really useful plugins that allow you to connect to an external data source (2 are paid, 1 is free). The connectivity varies for each one, with some also supporting external files, REST APIs, and Sharepoint - but all of them supporting most databases such as SQL, MySQl, PostgreSQL, etc.

1. FREE app: https://docs.bitband.com/external-data-for-jira-cloud/getting-started

2. PAID: https://marketplace.atlassian.com/apps/1219994/external-data-for-jira-fields?tab=overview&hosting=cloud

3. PAID: https://marketplace.atlassian.com/apps/23337/elements-connect-external-data-fields?tab=overview&hosting=cloud

I am about to test them but found them really useful.

Cheers.

Happy to see you found Elements Connect @Ricardo.Gomes 

If you didn't find it, I posted an article on how you can use Elements Connect to query the Jira REST API to populate fields. 

If you have any questions while you're testing it, or need some help, don't hesitate to contact the Elements support team: 

https://support.elements-apps.com/portal 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Service Management

Coming Soon: Insight Changing to Assets

The 2020 acquisition of Mindville added powerful asset and configuration management capabilities to Jira Service Management in the form of Insight. Following the completion of that integration, custo...

245 views 1 9
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you