How to get/set options to a custom field automatically?

[GiL]

I like to use a cascading selection list to manage the components of our product. This list needs to be synchronized with a second system. I wonder if I can set/get the options of a cascading selection list by REST or other API functions in order to synchronize the data between the systems.

Background: Our product as some hundred components grouped into about forty functional groups. The current defect tracking system is keeping the lists in sync between the defect tracking and the first level support system.
Our first level support is setting the functional group and component as the customer reports before sending the data to the defect tracking system.
I need to find a method to do something similar in Jira Cloud to replace the current defect tracking system.

[francis]

Hi Guido,

Do you integrate through REST or SQL?

In the latter case, you can use the multi level cascading field functionality offered in the table grid editor

Check for an example here

Francis

[GiL]

Hi Francis,

Thank you for your example. I think it would be a solution for my problem if the service is running on premise and SQL would be an option. I prefer not to use SQL in the Cloud so I'm looking for something being stored in Jira and synchronized with Salesforce. This would also improve the availability of both systems as they stay independent from a database server.

Kindest regards

Guido