Exporting Task via the API in Googlesheet

Mohsin Ijaz March 12, 2020

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() {
  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

0 answers

Suggest an answer

Log in or Sign up to answer