SSIS Components for Sage Business Cloud Accounting

Build 24.0.9062

UnallocatedArtefacts

Query UnallocatedArtefacts in Sage Business Cloud Accounting.

Table Specific Information

Query the available UnallocatedArtefacts

Select

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

  • ContactId supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM UnallocatedArtefacts WHERE ContactId = 'abc'

Columns

Name Type References Description
Id [KEY] String The unique identifier for the item
LinksAggregate String Links for the resource
DisplayedAs String The name of the resource
LegacyId Int The legacy ID for the item
ContactId String

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