Get all fields from google spreadsheet with api v4

Question

I'm setting up a project in NodeJS and for testing I get the information from a spreadsheet in JSON format from the following page: https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/batchGet

To obtain the information of a sheet, in the spreadsheetId field I put the ID of the spreadsheet and in the range field the name of the sheet.

This is the JSON I get:

{
  "spreadsheetId": "{spreadsheetId}",
  "valueRanges": [
    {
      "range": "Parameters!A1:Z1000",
      "majorDimension": "ROWS",
      "values": [
        [
          "Country",
          "COLOMBIA"
        ]
      ]
    }
  ]
}

What I want is to show all the fields of the sheet to obtain the title and the modification and creation dates. To do this, in the fields field, I am putting the title string but I get the following error:

{
  "error": {
    "code": 400,
    "message": "Request contains an invalid argument.",
    "status": "INVALID_ARGUMENT",
    "details": [
      {
        "@type": "type.googleapis.com/google.rpc.BadRequest",
        "fieldViolations": [
          {
            "field": "title",
            "description": "Error expanding 'fields' parameter. Cannot find matching fields for path 'title'."
          }
        ]
      }
    ]
  }
}

I have tried putting * but I get the same JSON.

My problem: How can I get the date of creation and the date of last modification of the spreadsheet?

GoranK GoranK · Accepted Answer · 2021-08-18T12:34:32

you must use this endpoint to get a spreadsheet properties: https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/get

Get all fields from google spreadsheet with api v4

1 Answers