Contacts
Contacts table for AvalaraAvatax data provider.
Select
The provider will use the Avalara API to process WHERE clause conditions built with the following columns and operators. Most of the columns support server side filtering with the following operators: =,>,<,<=,>=,IN,NOT,IN,AND,OR,LIKE. The rest of the filter is executed client side within the provider.
For example, the following query is processed server side:
SELECT * FROM Contacts WHERE companyid = 247015 SELECT * FROM Contacts WHERE companyid = 247015 AND region = 'NY'
Insert
To add a Contact, ContactCode is a required field.
INSERT INTO Contacts (companyId, contactCode, firstName, lastName, title, line1, city, region, postalCode, country, email, phone) VALUES ('247015', 'TestContactc7356131ca2442', " + "'Bob', 'McExample', 'Owner', '2000 Main Street', 'Irvine', 'CA', '92614', 'US', '[email protected]', '714 555-1212')
Update
Avalara allows updates Contacts columns. To update a Contact, Id and CompanyId should be specified in the WHERE clause of the Update statement.
UPDATE Contacts SET firstName = 'tidra' WHERE CompanyId = 247015 AND Id = 175596
Delete
Contacts can be deleted by providing the Companyid and Id of the Contact and issuing a DELETE statement.
DELETE FROM Contacts WHERE Id = 100
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | Int | False |
The unique ID number of this contact. |
FirstName | String | False |
The first or given name of this contact. |
CreatedUserId | Int | False |
The User ID of the user who created this record. |
Mobile | String | False |
The mobile phone number for this contact. |
Region | String | False |
Name or ISO 3166 code identifying the region within the country. |
ModifiedDate | Datetime | False |
The date/time when this record was last modified. |
Phone | String | False |
The main phone number for this contact. |
Line3 | String | False |
The third line of the postal mailing address of this contact. |
PostalCode | String | False |
The postal code or zip code of the postal mailing address of this contact. |
Line2 | String | False |
The second line of the postal mailing address of this contact. |
Line1 | String | False |
The first line of the postal mailing address of this contact. |
LastName | String | False |
The last or family name of this contact. |
ModifiedUserId | Int | False |
The user ID of the user who last modified this record. |
CompanyId [KEY] | Int | False |
The unique ID number of the company to which this contact belongs. |
String | False |
The email address of this contact. | |
Country | String | False |
Name or ISO 3166 code identifying the country. |
City | String | False |
The city of the postal mailing address of this contact. |
MiddleName | String | False |
The middle name of this contact. |
Fax | String | False |
The facsimile phone number for this contact. |
CreatedDate | Datetime | False |
The date when this record was created. |
Title | String | False |
Professional title of this contact. |
ContactCode | String | False |
A unique code for this contact. |
PageKey | String | False |