New

Thank you for adding this item to Sage City Ideas Hub.  Open for voting.

Include the active status in the product_price_views API endpoint

The Sage 200 Professional API `product_price_views` endpoint ignores the `active` property on the product. It returns prices for all products regardless of their status with no way to differentiate whether or not they are an active product or one that has been retired. This reduces users to having to find some kind of workaround to obtain this data or renders the endpoint useless.

I would suggest three options:

  • Don't return prices for products that are not active.
  • Add an `active` field to the response so it is possible to filter out inactive products on the client side.
  • Add a filter property to the request that allows integrators to choose whether to show active, inactive or all prices.

The same also goes for prices where the product is marked as sales order and invoicing are disabled.