Power BI Connector for Sage Business Cloud Accounting

Build 22.0.8342


Query ProductSalesPriceTypes in Sage Business Cloud Accounting.

Table Specific Information

Query the available ProductSalesPriceTypes


The driver uses the Sage Accounting API to process search criteria that refer to Active column. The driver processes other filters client-side within the driver.

  • Active supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM ProductSalesPriceTypes WHERE Active=false


Updates are performed based on Id.

UPDATE ProductSalesPriceTypes SET Name='Selling Price' WHERE Id='c9ec71a1fe5c4916a72a9efc22324663'


You must specify the Id of the ProductSalesPriceTypes to delete it.

DELETE FROM ProductSalesPriceTypes WHERE id ='c9ec71a1fe5c4916a72a9efc22324663' 


Name Type ReadOnly References Description
Id [KEY] String False

The unique identifier for the item

UpdatedAt Datetime True

The datetime when the item was last updated

Name String False

The name of the product sales price type

DisplayedAs String False

The name of the resource

CreatedAt Datetime True

The datetime when the item was created

Active Bool False

Indicates whether the price type is displayed in the application

LegacyId Int False

The legacy ID for the item

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 22.0.8342