Hi

I have made a google excelsheet and want to access that using Rest API in outsytems. Is there any way we can do it? Can we directly enter URL in Rest API method?

Helo Shubham.

No, the link you have is for "human consumption". You need the API address. There is an API for Google Sheets.you can read. https://developers.google.com/sheets/api


In OutSystems, you can use Forge and get some ready to use components in your project:

Google Sheets: https://www.outsystems.com/forge/component-overview/3058/google-sheets-connector

Google Drive: https://www.outsystems.com/forge/component-overview/364/google-drive-connector


This will save you the trouble of doing the integration with Google API. You just need to focus on the work with your spreadsheet.