GuidesChangelogVisma eAccounting API ReferenceVisma Lön Smart API Reference
Sign up for Sandbox
Back to All

Visma eAccounting API - New filter

5 months ago by Daniel Jonsson

📘

Several new filters

We have added many new filters, see below

Added the possibility to filter by negative amounts

Properties: -TotalAmount, -TotalVatAmount, -TotalRoundings, -RemainingAmount

Affected endpoints:

v2/customerinvoices
v2/customerinvoices/statistics

Possibility to filter by customer ID on quotes

We have made it possible to filter by customer ID when fetching quotes.

Affected endpoint:

GET v2/quotes

Added the possibility to filter on Row/Text

Affected endpoints:

GET /v2/customerinvoices

Added the possibility to filter on Row/ArticleNumber

Affected endpoints:

GET /v2/customerinvoicedrafts

Filtering by properties 'HasAutoInvoiceError' and 'TotalAmountInvoiceCurrency'

In the v2/customerinvoices and v2/customerinvoices/statistics endpoints we are missing properties 'HasAutoInvoiceError' and 'TotalAmountInvoiceCurrency'. Those have been added and the filtering is now possible, the same as in the web.

Affected endpoints:

GET /v2/customerinvoices?$filter=HasAutoInvoiceError eq true
GET /v2/customerinvoices/statistics?$filter=HasAutoInvoiceError eq true

GET v2/customerinvoices?$filter=RemainingAmountInvoiceCurrency eq -TotalAmountInvoiceCurrency or RemainingAmountInvoiceCurrency eq TotalAmountInvoiceCurrency
GET v2/customerinvoices/statistics?$filter=RemainingAmountInvoiceCurrency eq -TotalAmountInvoiceCurrency or RemainingAmountInvoiceCurrency eq TotalAmountInvoiceCurrency

Filter customer invoices by text row

Search for invoices with tex rows that contain a specific text.

New endpoints:

GET v2/customerinvoices?$filter=Rows/any(c: contains(c/Text,'anytext'))