Power BI Connector for Xero WorkflowMax

Build 21.0.8137

SupplierContacts

Return a list of all suppliers.

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 SupplierContacts WHERE UUID IN ('9d382fcf-7013-4d97-8dd8-c08e8b26a0b2', '9d382fcf-7013-4d97-8dd8-c08e8b26a5hj')
SELECT * FROM SupplierContacts WHERE UUID='9d382fcf-7013-4d97-8dd8-c08e8b26a0b2'

Insert

SupplierUUID, Name are required to insert. The following query creates a new SupplierContact:

INSERT INTO SupplierContacts (SupplierUUID, Name) VALUES ('9d382fcf-7013-4d97-8dd8-c08e8b26a0b2', 'ckemi')

Update

You can update a SupplierContact by specifying the SupplierContact UUID:

UPDATE SupplierContacts SET Name='hey@gmail.com', Mobile='23489235' WHERE UUID='9d382fcf-7013-4d97-8dd8-c08e8b26a0b2'

Columns

Name Type ReadOnly Description
SupplierUUID String False

The ID of the supplier.

UUID [KEY] String True

The id of the contact which belongs to the supplier.

Name String False

The name of the contact.

Mobile String False

The mobile number of the contact.

Email String False

The email of the contact.

Phone String False

The phone number of the contact.

Position String False

The position of the contact.

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