brkayaoglu

name: Basic API call 2(JavaScript)
description: Performs a basic Excel API call using plain JavaScript & Promises.
host: EXCEL
api_set: {}
script:
  content: "class Injection {\n  constructor(id, name, eic, org_eic, inj_type) {\n    this.id = id;\n    this.name = name;\n    this.eic = eic;\n    this.org_eic = org_eic;\n    this.inj_type = inj_type;\n  }\n}\n\nclass Organization {\n  constructor(organizationId, organizationName, organizationETSOCode, injectionsList) {\n    this.organizationId = organizationId;\n    this.organizationName = organizationName;\n    this.organizationETSOCode = organizationETSOCode;\n    this.injectionsList = null;\n  }\n}\n\nclass Portfolio {\n  static portfolioCount = Office.context.document.settings.get(\"portfolioLength\");\n  constructor(portfolioName, injections) {\n    this.portfolioName = portfolioName;\n    this.injections = injections;\n  }\n}\n\nclass AppVariables {\n  static selectedInjections = [];\n  static global_index_for_item = 0; //index that updated portfolio had\

brkayaoglu

name: Basic API call 2(JavaScript)
description: Performs a basic Excel API call using plain JavaScript & Promises.
host: EXCEL
api_set: {}
script:
  content: "if (Office.context.document.settings.get(\"getDataFromWeb\") == null) {\n  //console.log(\"first run\");\n  getOrganizationList();\n  Office.context.document.settings.set(\"getDataFromWeb\", true);\n  persistSettings();\n} //else console.log(\"second run\")\n\nlistOrganizations();\ngetFirstTimeData();\n\nvar updateFlag = false;\nvar btn = document.getElementById(\"portfolioSelectButton\");\nOffice.context.document.settings.get(\"portfolioLength\") == 0 ? (btn.disabled = true) : (btn.disabled = false);\n\nvar i, organization_list, organization_id, organization_name;\n\nfunction listOrganizations() {\n  organization_list = document.querySelector(\"#organizations_list\");\n  for (i = 0; i < 12; i++) {\n    //Office.context.document.settings.get(\"length\")\n    organization_id = Office.context.document.settings.get(`${i}`).organizationId;\n    organization

brkayaoglu

name: Basic API call 2(JavaScript)
description: Performs a basic Excel API call using plain JavaScript & Promises.
host: EXCEL
api_set: {}
script:
  content: "if (Office.context.document.settings.get(\"getDataFromWeb\") == null) {\n  //console.log(\"first run\");\n  getOrganizationList();\n  Office.context.document.settings.set(\"getDataFromWeb\", true);\n  persistSettings();\n} //else console.log(\"second run\")\n\nlistOrganizations();\ngetFirstTimeData();\n\nvar updateFlag = false;\nvar btn = document.getElementById(\"portfolioSelectButton\");\nOffice.context.document.settings.get(\"portfolioLength\") == 0 ? (btn.disabled = true) : (btn.disabled = false);\n\nvar i, organization_list, organization_id, organization_name;\n\nfunction listOrganizations() {\n  organization_list = document.querySelector(\"#organizations_list\");\n  for (i = 0; i < 12; i++) {\n    //Office.context.document.settings.get(\"length\")\n    organization_id = Office.context.document.settings.get(`${i}`).organizationId;\n    organization

brkayaoglu

name: Basic API call (JavaScript)
description: Performs a basic Excel API call using plain JavaScript & Promises.
host: EXCEL
api_set: {}
script:
  content: "if(Office.context.document.settings.get(\"getDataFromWeb\")==null){\n  console.log(\"first run\")\n  getOrganizationList();\n  Office.context.document.settings.set(\"getDataFromWeb\", true);\n  persistSettings();\n}//else console.log(\"second run\")\n\nlistOrganizations();\ngetFirstTimeData();\n\nvar updateFlag = false;\nvar btn = document.getElementById(\"portfolioSelectButton\");\nOffice.context.document.settings.get(\"portfolioLength\") == 0 ? (btn.disabled = true) : (btn.disabled = false);\n\nvar i, organization_list, organization_id, organization_name;\n\nfunction listOrganizations() {\n  organization_list = document.querySelector(\"#organizations_list\");\n  for (i = 0; i < 12; i++) {\n    //Office.context.document.settings.get(\"length\")\n    organization_id = Office.context.document.settings.get(`${i}`).organizationId;\n    organization_name = O