User Profile
emiagin
Copper Contributor
Joined May 29, 2023
User Widgets
Recent Discussions
Re: Import data from google sheet using api key
I think i just can't get it with google sheets, it need using google oauth, it's hard for me 😞 i found this problem on stack overflow: https://stackoverflow.com/questions/71818373/signing-in-to-google-sheets-from-excel-power-query I need to somehow connecting by using oauth or it will be network forbidden...3.2KViews0likes1CommentRe: Import data from google sheet using api key
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 https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/get try method window, but needs api key + oauth. I think i need to connect by google oauth in excel?3.4KViews0likes3CommentsRe: Import data from google sheet using api key
I found this documentation about OData: https://learn.microsoft.com/en-us/powerquery-m/odata-feed Looks like i have wrong serviceUri link... I should use this one i think: https://developers.google.com/sheets/api/reference/rest?hl=ru I'll try this format, hope it'll work: /v4/spreadsheets/{spreadsheetId}/sheets/{sheetId}:copyTo3.4KViews0likes0CommentsImport data from google sheet using api key
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?3.8KViews0likes6Comments
Recent Blog Articles
No content to show