getPropertyLookup()

in src/connectors/sheets-connector.js [229:254]

• 21 lines of code
• 5 McCabe index (conditional complexity)

  getPropertyLookup(tabId) {
    // Return cached value if already queried.
    if (this.propertyLookupCache[tabId]) return this.propertyLookupCache[tabId];

    let tabConfig = this.tabs[tabId];
    let sheet = this.getSheet(tabId);
    let skipRows = tabConfig.skipRows || 0;
    let skipColumns = tabConfig.skipColumns || 0;
    let propertyLookup;

    if (tabConfig.dataAxis === DataAxis.ROW) {
      let data = sheet.getRange(
        tabConfig.propertyLookup, skipColumns + 1,
        1, sheet.getLastColumn() - skipColumns).getValues();
      propertyLookup = data[0];

    } else {
      let data = sheet.getRange(
        skipRows + 1, tabConfig.propertyLookup,
        sheet.getLastRow() - skipRows, 1).getValues();
      propertyLookup = data.map(x => x[0]);
    }

    this.propertyLookupCache[tabId] = propertyLookup;
    return propertyLookup;
  }