Tableau Connector for Sage Business Cloud Accounting

Build 22.0.8342

ContactPeople

Query ContactPeople in Sage Business Cloud Accounting.

Table Specific Information

Query the available ContactPeople

Select

The driver uses the Sage Accounting API to process search criteria that refer to AddressId,UpdatedOrCreatedSince,DeletedSince,ContactId columns. The driver processes other filters client-side within the driver.

  • AddressId supports the '=' operator.
  • UpdatedOrCreatedSince supports the '=' operator.
  • DeletedSince supports the '=' operator.
  • ContactId supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM ContactPeople WHERE AddressId='c04b66f130d14478b7978452aeedb8ad'
SELECT * FROM ContactPeople WHERE UpdatedOrCreatedSince='2019-10-02T11:46:53Z'
SELECT * FROM ContactPeople WHERE DeletedSince='2019-10-02T11:46:53Z'
SELECT * FROM ContactPeople WHERE ContactId='c04b66f130d16538b7978452aeedb8ad'

Delete

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

DELETE FROM ContactPeople WHERE id ='69d00f6931614e3fbb7ccad85fb84af0' 

Columns

Name Type ReadOnly References Description
Id [KEY] String False

The unique identifier for the item

CreatedAt Datetime True

The datetime when the item was created

DisplayedAs String False

The name of the resource

Mobile String False

The mobile number of the contact person

Name String False

The name of the contact person

Fax String False

The fax number of the contact person

Telephone String False

The telephone number of the contact person

ContactPersonTypeAggregate String False

The contact person types for the contact person

Email String False

The email address of the contact person

UpdatedAt Datetime True

The datetime when the item was last updated

DeletedAt Datetime True

The datetime when the item was deleted

LegacyId Int False

The legacy ID for the item

IsMainContact Bool False

Indicates whether this is the main contact person

AddressId String False

Addresses.Id

The unique identifier for the item

JobTitle String False

The job title of the contact person

IsPreferredContact Bool False

Indicates that this contact person is a preferred contact

DeletedSince Datetime True

ContactId String False

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