Upload Users/Groups

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

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]