Developer forum

Forum » Integration » Need filtering of data and custom fields response from Business Central

Need filtering of data and custom fields response from Business Central

Girish Kamble
Reply

 We use the "Integration Customer Centre" to get data from Business Central and show it on the front end. While getting data from Business Central we have created End Point which communicates with Business Central. The End Point is configured to get "Orders" and "Invoice" data. Now we have to filter out "Order Number" based on the initial string in the order number.

Q1 . How we can filter "Order " depending on the initials in the Order Number? 

Also, need to get some custom fields in the "Order" details from the Business Central. These custom fields are not getting fetched from there currently.

Q2. How can we get the custom field in the response from Business Central?


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply

Hi Girish,
There are events in the latest released Dynamicweb Plugin Unit for the D365BC Cloud version called:
from the codeunit 6211205 DynamicwebCustomerCenPublisher
GetListOnAfterFilteredSalesHeaders - this is where you can filter the "SalesHeader" object based on your custom logic.
GetListOnAfterFilteredSalesInvHeaders - for the invoices
GetListOnAfterFilteredSalesCrMemoHeaders - for the Cr.Memos

For the custom fields here is a help link with explanation.

BR, Dmitrij

 

You must be logged in to post in the forum