I have been trying to export the account transaction from Zoho Books for some time.

I was able to get the data based on Postman by following the API Docs by Zoho.

My requirement is to import the Account Transaction Report from Zoho Books to Excel using API & Query, The issue I am facing is Excel will allow me to use parameters if I log in anonymously.

Postman does let me get the data using this API.

I need guidance on how to get it on Excel using a query,  to log in anonymously it needs an ID & API key.

Client ID & Client_Secret doesn't work