Zoho Books - Account Transaction API & Excel Query

Zoho Books - Account Transaction API & Excel Query

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
      Zoho Marketing Automation

            Zoho Pagesense Resources

              Zoho SalesIQ Resources

                    Zoho TeamInbox Resources

                      Zoho DataPrep Resources

                        Zoho CRM Plus Resources

                          Zoho Books Resources

                            Zoho Subscriptions Resources

                              Zoho Desk Resources

                                Zoho Projects Resources

                                  Zoho Sprints Resources

                                    Qntrl Resources

                                      Zoho Creator Resources

                                        Zoho WorkDrive Resources

                                            Zoho Campaigns Resources

                                              Zoho CRM Resources

                                                    Design. Discuss. Deliver.

                                                    Create visually engaging stories with Zoho Show.

                                                    Get Started Now