API - Retrieve Trial Balance

[MarkLL]

@Tor

out of curiosity, you mentioned it works with trial balance, can I ask how you extract the JSON data for the trial balance at some specific date ?

@Tor, the following CURL request will extract the report in JSON format and save it to trial-balance-rpt.json.

curl -v -4 -G "https://apiUser:apiPassword@dev.mioapi.local/trial-balance-view.json?Key=4c1903a8-4eeb-433e-a3f1-71e5a83ca91e&FileID=Tm9ydGh3aW5kLWRhdGE" -o "trial-balance-rpt.json"

So the important bits are, you will need to retrieve the Key for the report via the /api/ entrance first. Then call the Front End view for the normal trial balance report but just add “.json” to the url destination. e.g. /trial-balance-view.json?Key= instead of /trial-balance-view?Key=

Above was tested on ManagerServer v 20.10.89 running behind nginx which I use instead of caddy.

Note: These queries no longer work directly to the localhost:port install and only work with a reverse proxy setup in front of it. This has been the case since 20.10.1. Version 20.10.0 being the last version that would work directly to localhost:port.