Access to the reports API

DanielMDanielM Member Posts: 1

How can I access the reports API using the token issued for the API? It seems that the generated token doesn't have a scope for it.
I need to access the Reports API:
a) To retrieve all transaction data for all accounts/ for a given account in a period of time. ex: for the period 2019-2020 a list of transactions for all accounts for a given business.
b)To retrieve the trial balance for every account(specific account on request) for a list of given periods.

Is there any other way to access this data?

Comments

  • PaulCPaulC Member Posts: 186 ✭✭✭

    Hello Daniel,
    You are correct, API tokens are not scoped to access internal APIs that power the Wave web experience, such as the API that the Reports page uses. These are not designed as public APIs; our public APIs are managed to prevent breaking changes and ensure consistency, whereas internal APIs are only used by Wave developers, and can change much more quickly.
    You don't mention what you are trying to achieve with this data. If it is a 'one-off' or occasional requirement, the simplest would be to generate the Trial Balance report and export it as a CSV. For Account Transactions, go to Settings > Export Data and run the Accounting export, which will provide you a full GL double-entry listing that you can filter for whatever accounts you are interested in.
    Hope that helps.

Sign In or Register to comment.