function noteFieldMetadata()

in read_input/read/google-sheet-read.js [146:175]

• 29 lines of code
• 8 McCabe index (conditional complexity)

function noteFieldMetadata(responseData, rangeRowNameMap) {
  let rangeNoteKey = {};
  if (!responseData.sheets) return rangeNoteKey;
  responseData.sheets.forEach((sheetEntry) => {
    let sheetId = sheetEntry.properties.sheetId;
    if (!sheetEntry.data) {
      return;
    }
    sheetEntry.data.forEach((sheetData) => {
      if (!sheetData.rowData) return;
      // prettier-ignore
      const myRangeId = `${sheetData.startRow || 0}:${sheetData.startColumn || 0}`;
      const rangeName = rangeRowNameMap[sheetId][myRangeId];
      sheetData.rowData.forEach((row) => {
        if (!row.values) return;
        row.values.forEach((cell) => {
          if (cell.note) {
            formatHeaderData(
              rangeNoteKey,
              rangeName,
              cell.formattedValue,
              cell.note
            );
          }
        });
      });
    });
  });
  return rangeNoteKey;
}