May 29 2023 08:35 AM
Hi! I tried to connected my google sheet and excel sheet. The problem is in permitions. My google sheet have not viewed by anyone and i should use some authentication. I choose api key and created this request:
let
Source = OData.Feed("link", null, [Implementation="2.0", ApiKeyName="API_KEY_EXCEL"])
in
Source
In auth window i entered api key. And i receive this error:
DataFormat.Error: OData: The given URL neither points to an OData service or a feed: 'https://accounts.google.com/v3/signin/identifier?<identifier>&API_KEY_EXCEL=<api-key>&continue=https://docs.google.com/spreadsheets/d/<sheet-id>/edit?API_KEY_EXCEL=<api-key>&followup=https://docs.google.com/spreadsheets/d/<sheet-id>/edit?API_KEY_EXCEL=<api-key>&ifkv=<ifkv><mpl=sheets&osid=1&passive=1209600&service=wise&flowName=WebLiteSignIn&flowEntry=ServiceLogin&API_KEY_EXCEL=<api-key>'.
Details: https://accounts.google.com/v3/signin/identifier?<identifier>&API_KEY_EXCEL=<api-key>&continue=https://docs.google.com/spreadsheets/d/<sheet-id>/edit?API_KEY_EXCEL=<api-key>&followup=https://docs.google.com/spreadsheets/d/<sheet-id>/edit?API_KEY_EXCEL=<api-key&ifkv=<ifkv><mpl=sheets&osid=1&passive=1209600&service=wise&flowName=WebLiteSignIn&flowEntry=ServiceLogin&API_KEY_EXCEL=<api-key>
How can i fix it?
May 29 2023 02:07 PM - edited May 29 2023 02:13 PM
api key
What is OData and relative api?
Does the google sheet provide api to acheive data by formula?
Any official document available about this api?
May 30 2023 05:47 AM
May 30 2023 08:29 AM
@peiyezhu i tried to use this request using api key:
OData.Feed("https://sheets.googleapis.com/v4/spreadsheets/<sheet-id>?ranges='Common'!A1%3AC5", null, [Implementation="2.0", ApiKeyName="API_KEY_EXCEL"])
But receive an error:
Expression.Error: Access to the resource is forbidden.
This request is works in Method: spreadsheets.get | Google Sheets | Google for Developers try method window, but needs api key + oauth. I think i need to connect by google oauth in excel?
May 30 2023 02:30 PM
Jun 01 2023 06:54 AM
Jun 01 2023 03:05 PM