DataVacuum
CONTRIBUTOR **

Adding additional filters to SupplierInvoice

by DataVacuum

Hey Everyone,

 

In order to calculate outstanding balances with debtors/creditors we call on CustomerInvoice and SupplierInvoice to get the data we need. 

 

Fortunately we got it working for CustomerInvoice bij using "status=Open" which gives us the results we need. However, this doesn't seem to work for the SupplierInvoice Endpoint. 

 

Is there any other way besides GETTING all the rows and filtering afterwards? Funny thing is that it doesn't give a "Badrequest" or 404 error, so to me it seems that it should be possible to get this working. 

 

GETURL: 
GetRequestBaseURL,
[Headers=[#"ipp-company-id"=CompanyID, Authorization=Token],
RelativePath = "/controller/api/v1/customerinvoice?status=Open"
& "&pagenumber="
& Number.ToText(Page)]),

 

1 REPLY 1
Accepted solution
Magnus Johnsen
VISMA

by Magnus Johnsen

Hi,

Currently there is no parameter exposed to filter by status via the SupplierInvoice endpoint.

There is a case for this in the backlog, you can vote for it here:

Expose Supplier Invoice Document "Status" as a filtering parameter via "SupplierInvoice" Endpoint