Pull LOV Data into Custom Field using REST API in Jira Cloud

[Jeremy Steuhl]

I'm not a developer, so I'm going to start with that and we are on Jira Cloud

We are on Jira Cloud.  We have some custom fields that we want to populate with data from our Oracle ERP system.  I'm thinking we would need to do this via REST API.

1. Can the REST API populate a select list custom field with values from our ERP system?  I understand we'd have to write a program to do that, but want to make sure that the REST API can actually populate a select list.

2. If #1 is possible, what's the recommendation on the number of values to put in a select list?  Ex.  What is I wanted a custom field called "Sales Order" and have it validate against an actual sales order in our Oracle Order Management system.  We have 1000's of orders, so I don't think having a select list field in Jira with 1000's of entires is a good idea.  What's the best way to handle this?

3.  Maybe I'm not even asking the right question.  I assume we'd have to use Jira's REST API.  Is there a better way to integrate our JIra system with say Oracle EBS?

[DPKJ · Accepted solution]

@Jeremy Steuhlyou are on right track.

On Point 1,

Yes you can use Jira's rest API to populate options in 'Select Custom Field'. This is reference to API that you have to use - https://developer.atlassian.com/cloud/jira/platform/rest/v3/#api-group-Issue-field-options

On Point 2,

Having 1000's of record as select option is extremely bad idea, as Jira will pull this whole data to front end every time this field is editable. But currently with limitations of cloud, you can't do anything about this. You can try label field if that suits your need.

On Point 3,

For Jira Cloud, REST API is only way to integrate with any system.

[Jeremy Steuhl]

Thank you for your reply.  I'll pass the reference along to my internal team here for review.  

On point 2, I completely agree.  That would be a bad idea.  I'll discuss options with my stakeholders during our requirements gathering.  

What did you mean by "label field"?  Like create a custom field as a "label" type and then use the REST API to create 1000's of labels?  I guess that would work, but also runs the risk of persons creating bad labels, right?

[Jeremy Steuhl]

One more question, just to clarify.  There's no add-on or anything for Jira Cloud that anyone knows of that will allow a field to look at another database to validate a value?  I've taken a look at the marketplace, but nothing available for Cloud.  Maybe others have been creative in some other way to accomplish this type of task.

[DPKJ]

No there are no such plugins.

Actually building such plugin for cloud are rare possibility with infrastructure that Atlassian exposes.

[Naren Bandaru]

I am also try to do something similar but above link seems to be broken!