API Key for Sage Accounting

[Nektarios Nikolaou]

I still didn't manage to obtain an API Key for Sage accounting. I made some API calls through Postman with OAuth using the access token. I want to retrieve data, like invoices and credit notes, from Sage Accounting  and insert them into an excel worksheet in order to be able to use the in calculations. In order to do that excel asks me for authorization. So I need an API Key in order to proceed with the API call in excel. 

I use Sage Business on cloud.

Any help will be useful.

Thank you in advance. 

[Steel, Mark]

Hi @Nektarios Nikolaou,

"I made some API calls through Postman with OAuth using the access token" - The API uses the same oAuth flow regardless of what the client application is. If you're able to authenticate via POSTMAN using your registered app client credentials and excel has a supporting mechanism you'll be able to use the same client credentials.
 

You could use the tokens generated in POSTMAN and maintain/store them in excel but you'd need to consider the security of doing so. https://developer.sage.com/accounting/guides/authenticating/authentication/

Thanks

Mark