How to access User object via XML worksheet
This article provides the information about how to access the User object via XML worksheet.
For User, you can use XML request for the following:
- Inserting Users
- Updating Users
- Deleting Users
User
Inserting Users
Here is an example XML request to add a new User in TeamConnect via XML worksheet:
<TeamConnectRequest> <Authentication> <Username>george</Username> <Password>password</Password> </Authentication> <User> <IsLocked>0</IsLocked> <Contact keymap="SsOrTaxNumberString">623-52-8541</Contact> <Username>helen</Username> <ShortDescription>New temporary employee</ShortDescription> <Password>helen</Password> <UserTypeIID>1</UserTypeIID> <IsAccountActive>true</IsAccountActive> <IsActive>true</IsActive> <AccountExpiresOn>2005-09-15</AccountExpiresOn> <IsChangePasswordNextLogin>true</IsChangePasswordNextLogin> <GiveRightsToContact>true</GiveRightsToContact> <Group keymap="Name" action="default">Administrators</Group> <Group keymap="Name">Claim Administrators</Group> <Tool keymap="Name">Export Design</Tool> <Tool keymap="Name">Reassign Work</Tool> <Tool keymap="Name">Import Design</Tool> <Tool keymap="Name">Xml Worksheet</Tool> Rights to System Objects <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>PROJ_READ</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>PROJ_CREATE</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>PROJ_UPDATE</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>PROJ_DELETE</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>PROJ_ASSIGNEE_READ</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>PROJ_ASSIGNEE_CREATE</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>PROJ_ASSIGNEE_UPDATE</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>PROJ_ASSIGNEE_DELETE</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>PROJ_DETAIL_READ</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>PROJ_DETAIL_CREATE</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>PROJ_DETAIL_DELETE</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>PROJ_DETAIL_VALUE_READ</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>PROJ_DETAIL_VALUE_UPDATE</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>PROJ_PHASE_READ</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>PROJ_PHASE_UPDATE</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>PROJ_RELATION_READ</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>PROJ_RELATION_CREATE</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>PROJ_RELATION_DELETE</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>PROJ_SECURITY_READ</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>PROJ_SECURITY_UPDATE</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>INVL_READ</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>INVL_CREATE</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>INVL_UPDATE</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>INVL_DELETE</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>INVL_DETAIL_READ</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>INVL_DETAIL_CREATE</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>INVL_DETAIL_DELETE</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>INVL_DETAIL_VALUE_READ</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>INVL_DETAIL_VALUE_UPDATE</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>INVL_RELATION_READ</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>INVL_RELATION_CREATE</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>INVL_RELATION_DELETE</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>INVL_SECURITY_READ</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>INVL_SECURITY_UPDATE</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>MILE_READ</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>MILE_CREATE</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>MILE_UPDATE</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>MILE_DELETE</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>MILE_DETAIL_READ</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>MILE_DETAIL_CREATE</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>MILE_DETAIL_DELETE</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>MILE_DETAIL_VALUE_READ</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>MILE_DETAIL_VALUE_UPDATE</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>MILE_SECURITY_READ</OperationIID> </FunctionalOperation> <FunctionalOperation> <Application>CLAM</Application> <IsOperation>yes</IsOperation> <OperationIID>MILE_SECURITY_UPDATE</OperationIID> </FunctionalOperation> Category Rights <FunctionalOperation> <IsOperation>yes</IsOperation> <Application>CONT</Application> <Category>CONT_EMPL</Category> <OperationIID>REUS_DETAIL_READ</OperationIID> </FunctionalOperation> <FunctionalOperation> <IsOperation>yes</IsOperation> <Application>CONT</Application> <Category>CONT_EMPL</Category> <OperationIID>REUS_DETAIL_CREATE</OperationIID> </FunctionalOperation> <FunctionalOperation> <IsOperation>yes</IsOperation> <Application>CONT</Application> <Category>CONT_EMPL</Category> <OperationIID>REUS_DETAIL_VALUE_READ</OperationIID> </FunctionalOperation> <FunctionalOperation> <IsOperation>yes</IsOperation> <Application>CONT</Application> <Category>CONT_EMPL</Category> <OperationIID>REUS_DETAIL_VALUE_UPDATE</OperationIID> </FunctionalOperation> </User> </TeamConnectRequest>
Updating Users
Here is an example XML request to update an User in TeamConnect via XML worksheet:
<TeamConnectRequest>
<Authentication>
<Username>george</Username>
<Password>password</Password>
</Authentication>
<User op="update" Username="helen">
<ShortDescription>Helen will now be our outside counsel</ShortDescription>
<UserTypeIID>3</UserTypeIID>
<IsAccountActive>0</IsAccountActive>
<AccountExpiresOn></AccountExpiresOn>
<Group keymap="Name">Outside Counsel</Group>
<GroupMember op="delete" key="54" />
<GroupMember op="delete" key="55" />
<Tool op="delete" key="80" />
<Tool op="delete" key="81" />
<Tool op="delete" key="82" />
<Tool op="delete" key="83" />
<Tool keymap="Name">Full Tree</Tool>
<FunctionalOperation>
<IsOperation>no</IsOperation>
<OperationIID>CONT_DELETE</OperationIID>
</FunctionalOperation>
<FunctionalOperation>
<IsOperation>no</IsOperation>
<OperationIID>CONT_DETAIL_DELETE</OperationIID>
</FunctionalOperation>
<FunctionalOperation>
<IsOperation>no</IsOperation>
<OperationIID>CONT_RATE_DELETE</OperationIID>
</FunctionalOperation>
<FunctionalOperation>
<IsOperation>no</IsOperation>
<OperationIID>CONT_RELATION_DELETE</OperationIID>
</FunctionalOperation>
<FunctionalOperation>
<IsOperation>no</IsOperation>
<OperationIID>CONT_SKILL_DELETE</OperationIID>
</FunctionalOperation>
<FunctionalOperation>
<IsOperation>no</IsOperation>
<OperationIID>CONT_TERRITORY_DELETE</OperationIID>
</FunctionalOperation>
<FunctionalOperation>
<IsOperation>yes</IsOperation>
<Application>CONT</Application>
<Category>CONT_CLNT</Category>
<OperationIID>REUS_DETAIL_READ</OperationIID>
</FunctionalOperation>
<FunctionalOperation>
<IsOperation>yes</IsOperation>
<Application>CONT</Application>
<Category>CONT_CLNT</Category>
<OperationIID>REUS_DETAIL_CREATE</OperationIID>
</FunctionalOperation>
<FunctionalOperation>
<IsOperation>yes</IsOperation>
<Application>CONT</Application>
<Category>CONT_CLNT</Category>
<OperationIID>REUS_DETAIL_VALUE_READ</OperationIID>
</FunctionalOperation>
<FunctionalOperation>
<IsOperation>yes</IsOperation>
<Application>CONT</Application>
<Category>CONT_CLNT</Category>
<OperationIID>REUS_DETAIL_VALUE_UPDATE</OperationIID>
</FunctionalOperation>
<FunctionalOperation>
<IsOperation>no</IsOperation>
<Application>CONT</Application>
<Category>CONT_EMPL</Category>
<OperationIID>REUS_DETAIL_READ</OperationIID>
</FunctionalOperation>
<FunctionalOperation>
<IsOperation>no</IsOperation>
<Application>CONT</Application>
<Category>CONT_EMPL</Category>
<OperationIID>REUS_DETAIL_CREATE</OperationIID>
</FunctionalOperation>
<FunctionalOperation>
<IsOperation>no</IsOperation>
<Application>CONT</Application>
<Category>CONT_EMPL</Category>
<OperationIID>REUS_DETAIL_VALUE_READ</OperationIID>
</FunctionalOperation>
<FunctionalOperation>
<IsOperation>no</IsOperation>
<Application>CONT</Application>
<Category>CONT_EMPL</Category>
<OperationIID>REUS_DETAIL_VALUE_UPDATE</OperationIID>
</FunctionalOperation>
<FunctionalOperation>
<Application>CLAM</Application>
<IsOperation>no</IsOperation>
<OperationIID>PROJ_DELETE</OperationIID>
</FunctionalOperation>
<FunctionalOperation>
<Application>CLAM</Application>
<IsOperation>no</IsOperation>
<OperationIID>PROJ_ASSIGNEE_DELETE</OperationIID>
</FunctionalOperation>
<FunctionalOperation>
<Application>CLAM</Application>
<IsOperation>no</IsOperation>
<OperationIID>INVL_DELETE</OperationIID>
</FunctionalOperation>
<FunctionalOperation>
<Application>CLAM</Application>
<IsOperation>no</IsOperation>
<OperationIID>MILE_DELETE</OperationIID>
</FunctionalOperation>
</User>
</TeamConnectRequest>
Deleting User
Here is an example XML request to delete an User in TeamConnect via XML worksheet:
<TeamConnectRequest> <Authentication> <Username>george</Username> <Password>password</Password> </Authentication> <User op="delete" Username="helen" /> </TeamConnectRequest>