...
Sample Data Uploader Script for Users/Groups
This is a sample script to add users or user groups via the Data Uploader to the configured external systems.
Note: When you include special characters such as parentheses, spaces, or dashes (-) in the phone number while submitting a job, CAM removes the special characters from the phone number and prepends the plus + sign to the country code in the phone number while saving on the AWS. For example, the US phone number will look similar to this format +14325551212.
Sample Script
| Code Block |
|---|
SELECT
'alexey' as [FirstName],
'marcus' as [LastName],
'm' as [MiddleName],
'alexey.marcus' as [DisplayName],
'alexey.marcus@prosperoware.com' as [PrimaryEmail],
'alexey.marcus@gmail.com' as [SecondaryEmail],
'alexey001' as[UserId],
'user'as[Type],
'group'as[Groups],
'n' as [NetDocs],
'y' as[IManage],
6528527899+14325551212 as[Telephone],
'California'as[Office],
'Address Street'as[StreetAddress],
'CA'as[City],
1885 as[PostalCode],
'Country'as[Country],
'CAMuser'as[JobTitle],
'Litigation'as[Department],
'companyid' as [Company Id],
'DEMO'as[RecordType] |
...