Power BI Connector for Sage Business Cloud Accounting

Build 24.0.9060

HostedArtefactPaymentSettings

Query HostedArtefactPaymentSettings in Sage Business Cloud Accounting.

Table Specific Information

Query the available HostedArtefactPaymentSettings

Select

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

  • ObjectGuid supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM HostedArtefactPaymentSettings WHERE ObjectGuid = 'abc'

Delete

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

DELETE FROM HostedArtefactPaymentSettings WHERE id = '123' 

Columns

Name Type ReadOnly References Description
Id [KEY] String False

The unique identifier for the item

ObjectGuid String False

The sageone_guid of the object you are disabling card payments for.

DisplayedAs String False

The name of the resource

DisablePayment Bool False

The flag to disable online payments.

LegacyId Int False

The legacy ID for the item

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060