Power BI Connector for Xero WorkflowMax

Build 21.0.8137

ClientContacts

Return a list of all contacts of clients.

Select

The {i will use the your data source API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the driver. Specifically, the following are processed server-side:

  • UUID supports the '=' operator.

All filterable columns allow multiple values to be specified by using the IN operator. Response time from the server can be improved by identifying only the rows you want to retrieve.

SELECT * FROM ClientContacts WHERE UUID = '3cfb9bd0-dac7-40d0-8fb7-db8e23d14bd9'
SELECT * FROM ClientContacts WHERE UUID IN ('3cfb9bd0-dac7-40d0-8fb7-db8e23d14bd9', 'd807cf4c-a2b9-428a-82e7-124b4f3ddab4')

Insert

ClientUUID and Name are required to insert. The following query creates a new ClientContact:

INSERT INTO ClientContacts (ClientUUID, Name) VALUES ('c6ec5c2c-2657-4ce3-b035-022c02b9f19e', 'Rambo')

Update

You can update a ClientContact by specifying the ClientContact UUID:

UPDATE ClientContacts SET Name = 'Arnold' WHERE UUID='3cfb9bd0-dac7-40d0-8fb7-db8e23d14bd9'

Delete

Delete a ClientContact by specifying the ClientContact UUID:

DELETE FROM ClientContacts WHERE UUID = '3cfb9bd0-dac7-40d0-8fb7-db8e23d14bd9'

Columns

Name Type ReadOnly Description
ClientUUID String False

The ID of the client

UUID [KEY] String True

The id of the contact which belongs to the client

Name String False

The name of the contact

Mobile String False

Mobile number of the contact

Email String False

Email of the contact

Phone String False

Phone number of the contact

Position String False

The position of the contact

Salutation String False

Salutation is used following 'Dear...

Addressee String False

The addresse of the contact

IsPrimary String False

Determines if this contact is the main contact used by client Yes | No

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