Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Exporting Task via the API in Googlesheet


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

Atlassian Community Events