Populate field value from external system

[Joey Klein]

We have hundreds (thousands even) of organizations that use our 'product' and have a portal for support.  I want to capture the organization that's reporting the JSM  ticket but i can't manually enter, let alone maintain, a list of this size, not to mention what io imagine it would do to performance.  

I'd like to use an API to populate the values in this field (could be a single select CF, does not have to be the JSM 'Organizations' field) with values from another DB.  In other words, we store the values and the field loads the values.

Im not finding an easy way to do this in cloud.  I have scriptrunner and want to try and use that and don't want to buy another app.  Thoughts?

[Kate Kabir · Accepted solution]

Hi @Joey Klein 

Thank you for your question.

I can confirm that it is possible to write scripts that would interact with an external application such as Slack, as long as the application contains a Rest API which can be called to interact with it and I can confirm that the Knowledge Base Article located here provides a guide on how to call external APIs's.

In order to achieve this requirement, you should review the Rest API documentation for the external application in order to see what Rest API's you will need to use to achieve this and we would advise contacting the third party applications support team if you have any questions on how their third party API works.

We have a documentation example located here which shows how you can post a message to Slack and this example may prove a useful reference in helping you to create the script that you require, as it shows an example of making an API call to an external rest API.

Finally, I can confirm Atlassian does not permit our app to access any of the private rest API's they provide and means we are only allowed to access the public API's they provide when calling the Jira Cloud API's but for external API's you can call them and can use the steps above to do this.

To set a field value, you may kindly refer to the documentation here on how to update custom field options API.

I hope this information helps.

Kind Regards

Kate

[Kian Stack Mumo Systems]

Joey,

I'd take a look at the Elements Connect for Jira Cloud. This allows you to manage a DB and fetch the values from it when you need them!

Thanks,

Kian

[Julie d_Antin _Elements_]

Thanks for the recommendation @Kian Stack Mumo Systems 

@Joey KleinWhat kind of external DB are you using? If it's Postgre or MySQL you can try Elements Connect right away. If you have a different datasource, our Product Manager @Elyes Gannoun [Elements]  would be happy to talk with you to learn more about your use case (pick a time that works for you).

[Thomas Opiolka - codefortynine]

Hi Joey,

you could also have a look at External Data for Jira Fields. I believe the app should be able to handle your use case.

Best,
Thomas

disclaimer: I am the product manager of said app.