On this page:
Useful Helpguide Links
Useful External Links
https://www.accessplanit.com/api-terms-of-use
https://documenter.getpostman.com/view/10924757/SzYexcAy?version=latest#intro
The Finance API feed endpoints allow you to integrate invoice, item, and payment information with other accounting, bookkeeping, and finance software. |
The feed is available if you have the API Feeds module. Please speak to your CSM to find out more about this module.
The Financial API Feeds can be used to connect your accessplanit platform to other finance software, such as your Invoicing tool.
Connecting your platforms and syncing the data between them removes the need for double data entry, reduces the risk of human error and eases the headache of managing multiple pieces of software!
There are three endpoints available for Financial data, please see the below tables for the data that is available in each.
Each of these three feeds have different levels of reading, creating, and updating, the tables below explain what actions are available for the fields in each feed.
This feed is used for accessing the details of Invoices within the database, it is also possible to update some information via the feed.
It is not possible to create new Invoices via the feed. This action should always be managed by an Administrator within the accessplanit platform.
It is not possible to filter the results of GET request for Invoices, other than specifying the specific invoice via
{{apiroot}}/invoices/[invoice id]
Field | GET | GET | PUT | POST | Validation for PUT & POST |
---|---|---|---|---|---|
Invoice ID |
| n/a | |||
Invoice Ref |
| n/a | |||
Issuer ID |
| n/a | |||
Amount |
| n/a | |||
Tax |
| n/a | |||
Date Generated |
| n/a | |||
Date Due |
| Date Time | |||
Date Updated |
| n/a | |||
Invoice Status |
| Please note: the status will be automatically updated to Completed or Part Completed when transactions are posted | n/a | ||
Amount Outstanding |
| n/a | |||
Amount Paid |
| n/a | |||
PO Number |
| Max 50 characters | |||
Invoice Based Custom Fields |
|
|
|
| Validation of values for PUT & POST requests is based on custom field type used, for example a number must be provided for number-based custom fields |
Here are some example filters that you are able to use with your Invoices API Feed:
Only include the Invoice with the ID of 75
{{apiroot}}invoices?InvoiceID=75
Only include Invoices updated since 20th August 2022
{{apiroot}}/Invoices?DateUpdated=gt:2022-08-20T00:00:00
Only include Invoices that have a status of Outstanding
{{apiroot}}/invoices?InvoiceStatus=Outstanding
Only include Invoices with an outstanding balance
{{apiroot}}/invoices?AmountOutstanding=gt:0
Only include users that have a PO Number
{{apiroot}}/invoices?PONumber=not:NULL
This feed is used for accessing the details of the items on the Invoices. Items include Delegates, the courses being purchased, Discounts, Placeholders, and Products and Services.
It is not possible to create or update Invoice Items via the feed. These actions should always be managed by an Administrator within the accessplanit platform.
It is not possible to filter the results of GET request for Invoices Items, other than specifying the specific invoice item or invoice via
{{apiroot}}/invoiceitems/[invoice item id]
{{apiroot}}/invoices/[invoice id]/invoiceitems
Field | GET | GET | PUT | POST | Validation |
---|---|---|---|---|---|
Invoice ID | n/a | ||||
Invoice Item ID | n/a | ||||
Line Description |
| n/a | |||
Invoice Item Amount |
| n/a | |||
Invoice Item Tax |
| n/a | |||
Nominal Code |
|
|
|
| n/a |
Cost Centre |
|
|
|
| n/a |
For information about where the Nominal Code and Cost Centre information is referenced in your accessplanit platform, for each Invoice Item please see https://accessplanit.atlassian.net/wiki/spaces/HG/pages/2700017665/March+2023#Finance-API-Feeds .
This feed is used for accessing the details of payments/transactions logged on Invoices.
It is possible to view and create transactions, including refunds, however, it is not possible to edit existing transactions.
It is not possible to filter the results of GET request for Transactions, other than specifying the specific transaction or invoice via
{{apiroot}}/invoicetransactions/[transaction id]
{{apiroot}}/invoices/[invoice id]/invoicetransactions
Field | GET | GET | PUT | POST | Validation |
---|---|---|---|---|---|
TransactionInvoiceID |
| n/a | |||
Invoice ID |
| Mandatory | Must validate against existing Invoices | ||
Transaction ID |
| n/a | |||
External Transaction ID |
| Max characters 250 | |||
Transaction Method |
| Mandatory | Only the following values are accepted:
| ||
Date |
| Mandatory | Date Time | ||
Amount |
| Mandatory | Number | ||
Tax |
| Mandatory | Number |
DISCLAIMER: By using accessplanit APIs, you agree to our terms of use. |
As the API Feeds are an additional module, please contact your assigned Customer Success Manager (CSM) to gain access to them for your integrations.