...
This is a sample script to add users or user groups via the Data Uploader to the configured external systems.
Note: When you include a special character characters such as parentheses, spaces, or dashes (-) in the phone number while submitting the a job. , CAM removes the special character characters from the phone number . Programmatically, it and prepends the “plus +” sign with to the country code in the phone number while saving on the AWS. E.g., The For example, the US phone number format must be - 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],
+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] |
...