Uploading information to Jira for form fields

[Tzeni Zoupani]

Hello everyone, 
I would like to ask if something like this is possible. 

In my company we have some project codes that my colleagues use to allocate expenses; those Project codes are connected with Funding codes. What I have done now is, I have created a form using the Cascading dropdown field whereas you know you have a parent (in my case Project code) and a child (Funding code) this way when they select the desire Project code, they know which Funding code to use without making a mistake. The problem with this is that every time that I have a change in the Project codes (and I have to do this at least every month because they change), I need to do this manually.

I was wondering if there is a way to upload the excel file where I have the project codes (which I extract it from somewhere else), so that they can be automatically updated with the upload of the file, and I don't have to check them one by one. 

Thank you for any assistance 

[Marc - Devoteam · Accepted solution]

Hi @Tzeni Zoupani

Crate a custom cascading field in Jira, via the  API you can update the field options.

api option: api-group-issue-custom-field-options 

based on a file you could, make the call to the API, like a runner in postman

[Tzeni Zoupani]

Thank you Marc!

[Marc - Devoteam]

Hi @Tzeni Zoupani 

Please accept my answer as a solution, if my answer helped to solve your request.

This will help other community member trying to solve the same.