What's the easiest way to grab all specific JSON data from a Smartsheet JSON?

@DougSmartsheetDev

Start with the Smartsheet API 2.0 / SDK guide.

First, get your API Auth Bearer Token from the admin app.

Then you need to isolate your sheet id:

GET /sheets
https://api.smartsheet.com/2.0/sheets
response = smartsheet_client.Sheets.list_sheets(include_all=True)
sheets = response.data
Response sample:
{
 "pageNumber": 1,
 "pageSize": 50,
 "totalPages": 25,
 "totalCount": 136,
 "data": [
  {
   "id": 0,
   "accessLevel": "ADMIN",
   "createdAt": "2019-08-24T14:15:22Z",
   "modifiedAt": "2019-08-24T14:15:22Z",
   "name": "string",
   "permalink": "string",
   "version": 0,
   "source": {
    "id": 0,
    "type": "string"
   }
  }
 ]
}

Then you need to GET the list of columns and find the column Id you're looking for:

https://api.smartsheet.com/2.0/sheets/{sheetId}/columns
response = smartsheet_client.Sheets.get_columns(
 9283173393803140,    # sheet_id
 include_all=True)
columns = response.data
Sample Response:
{
 "pageNumber": 1,
 "pageSize": 50,
 "totalPages": 25,
 "totalCount": 136,
 "data": [
  {
   "id": 0,
   "index": 0,
   "symbol": "string",
   "title": "string",
   "type": "ABSTRACT_DATETIME",
   "validation": true
  }
 ]
}

Then you need to GET the row data from that column:

That's detailed here in the API/SDK guide: https://smartsheet.redoc.ly/tag/rows#operation/row-get

You could also use the Smartsheet Live Data Connector to query the sheet you want and use some other app to parse the column data to json.