Has anyone been able to successfully integrate the SharePoint v2 Rest API into their scripts? I am looking into it and it uses Oath v2 to authenticate and generate an access token, but the token expires in 12 hours.
The problem I think I will run into is that I can generate an access token the first time outside of Airtable, but it really is of no use if it expires in 12 hours.
Does anyone know how I can have an access token that doesn’t expire in 12 hours or generate a new access token without needing user interaction which isn’t possible inside a scripting app or automation script?