Dropdown Select from External Database in JIRA Cloud Service Desk

[Peter Androutsos]

I am trying to figure out if there is a way for me to create a custom dropdown select field for which the options in the dropdown are pulled from an external database.  We have a list of options which are always in flux (service locations), and consequently, it would be a full-time job to keep the locations in JIRA up-to-date.  I would like the service desk portal to simply display the always-up-to-date locations from a dropdown that is pulled from a live database (direct to mysql, or i can create a json resource via http).

Alternatively is there maybe a way to procedurally update a custom dropdown select field's options?  Perhaps a REST endpoint?  I could easily write a cron script to perform the update every X minutes or on demand whenever a change to the location list is made.

There are plenty of options for pulling data when running JIRA Server, but we are somewhat devoid of options when it comes to JIRA Cloud.  Makes me want to give up on Cloud.

Any ideas?

[Thomas Opiolka - codefortynine]

There is now a Jira cloud App called External Data for Jira Fields that allows to synchronise external data with a selection field.
You can easily connect a Json endpoint as a data source. The Jira selection field then updates periodically.
This should apply to your use case.

Disclaimer: I'm the product manager of this App.

[Peter Androutsos]

OK, but does this address the basic premise of the question?  Can you have the dropdown select options for a custom field via a remote data source using this plugin?  I want the options shown in the dropdown to be populated from a set of cached data so that I can choose one of those options which were in the remote JSON response.  This should then be populated in the custom field.  The cached data source should have the option to be updated on whatever schedule I like (e.g. every week, every day, every hour, every minute, every X seconds, etc).  As far as I can see from the instructional video, this is not possible.

[Thomas Opiolka - codefortynine]

Yes it is possible. The feature is just new and not yet reflected in the video. (The video is a issue based example)

To fill an dropdown list you have to use "Selection" as ValueType then the custom field options of that field gets synced around every hour.

[Peter Androutsos]

As I an not familiar with JSONPath, how would I populate the dropdown options with a specific field from each set (say 'field2') using a set of data similar to what is show as below:

[

  {

    'FIELD0': '100',

    'FIELD1': '101',

    'FIELD2': '102',

    'FIELD3: '103'

  },

  {

    'FIELD0': '200',

    'FIELD1': '201',

    'FIELD2': '202',

    'FIELD3: '203'

  },

  {

    'FIELD0': '300',

    'FIELD1': '301',

    'FIELD2': '302',

    'FIELD3: '303'

  }

]

The result should be a  dropdown which allows the user to choose from the following  options:

  - 102

  - 202

  - 302

Perhaps there is a better way to format the json output?

[Thomas Opiolka - codefortynine]

that would be 

$.[*].FIELD2

$ => is the root

[*] => means every element of the array

.Field2 => is the selector

[Thomas Opiolka - codefortynine]

Here is a good online helper tool for building the right JsonPath Query

[Peter Androutsos]

thanks, i'll give it a whirl.

[Thomas Opiolka - codefortynine]

Great let me know if you need any help. And don't forget to Setup an API Token in the Settings Section.

[Peter Androutsos]

I think I've got it.

[Thomas Opiolka - codefortynine]

Great. From what I can see here you are just missing the API Token in the Settings Tab. Then you should be good to go. 

[Thomas Opiolka - codefortynine]

Now you should be able to trigger it manually in the Status Tab. The button on the right side "Start Selection Sync manually" starts a selection sync and directly below you can see the result.

[Thomas Opiolka - codefortynine]

It seems to work now. Found some things that we could tweak to make things a bit smoother. Let me know if you have any issue.

[Peter Androutsos]

Seems I am no longer able to get the API Token to work.  I save a new token, but the system complains as follows:

Step 1: SUCCESS Save API Token

Step 2: ERROR Access eMail by Atlassian Account ID

I have tried what is suggested by the error message, and my email is visible to all.

[Thomas Opiolka - codefortynine]

Hi Peter,

sometimes it just takes some time until the email is available or to toggle the switch on and off.

Some customers with the same issue had to open a ticket with Atlassian, because it was an issue with the account itself.

If you need more information or have further questions please write to support@codefortynine.com

Best,
Thomas

[Ismael Jimoh]

To my knowledge the above is no way to create what you described.

An asset management tool like insight for Cloud is your best bet but I did not find any in the marketplace.

For the option of dynamically changing options of a select list, this is not possible in Cloud.

[Ismael Jimoh]

Found this https://marketplace.atlassian.com/apps/1213365/oomnitza-for-jira?hosting=cloud&tab=overview&_ga=2.52325098.238419106.1543173458-1481143411.1540476554

it may help with your request.