Question

Google sheets API

1

Hello, I need to write inside an existing google sheet file, do you know how can I do that in Mendix? This is the quickstart overview of the google sheet api : https://developers.google.com/sheets/api/quickstart/quickstarts-overview The problem is that I don’t see a way to do it with rest action. Do you believe it is doable using only rest action? or will I have to do it inevitably in java? Thanks

asked 2021-07-26

Yehoshua Choukroun

2 answers

Henri Schellingerhout · Answer 1 · 2021-07-26

Sure, that’s possible. Check here: https://developers.google.com/sheets/api/guides/values

Fabian Ammerlaan · Answer 2 · 2023-05-10

I would love to write to a Gsheet using the API as well. Could some one digest the documentation which Henri advised? My main struggle is how to set up the POST call around the array with values. Meaning, how to translate this part into Mendix:

$client = new Google\Client();
        $client->useApplicationDefaultCredentials();
        $client->addScope(Google\Service\Drive::DRIVE);
        $service = new Google_Service_Sheets($client);