CData Python Connector for Avalara

Build 24.0.9060

Users

Users table for AvalaraAvatax data provider.

Insert

To create a new user the following fields should be specified. A newly created user will receive an email inviting them to create their password. This means that you must provide a valid email address for all user accounts created.

INSERT INTO Users (AccountId, UserName, FirstName, LastName, Email, securityRoleId) VALUES (2000137504, 'user123', 'James', 'Smith', '[email protected]', 'AccountUser')

Update

Only user selectable fields can be updated. To update a user, you need to specify Id and AccountId in WHERE clause.

UPDATE Users SET IsActive = true WHERE Id = 332668 AND AccountId = 2000137504

Delete

To delete a user, you need to specify Id and AccountId in WHERE clause.

DELETE FROM Users WHERE Id = 332668 AND AccountId = 2000137504

Columns

Name Type ReadOnly Description
Id [KEY] Int False

The unique ID number of this user.

AccountId [KEY] Int False

The unique ID number of the account to which this user belongs.

PostalCode String False

The postal code in which this user resides.

SecurityRoleId String False

The security level for this user.

ModifiedDate Datetime False

The date/time when this record was last modified.

PasswordStatus String False

The status of the user's password. For a new user created, this is always going to be `UserMustChange`.

Email String False

The email address to be used to contact this user. If the user has forgotten a password, an email can be sent to this email address with information on how to reset this password.

UserName String False

The username which is used to log on to the AvaTax website, or to authenticate against API calls.

CompanyId Int False

If this user is locked to one company (and its children), this is the unique ID number of the company to which this user belongs.

FirstName String False

The first or given name of the user.

LastName String False

The last or family name of the user.

IsActive Bool False

True if this user is currently active.

CreatedDate Datetime False

The date when this record was created.

PageKey String False

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060