Hi Will,

We also have a bespoke CRM and currently use Orbis (flakey !!) to feed financial data to Sage.

I started looking at the Sage API pre-covid and got so far before everything else got in the way !

Have you seen https://developer.columbus.sage.com/docs#/uk/sage200extra/accounts ?

Hi Will,

We also have a bespoke CRM and currently use Orbis (flakey !!) to feed financial data to Sage.

I started looking at the Sage API pre-covid and got so far before everything else got in the way !

Have you seen https://developer.columbus.sage.com/docs#/uk/sage200extra/accounts ?

Thanks for your reply,

Yes I have. I think I have also found the answer to my question in another thread.
 https://developer-community.sage.com/topic/528-unattended-confidential-client-oauth-integration-to-sage-200-api/#comment-1494
"You can essentially have a connection to the UKI 200 API unattended using the refresh token to maintain it. During the initial setup, manual login must be provided as part of the oauth process, but after that, the access token can be refreshed indefinitely and without the need for manual intervention. "
i.e. you have to implement Oauth flow with application credentials grant, implement the redirect URL flow exct, but once you get a token this way you can store it on a server and keep refreshing it.

its not good from an auditing front though. If our job goes and updates data in sage, I assume the change logs will be against the name of whoever the access token is for, making it look like they did it, and not an automated job. But at least it is a workaround.