How to import data of a customfield of the jira manually as it is an array and i just want to retrive the value of name from it here at the bottom there is a function which extract data from a custom field Epic name2 and import it in backlog i want to do the Same thing with Task customfield_10700 which is basically a list and we can pick only one option. here is the code:
function jiraPullManual() {
jiraPull();
Browser.msgBox("JIRA backlog successfully imported");
var ss = SpreadsheetApp.getActiveSpreadsheet();
var subtasksSheet = ss.getSheetByName("SubTasks Backlog");
var backlogSheet = ss.getSheetByName("Backlog");
subtasksSheet.getRange(2, 10, subtasksSheet.getLastRow()-1, 1).setFormula("=Iferror(INDEX(Backlog!$E$2:$E;match(C2;Backlog!$A$2:$A;0));\"\")");
subtasksSheet.getRange(2, 11, subtasksSheet.getLastRow()-1, 1).setFormula("=iferror(INDEX(Backlog!$I$2:$I;match(Index(Backlog!$F$2:$F;match(C2;Backlog!$A$2:$A;0));Backlog!$A$2:$A;0));\"\")");
subtasksSheet.getRange(1,10).setValue("Parent Component");
subtasksSheet.getRange(1,11).setValue("Parent Epic");
backlogSheet.getRange(1,10).setValue("Epic Name2");
backlogSheet.getRange(2,10, backlogSheet.getLastRow()-1, 1).setFormula("=Iferror(INDEX($I$2:$I;match(F2;$A$2:$A;0));\"\")");
}
So i want to fetch custom_field_10700 value 'name' how can i achieve without any add-on
