News for hackers. Stuff that matters.

A comment on Forced migration to Google Sheets API v4. Parent comment

Re:Forced migration to Google Sheets API v4 by tyingq on Wednesday January 15, 2020 @08:24AM (#22053913)
I looked into the a while ago. There are some other options but the only ones that appear to be fairly robust are manipulation from either Microsoft Flow or Powerapps. Both of which are sort of "citizen development" visual type environments.

There is a second choice that works more like the Google sheets API...the Microsoft Graph API: https://docs.microsoft.com/en-us/graph/api/resources/excel

When I last tried it, it was somewhat limited in functionality.

[ Parent | on HN ]
Re:Forced migration to Google Sheets API v4 by djsweet on Wednesday January 15, 2020 @09:45AM (#22054538)
Heads up on the Microsoft Graph API: it only works for certain styles of Microsoft Office customer. In particular, you can only authenticate against it with Azure AD, which completely chokes out the home market.
[ Parent | on HN ]
Re:Forced migration to Google Sheets API v4 by nu5500 on Wednesday January 15, 2020 @09:59AM (#22054676)
That is not true. There are certain APIs only applicable to commercial users, but the same Graph API calls (for example against OneDrive or Excel) can be used across both.
[ Parent | on HN ]
Re:Forced migration to Google Sheets API v4 by tyingq on Wednesday January 15, 2020 @11:40AM (#22055707)
Is that new? The post I linked to, from 9/2019, says "Support for workbooks stored in OneDrive Consumer platform is still not available. At this time, only the files stored in business platform is supported by Excel REST APIs."
[ Parent | on HN ]