Tengo el siguiente código ..
function getAllNotes() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheetByName('ALL_Notes'); sheet.getRange('A3:A').clear(); const url1 = "https://sample.com"; const response = UrlFetchApp.fetch(url1, {"method": "GET", "headers": { "APIKEY": "???????????????????????????????", "cache-control": "no-cache", "Content-Type": "application/json"}, "muteHttpExceptions": true, "followRedirects": true, "validateHttpsCertificates": true, "contentType": "application/json"}); var json = response.getContentText(); var dataAll = JSON.parse(json); var finalData = dataAll["data"]; Logger.log(finalData);la salida de este código es la siguiente ..
Salida de registro demasiado grande. Salida truncada. [{Note={created=2021-07-25 09:34:24, NoteAttachment=[], user_permissions=null, follow_up_id=null, type=0, action_id=null, id=11, partner_type=1, share_with_partner=0 , partner_id=75, modificado =2021-07-26 08:30:50, item_id=75, status_id=null, cuerpo=
td {border: 1px sólido #ccc;}br {mso-data-placement:same-cell;}<span style="font-size:10pt;font-family:Tahoma,Arial;font-weight:normal{&formula= "=sierror(índice(,0))," ")">
, show_preview=null, date=2021-07-25 09:33:00, item_type=1, staff_id=3, client_permissions=null, branch_id=1, url=null}}, {Nota={ modificado =2021-07- 26 08:29:43, created=2021-07-26 08:29:43, staff_id=3, date=2021-07-26 08:29:00, item_type=1, NoteAttachment=[], id=12, partner_id=106, share_with_partner=0, type=0, url=null, item_id=106, user_permissions=null, action_id=null, follow_up_id=null, partner_type=1, status_id=3, show_preview=null, client_permissions=null, branch_id= 1, cuerpo=<span data-sheets-value{"1&qu[null,2,16711680],"15":"Tahoma","16":10}" data-sheets-formula="=iferror(indexstatus_id=3, follow_up_id=null , fecha=2021-07-26 09:58:00, action_id=null, staff_id=3, user_permissions=null, id=14, modificado=2021-07-26 09:58:58, item_type=1, type=0 , NoteAttachment=[], partner_id=113, url=null}}, {Nota={share_with_partner=0, follow_up_id=null, staff_id=3, modificado =2021-07-26 10:28:23, status_id=3, cuerpo =
<span data-sheets-value="{"
Es demasiado. ¿Cómo filtrar la salida según el valor de modified para que mi código solo obtenga datos en función de un valor específico?