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