Return a list of all staff members
The connector 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 StaffList WHERE UUID='9d382fcf-7013-4d97-8dd8-c08e8b26a0b2' SELECT * FROM StaffList WHERE UUID IN ('9d382fcf-7013-4d97-8dd8-c08e8b26a0b2', '9d382fcf-7013-4d97-8dd8-c08e8b26a9f6')
Name is required to insert. The following query creates a new StaffList member:
INSERT INTO StaffList (Name) VALUES ('J000002')
You can update a Staff member by specifying the Staff member UUID:
UPDATE StaffList SET Emailemail@example.com', Phone='23489235' WHERE UUID='9d382fcf-7013-4d97-8dd8-c08e8b26a0b2'
Delete a Staff member by specifying the Staff member UUID:
DELETE FROM StaffList WHERE UUID='9d382fcf-7013-4d97-8dd8-c08e8b26a0b2'
The staff member identifier.
The staff member name.
The staff member email.
The staff member phone number.
The staff member mobile number.
The staff member address.
Payroll code for the staff member.