How do I pull data from 2 external sources for use as drop down values for a Jira field?

[mukeshp]

Looking for a way to pull data from 2 sources - one via a REST API and a CSV file. The data from these 2 sources will be used as a drop down value for a field in Jira. Appreciate any suggestions/solutions on how best to accomplish this requirement.

Thanks

[Andrew Laden · Accepted solution]

You could probably do something with any of the scripted apps as well.

However keep in mind that having to look up multiple sources every time the field is edited may take some time. (some addons may have function to cache lookups which can help but may give unpredictable behavior.)

You may want to run an external process to gather the list values from all the sources, and then put them into a single database table. Run it every 15 minutes or so depending on how often the values update.

 Then you are only looking up against 1 table, not multiple sources, which would be faster.

[mukeshp]

Makes sense. Thank you for the suggestion. 

[JP _AC Bielefeld Leader_]

Hi,

use the Elements Connect addon.

https://marketplace.atlassian.com/apps/23337/elements-connect-formerly-nfeed

Best

JP

[mukeshp]

THANK YOU. Will try it out