@noloco/google-spreadsheet - npm Package Compare versions

Comparing version 3.2.0 to 3.2.1

lib/GoogleSpreadsheet.js

@@ -381,2 +381,20 @@ const _ = require('lodash');
 
+  async _getDeveloperMetadata(dataFilter) {
+    // Request type = `developerMetadata:search`
+    // https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.developerMetadata/search
+    return this.axios
+      .post('/developerMetadata:search', {
+        dataFilters: [dataFilter],
+      })
+      .then((response) => response.data.matchedDeveloperMetadata);
+  }
+
+  async getDeveloperMetadataByA1Range(a1Range) {
+    return this._getDeveloperMetadata({ a1Range });
+  }
+
+  async getDeveloperMetadataByGridRange(gridRange) {
+    return this._getDeveloperMetadata({ gridRange });
+  }
+
   async deleteNamedRange(namedRangeId) {
@@ -383,0 +401,0 @@ return this._makeSingleUpdateRequest('deleteNamedRange', { namedRangeId });

lib/GoogleSpreadsheetCell.js

@@ -192,2 +192,12 @@ const _ = require('lodash');
 
+  async getDeveloperMetadata() {
+    return this._sheet._spreadsheet.getDeveloperMetadataByGridRange(
+      {
+        sheetId: this._sheet.sheetId,
+        startColumnIndex: this._column,
+        endColumnIndex: this._column + 1,
+      }
+    );
+  }
+
   // used by worksheet when saving cells
@@ -194,0 +204,0 @@ // returns an individual batchUpdate request to update the cell

lib/GoogleSpreadsheetRow.js

@@ -85,4 +85,14 @@ const { columnToLetter } = require('./utils');
   }
+
+  async getDeveloperMetadata() {
+    return this._sheet._spreadsheet.getDeveloperMetadataByGridRange(
+      {
+        sheetId: this._sheet.sheetId,
+        startRowIndex: this._rowNumber,
+        endRowIndex: this._rowNumber + 1,
+      }
+    );
+  }
 }
 
 module.exports = GoogleSpreadsheetRow;

package.json

@@ -5,3 +5,3 @@ {
   "description": "Google Sheets API (v4) -- simple interface to read/write data and manage sheets",
-  "version": "3.2.0",
+  "version": "3.2.1",
   "license": "Unlicense",
@@ -8,0 +8,0 @@ "keywords": [

No alert changes

Improved metrics

Total package byte prevSize

75485

increased by1.47%

Lines of code

1546

increased by2.18%

No dependency changes