https://community.developer.cybersource.com/t5/Integration-and-Testing/Retrieve-data-via-REST-API-and-post-it-to-a-Google-Sheet/m-p/80948#M51013 <P>Most REST APIs are used to interface with a database or perform other actions. Therefore, to interface with a Google Sheet, you first need to find a REST API that returns data. Then you need to find a way to make that data used for a Google Sheet. This can be done using Google Apps Script to execute queries on a Google Sheet.</P> Tue, 25 Jan 2022 11:11:10 GMT michaljonny33 2022-01-25T11:11:10Z https://community.developer.cybersource.com/t5/Integration-and-Testing/Retrieve-data-via-REST-API-and-post-it-to-a-Google-Sheet/m-p/80946#M51011 <P>Hi</P><P>&nbsp;</P><P class="">I am trying to build something for work internally so we can get the data from our time tracker into our Google Sheet report.</P><P class="">Unfortunately I have next to zero knowledge about this.. After a few days of Google research I came this far:</P><P class="">&nbsp;</P><P class="">function onOpen()&nbsp;{<BR />var ui&nbsp;=&nbsp;SpreadsheetApp.getUi();<BR />ui.createMenu('Clockodo&nbsp;API')<BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</SPAN>.addItem('pull&nbsp;data','Clockodo')<BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</SPAN>.addToUi();<BR />}<BR />function Clockodo()&nbsp;{<BR />var options&nbsp;=&nbsp;{};<BR />options.headers&nbsp;=&nbsp;{"Authorization":&nbsp;"Basic&nbsp;"&nbsp;+&nbsp;Utilities.base64Encode('email'&nbsp;+&nbsp;":"&nbsp;+&nbsp;'token')};<BR />var response&nbsp;=&nbsp;UrlFetchApp.fetch(options);<BR />var data&nbsp;=&nbsp;response.getContentText();<BR />Logger.log(response.getContentText());<BR />var sheet&nbsp;=&nbsp;SpreadsheetApp.getActiveSpreadsheet().getSheetByName("api_test");<BR />sheet.getRange(sheet.getLastRow()&nbsp;+&nbsp;1,1).setValue([data]);<BR />}</P><P class="">The data arrives all in 1 cell like this:</P><P class="">{"paging":{"items_per_page":1000,"current_page":1,"count_pages":1,"count_items":3},"filter":null,"entries":[{"id":46577355,"users_id":132201,"projects_id":1359052,"customers_id":1285331,"services_id":512899,...</P><P class="">And I just cannot figure out how to get this organized into columns or where to add which columns to pull.</P><P class="">If anyone can point me in the right direction I would be very grateful<SPAN>&nbsp;</SPAN></P><P class="">&nbsp;</P> Tue, 25 Jan 2022 10:19:08 GMT https://community.developer.cybersource.com/t5/Integration-and-Testing/Retrieve-data-via-REST-API-and-post-it-to-a-Google-Sheet/m-p/80946#M51011 TuqueroIvantckJ 2022-01-25T10:19:08Z https://community.developer.cybersource.com/t5/Integration-and-Testing/Retrieve-data-via-REST-API-and-post-it-to-a-Google-Sheet/m-p/80948#M51013 <P>Most REST APIs are used to interface with a database or perform other actions. Therefore, to interface with a Google Sheet, you first need to find a REST API that returns data. Then you need to find a way to make that data used for a Google Sheet. This can be done using Google Apps Script to execute queries on a Google Sheet.</P> Tue, 25 Jan 2022 11:11:10 GMT https://community.developer.cybersource.com/t5/Integration-and-Testing/Retrieve-data-via-REST-API-and-post-it-to-a-Google-Sheet/m-p/80948#M51013 michaljonny33 2022-01-25T11:11:10Z https://community.developer.cybersource.com/t5/Integration-and-Testing/Retrieve-data-via-REST-API-and-post-it-to-a-Google-Sheet/m-p/81029#M51067 <P>Good comment... Excellent work... Click<A href="https://liverpoolsmanandvanservice.co.uk/general-waste-service-liverpool-wide-range-of-coverage-2/" target="_self"> here</A></P> Mon, 31 Jan 2022 13:46:27 GMT https://community.developer.cybersource.com/t5/Integration-and-Testing/Retrieve-data-via-REST-API-and-post-it-to-a-Google-Sheet/m-p/81029#M51067 michaljonny33 2022-01-31T13:46:27Z