Fix updating log sheet issue

[Yuriko-Schumacher]

There have been issues where some of the new projects are not logged automatically on our graphics spreadsheet.
It started happening around the beginning of December 2022. Carla had to manually add some of her projects' metadata to the spreadsheet so that the graphics would show up in CMS.

It looks like a metadata formatting issue. It's asking for a string value but the app is returning an array. For now, by commenting these lines out, the data are added automatically to the spreadsheet.

To get the graphics kit ready for our new spring fellow, we add the fix as a hot fix until we further investigate the issue.

Here's the error Carla got.
/Users/carlaastudillo/Documents/newsapps-dailies/2022/graphic-ttpp-wapo-uvalde-medical-2022-12/node_modules/gaxios/build/src/gaxios.js:129 throw new common_1.GaxiosError(Request failed with status code ${translatedResponse.status}, opts, translatedResponse); ^ GaxiosError: Invalid values[454][9]: list_value { values { string_value: “Washington Post analysis” } } at Gaxios._request (/Users/carlaastudillo/Documents/newsapps-dailies/2022/graphic-ttpp-wapo-uvalde-medical-2022-12/node_modules/gaxios/build/src/gaxios.js:129:23) at processTicksAndRejections (node:internal/process/task_queues:96:5) at async OAuth2Client.requestAsync (/Users/carlaastudillo/Documents/newsapps-dailies/2022/graphic-ttpp-wapo-uvalde-medical-2022-12/node_modules/google-auth-library/build/src/auth/oauth2client.js:368:18) { response: { config: { url: ‘https://sheets.googleapis.com/v4/spreadsheets/1hCP5zGx8dNxk59gI9wBSFY2juJVM8OFCDY45VnNb2nI/values/Embedded%21455%3A455:append?valueInputOption=USER_ENTERED’, method: ‘POST’, userAgentDirectives: [ { product: ‘google-api-nodejs-client’, version: ‘5.1.0’, comment: ‘gzip’ } ], paramsSerializer: [Function (anonymous)], data: { values: [ [ ‘-M1GriwnKyYL-ieX-jNzZ’, ‘https://graphics.texastribune.org/graphics/ttpp-wapo-uvalde-medical-2022-12/TT-Mireles-graphic/’, ‘graphics/ttpp-wapo-uvalde-medical-2022-12/TT-Mireles-graphic’, ‘Mireles being taken out of classroom graphic (TT version)’, ‘Footage from body and dashboard cameras showed that only two ambulances were outside the school when officers killed the gunman inside Robb Elementary on May 24 in Uvalde.’, ‘A 3D diagram of Robb Elementary school in Uvalde with Rooms 111 and 112 where the shooting happened highlighted. A blue line from the classrooms goes through the hallway to the outside of the school shows the path where medical staff took teacher Eva Mireles after they breached the classroom. The blue line ends outside of the school near two ambulances highlighted in red.’, ‘2022-12’, ‘2022-12-16T19:27:22.991Z’, ‘’, [Array], ‘Imogen Piper via Washington Post’, ‘subject-uvalde’, ‘’, ‘https://docs.google.com/document/d/1VvDr_82nOTmKViX94V_1mHB7ljNDO5RuR7vYb1eUcuI’, ‘https://graphics.texastribune.org/graphics/ttpp-wapo-uvalde-medical-2022-12/TT-Mireles-graphic/preview-large.png’, ‘https://graphics.texastribune.org/graphics/ttpp-wapo-uvalde-medical-2022-12/TT-Mireles-graphic/preview-small.png’ ] ] }, headers: { ‘x-goog-api-client’: ‘gdcl/5.1.0 gl-node/16.8.0 auth/7.14.1’, ‘Accept-Encoding’: ‘gzip’, ‘User-Agent’: ‘google-api-nodejs-client/5.1.0 (gzip)’, Authorization: ‘Bearer ya29.a0AX9GBdXcb5drZeLqRxAtT6Aaumt2y5MniBholShuCNF9IrGiObvIwbTn82v4zR93T_72i_hp98GK0k2KsvGH3Ks9mpdYzf4Lble69RUlHlbdIj5YFhUE6ibcqZO4zlfPWEllJ5Uql-XyHjXl9Hcr_n8-4JIGwI_4cAaCgYKAa0SAQASFQHUCsbCdX1Jb_sKHEPA4qIHYRr0IA0169’, ‘Content-Type’: ‘application/json’, Accept: ‘application/json’ }, params: { valueInputOption: ‘USER_ENTERED’ }, validateStatus: [Function (anonymous)], retry: true, body: ‘{“values”:[[“-M1GriwnKyYL-ieX-jNzZ”,“https://graphics.texastribune.org/graphics/ttpp-wapo-uvalde-medical-2022-12/TT-Mireles-graphic/”,“graphics/ttpp-wapo-uvalde-medical-2022-12/TT-Mireles-graphic”,“Mireles being taken out of classroom graphic (TT version)“,”Footage from body and dashboard cameras showed that only two ambulances were outside the school when officers killed the gunman inside Robb Elementary on May 24 in Uvalde.“,”A 3D diagram of Robb Elementary school in Uvalde with Rooms 111 and 112 where the shooting happened highlighted. A blue line from the classrooms goes through the hallway to the outside of the school shows the path where medical staff took teacher Eva Mireles after they breached the classroom. The blue line ends outside of the school near two ambulances highlighted in red.“,”2022-12",“2022-12-16T19:27:22.991Z”,“”,[“Washington Post analysis”],“Imogen Piper via Washington Post”,“subject-uvalde”,“”,“https://docs.google.com/document/d/1VvDr_82nOTmKViX94V_1mHB7ljNDO5RuR7vYb1eUcuI”,“https://graphics.texastribune.org/graphics/ttpp-wapo-uvalde-medical-2022-12/TT-Mireles-graphic/preview-large.png”,“https://graphics.texastribune.org/graphics/ttpp-wapo-uvalde-medical-2022-12/TT-Mireles-graphic/preview-small.png”]]}’, responseType: ‘json’, retryConfig: { currentRetryAttempt: 0, retry: 3, httpMethodsToRetry: [ ‘GET’, ‘HEAD’, ‘PUT’, ‘OPTIONS’, ‘DELETE’ ], noResponseRetries: 2, statusCodesToRetry: [ [ 100, 199 ], [ 429, 429 ], [ 500, 599 ] ] } }, data: { error: { code: 400, message: ‘Invalid values[454][9]: list_value {\n’ + ' values {\n’ + ' string_value: “Washington Post analysis”\n’ + ' }\n’ + ‘}\n’, errors: [ { message: ‘Invalid values[454][9]: list_value {\n’ + ' values {\n’ + ' string_value: “Washington Post analysis”\n’ + ' }\n’ + ‘}\n’, domain: ‘global’, reason: ‘badRequest’ } ], status: ‘INVALID_ARGUMENT’ } }, headers: { ‘alt-svc’: ‘h3=“:443"; ma=2592000,h3-29=“:443”; ma=2592000,h3-Q050=“:443"; ma=2592000,h3-Q046=“:443”; ma=2592000,h3-Q043=“:443"; ma=2592000,quic=“:443”; ma=2592000; v=“46,43"’, ‘cache-control’: ‘private’, connection: ‘close’, ‘content-encoding’: ‘gzip’, ‘content-type’: ‘application/json; charset=UTF-8’, date: ‘Fri, 16 Dec 2022 19:27:52 GMT’, server: ‘ESF’, ‘transfer-encoding’: ‘chunked’, vary: ‘Origin, X-Origin, Referer’, ‘x-content-type-options’: ‘nosniff’, ‘x-frame-options’: ‘SAMEORIGIN’, ‘x-xss-protection’: ‘0’ }, status: 400, statusText: ‘Bad Request’, request: { responseURL: ‘https://sheets.googleapis.com/v4/spreadsheets/1hCP5zGx8dNxk59gI9wBSFY2juJVM8OFCDY45VnNb2nI/values/Embedded%21455%3A455:append?valueInputOption=USER_ENTERED’ } }, config: { url: ‘https://sheets.googleapis.com/v4/spreadsheets/1hCP5zGx8dNxk59gI9wBSFY2juJVM8OFCDY45VnNb2nI/values/Embedded%21455%3A455:append?valueInputOption=USER_ENTERED’, method: ‘POST’, userAgentDirectives: [ { product: ‘google-api-nodejs-client’, version: ‘5.1.0’, comment: ‘gzip’ } ], paramsSerializer: [Function (anonymous)], data: { values: [ [ ‘-M1GriwnKyYL-ieX-jNzZ’, ‘https://graphics.texastribune.org/graphics/ttpp-wapo-uvalde-medical-2022-12/TT-Mireles-graphic/’, ‘graphics/ttpp-wapo-uvalde-medical-2022-12/TT-Mireles-graphic’, ‘Mireles being taken out of classroom graphic (TT version)’, ‘Footage from body and dashboard cameras showed that only two ambulances were outside the school when officers killed the gunman inside Robb Elementary on May 24 in Uvalde.’, ‘A 3D diagram of Robb Elementary school in Uvalde with Rooms 111 and 112 where the shooting happened highlighted. A blue line from the classrooms goes through the hallway to the outside of the school shows the path where medical staff took teacher Eva Mireles after they breached the classroom. The blue line ends outside of the school near two ambulances highlighted in red.’, ‘2022-12’, ‘2022-12-16T19:27:22.991Z’, ‘’, [ ‘Washington Post analysis’ ], ‘Imogen Piper via Washington Post’, ‘subject-uvalde’, ‘’, ‘https://docs.google.com/document/d/1VvDr_82nOTmKViX94V_1mHB7ljNDO5RuR7vYb1eUcuI’, ‘https://graphics.texastribune.org/graphics/ttpp-wapo-uvalde-medical-2022-12/TT-Mireles-graphic/preview-large.png’, ‘https://graphics.texastribune.org/graphics/ttpp-wapo-uvalde-medical-2022-12/TT-Mireles-graphic/preview-small.png’ ] ] }, headers: { ‘x-goog-api-client’: ‘gdcl/5.1.0 gl-node/16.8.0 auth/7.14.1’, ‘Accept-Encoding’: ‘gzip’, ‘User-Agent’: ‘google-api-nodejs-client/5.1.0 (gzip)’, Authorization: ‘Bearer ya29.a0AX9GBdXcb5drZeLqRxAtT6Aaumt2y5MniBholShuCNF9IrGiObvIwbTn82v4zR93T_72i_hp98GK0k2KsvGH3Ks9mpdYzf4Lble69RUlHlbdIj5YFhUE6ibcqZO4zlfPWEllJ5Uql-XyHjXl9Hcr_n8-4JIGwI_4cAaCgYKAa0SAQASFQHUCsbCdX1Jb_sKHEPA4qIHYRr0IA0169’, ‘Content-Type’: ‘application/json’, Accept: ‘application/json’ }, params: { valueInputOption: ‘USER_ENTERED’ }, validateStatus: [Function (anonymous)], retry: true, body: ‘{“values”:[[“-M1GriwnKyYL-ieX-jNzZ”,“https://graphics.texastribune.org/graphics/ttpp-wapo-uvalde-medical-2022-12/TT-Mireles-graphic/”,“graphics/ttpp-wapo-uvalde-medical-2022-12/TT-Mireles-graphic”,“Mireles being taken out of classroom graphic (TT version)“,”Footage from body and dashboard cameras showed that only two ambulances were outside the school when officers killed the gunman inside Robb Elementary on May 24 in Uvalde.“,”A 3D diagram of Robb Elementary school in Uvalde with Rooms 111 and 112 where the shooting happened highlighted. A blue line from the classrooms goes through the hallway to the outside of the school shows the path where medical staff took teacher Eva Mireles after they breached the classroom. The blue line ends outside of the school near two ambulances highlighted in red.“,”2022-12",“2022-12-16T19:27:22.991Z”,“”,[“Washington Post analysis”],“Imogen Piper via Washington Post”,“subject-uvalde”,“”,“https://docs.google.com/document/d/1VvDr_82nOTmKViX94V_1mHB7ljNDO5RuR7vYb1eUcuI”,“https://graphics.texastribune.org/graphics/ttpp-wapo-uvalde-medical-2022-12/TT-Mireles-graphic/preview-large.png”,“https://graphics.texastribune.org/graphics/ttpp-wapo-uvalde-medical-2022-12/TT-Mireles-graphic/preview-small.png”]]}’, responseType: ‘json’, retryConfig: { currentRetryAttempt: 0, retry: 3, httpMethodsToRetry: [ ‘GET’, ‘HEAD’, ‘PUT’, ‘OPTIONS’, ‘DELETE’ ], noResponseRetries: 2, statusCodesToRetry: [ [ 100, 199 ], [ 429, 429 ], [ 500, 599 ] ] } }, code: 400, errors: [ { message: ‘Invalid values[454][9]: list_value {\n’ + ' values {\n’ + ' string_value: “Washington Post analysis”\n’ + ' }\n’ + ‘}\n’, domain: ‘global’, reason: ‘badRequest’ } ] }

[Yuriko-Schumacher]

Still have to investigate what caused the issue and if we need a further fix.