Google APIs 学习/使用

╰半夏微凉° 2023-02-12 10:19 101阅读 0赞

1.应用场景

<table> 
 <tbody> 
  <tr> 
   <td>了解并使用Google APIs, 用于开发当中.</td> 
  </tr> 
 </tbody> 
</table>

2.学习/操作

<table> 
 <tbody> 
  <tr> 
   <td> <p>背景:</p> <p>公司开发有用到Google APIs,所以只能去了解.</p> <p>&nbsp;</p> <p>1.介绍</p> <p>简单说, 就是Google提供操作Google文档的api,</p> <p>方便在项目使用code进行操作.</p> <p>&nbsp;</p> <p>2.操作</p> <p><a href="https://developers.google.com/apis-explorer" rel="nofollow">https://developers.google.com/apis-explorer</a>&nbsp; //Google APIs Explorer</p> <p><a href="https://developers.google.com/sheets/api/reference/rest" rel="nofollow">https://developers.google.com/sheets/api/reference/rest</a>&nbsp; //在Google APIs Explorer, 搜索sheets之后的结果</p> <p><a href="https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values" rel="nofollow">https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values</a>&nbsp; //REST Resource: spreadsheets.values</p> <p>&nbsp;</p> <p>后续补充</p> <p>...</p> </td> 
  </tr> 
 </tbody> 
</table>

3.问题/补充

<table> 
 <tbody> 
  <tr> 
   <td> <p>1.如何使用api获取Google Spreadsheet中的行数？</p> <p>参考:&nbsp;<a href="https://stackoom.com/question/178iy/%E5%A6%82%E4%BD%95%E4%BD%BF%E7%94%A8api%E8%8E%B7%E5%8F%96Google-Spreadsheet%E4%B8%AD%E7%9A%84%E8%A1%8C%E6%95%B0" rel="nofollow">https://stackoom.com/question/178iy/如何使用api获取Google-Spreadsheet中的行数</a></p> <p>&nbsp;</p> <p>查了文档，以及Google搜索之后，发现只是支持Python进行查询获取rowCount</p> <p>nodeJS解决办法:</p> <p>折中办法，自行记录rowCount，然后获取.</p> 
    <blockquote> 
     <p>async function updateRowsCount(sheets, spreadsheetId, sheetName){ <br> &nbsp; &nbsp; const res = await sheets.spreadsheets.values.update({ <br> &nbsp; &nbsp; &nbsp; &nbsp; spreadsheetId: spreadsheetId,<br> &nbsp; &nbsp; &nbsp; &nbsp; range: `${sheetName}!${LastRowCountCell}`,<br> &nbsp; &nbsp; &nbsp; &nbsp; valueInputOption: 'USER_ENTERED',<br> &nbsp; &nbsp; &nbsp; &nbsp; requestBody: { <br> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; values: [<br> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ['=COUNT(A:A)'],<br> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ],<br> &nbsp; &nbsp; &nbsp; &nbsp; },<br> &nbsp; &nbsp; })<br> &nbsp; &nbsp; return res.data;<br> }</p> 
    </blockquote> <p>这种办法，会每次更新rowCount，然后再查询获取rowCount值</p> <p>&nbsp;</p> <p>优化：</p> <p>应该继续查询文档或者nodeJS组件，或者可以考虑自己试着去写组件。//TBD</p> </td> 
  </tr> 
 </tbody> 
</table>

4.参考

<table> 
 <tbody> 
  <tr> 
   <td> <p><a href="https://github.com/googleapis/google-api-nodejs-client/#google-apis" rel="nofollow">https://github.com/googleapis/google-api-nodejs-client/#google-apis</a>&nbsp; //googleapis/google-api-nodejs-client</p> <p><a href="https://developers.google.com/apis-explorer" rel="nofollow">https://developers.google.com/apis-explorer</a>&nbsp; //Google APIs Explorer</p> <p><a href="https://stackoverflow.com/questions/61749543/how-to-get-the-correct-parameters-for-the-googleapi-nodejs-client" rel="nofollow">https://stackoverflow.com/questions/61749543/how-to-get-the-correct-parameters-for-the-googleapi-nodejs-client</a>&nbsp;//How to get the correct parameters for the googleapi-nodejs-client</p> </td> 
  </tr> 
 </tbody> 
</table>

后续补充

...