Journal entries, what is the endpoint and parameters to extract analysis data per transaction

[Andrew Chaplin]

Journal entries, what is the endpoint and parameters to extract analysis data per transaction

[Steel, Mark]

Hi Andrew,

You can find the API reference for Journal Entries at https://developer.sage.com/accounting/reference/accounting/#tag/Journals.

Please let us know if you have any further questions.

Thanks

Mark

[Andrew Chaplin]

Hi Mark

Thank you for your prompt response. The difficulty i am having is the API reference says i should be getting the analysis breakdown by journal line but i'm not. I think i am missing a parameter but not sure what. I am calling https://api.accounting.sage.com/v3.1/journals?attributes=all&items_per_page=200

Best

Andrew

[Andrew Chaplin]

This is my output at journal line level:

                    "id": "e500f2f7a29f487cb2fb44c75e464fb2",

                    "ledger_account": {

                        "id": "284a76e9f70c428aade8e1d4fd9aeb04",

                        "displayed_as": "Basic Salaries - Direct (6000)",

                        "$path": "/ledger_accounts/284a76e9f70c428aade8e1d4fd9aeb04"

                    },

                    "details": " LS Leeds  Basic Salariies ",

                    "debit": "71304.54",

                    "credit": "0.0",

                    "include_on_tax_return": false,

                    "tax_reconciled": false,

                    "cleared": false,

                    "bank_reconciled": false,

                    "journal_line_foreign_currency": {

                        "currency_debit": null,

                        "currency_credit": null,

                        "exchange_rate": null

                    }

                },

 

[Steel, Mark]

Thanks Andrew - Could you provide a screenshot of the docs you're referring to please.

[Andrew Chaplin]

[Steel, Mark]

Thanks Andrew,

The behaviour is a little weird when using attributes=all. If you specify the attributes you require and include journal_lines and show analysis_types=true the data will be returned.

Alternatively if you require attributes=all I've found this to work GET https://api.accounting.sage.com/v3.1/journals?attributes=all,journal_lines&show_analysis_types=true

Thanks

Mark