how do i get the value of an already created issue, from the form field to a project field?

[Koen Bruggeman]

hi,

i aleady have a lot of created issues, filled with form fields.

I recently learned you cannot filter on those fields. Now I found the way how to link form fields to project fields and filtering is now working for newly created issues.

But how can I populate the already created form field content to project fields? Issues from before i figured out how to link them?

I tried resubmitting the form, but that doesnt populate the project field.

I hope someone knows how because i already have 1000ish issues.

Thank you!

[Marc - Devoteam]

Hi @Koen Bruggeman 

This is kind of not possible on historic issues with a form.

The only option I see is to use the Forms API and then one of  the calls:

• https://developer.atlassian.com/cloud/forms/rest/api-group-forms-on-issue/#api-issue-issueidorkey-form-formid-get
• https://developer.atlassian.com/cloud/forms/rest/api-group-forms-on-issue/#api-issue-issueidorkey-form-formid-format-answers-get 

So have a manual automation on the issue where you call one of the API endpoints and based on a condition based on the response, use {{webReponse.body}} output to validate the answer is like A then set the new Jira field to A.

Also you could to this more advanced on 1st doing an issue lookup and then branch over the results.

[Koen Bruggeman]

i am not that advanced, but i try to understand what youre saying and try to give it a go.

however, any additional help in form of a manual would be much appreciated :-D

[Marc - Devoteam]

Hi @Koen Bruggeman 

1. You will 1st need to create an api token, https://support.atlassian.com/atlassian-account/docs/manage-api-tokens-for-your-atlassian-account/ 
2. Then get your cloud ID: https://<site-name>.atlasisan.net/_edge/tenant_info
3. Then you will need to get the id of the form where the answer is in.
   
   You will need you account id and token to authenticate, also for the other calls, except in the automation rule
   
   https://api.atlassian.com/jira/forms/cloud/<cloud-id>/project/<project-key>/form
4. Above will list all forms on your project, find the id that is listed as "id" where the name matches the form used.
5. The in the automation we can do the web request.
   
   https://api.atlassian.com/jira/forms/cloud/<cloud-id>/ issue/{{key}}/form/<form-id from 4>/format/answers
   
   Where {{key} is the branch variable (if you use the example rule, in screenshot)
6. In the edit action of the automation rule set your field and the value that the field needs to have.

[Koen Bruggeman]

Thanks for your extra explication @Marc - Devoteam ,

i think i did it correctly.

it looks like i am not allowed?

where do i paste this code elsewhere than the automation trying to fetch the list-data like so: https://developer.atlassian.com/cloud/forms/rest/api-group-forms-on-issue/#api-issue-issueidorkey-form-formid-get

[Marc - Devoteam]

Hi @Koen Bruggeman 

It seams you don't have access or you don't have been granted a JSM license.

The get form id action is only to get the id. This id is need in the web request in the automation

[Maja Vallin]

I have not tried this myself but just have you tried creating an automation that just re-fetch issue data?

I would try with a manual trigger first and test it out on a few issues to see if it works. If it works then I would change the trigger to Scheduled and add a JQL that matches the issues I want to re-fetch issue data from (if there's a lot of issues the automation can get throttled so keep an eye on the auditlog for the automation) and then I would then select to run the rule right away. And when done you can inactive the rule or delete it.

[Koen Bruggeman]

it sounded like a good idea, but didnt work :(