How to access Document object via XML worksheet

Last updated
Save as PDF

This article provides the information about how to access the Document object via XML worksheet.

For Document, you can use XML request for the following:

Inserting Documents (Residing on Application Server)
Inserting Documents (Embedded within XML Request)
Deleting Documents

Document

Inserting Documents (Residing on Application Server)

Here is an example XML request to add a new documents (Residing on Application Server) in TeamConnect via XML worksheet:

<TeamConnectRequest>
<Authentication>
    <Username>george</Username>
    <Password>password</Password>
</Authentication>
<Project op="update" NumberString="LITI-000801" Application.ProjObjectDefinition.UniqueCode="LITI" action="getNonNullDocumentFolder"/>
<Document op="insert" type="L">
    <ParentFolder>Root/Attachments/Litigations/LITI-000801</ParentFolder>
    <Content method="path">D:\Contract.DOC</Content>
    <Name>Pfizer.DOC</Name>
    <ContentType>5</ContentType>
    <Author keymap="Name">CONVERSION</Author>
    <AuthorDate>2005-12-01</AuthorDate>
    <CheckedInBy>Conversion</CheckedInBy>
</Document>
</TeamConnectRequest>

Inserting Documents (Embedded within XML Request)

Here is an example XML request to update an Document (Embedded within XML Request) in TeamConnect via XML worksheet:


<TeamConnectRequest>
<Authentication>
    <Username>george</Username>
    <Password>password</Password>
</Authentication>
<Project op="update" NumberString="14" Application.ProjObjectDefinition.UniqueCode="MATT" action="getNonNullDocumentFolder"/>
<Document op="insert" type="L">
<ParentFolder>Root/Attachments/Matters/14</ParentFolder>
<Name>export.xml</Name>
 
<Content><![CDATA[PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4NCjx UZWFtQ29ubmVjdFJlcXVl
c3Q+PEltcG9ydCBlbnRpdHlDb2RlPSJUSUNLIiBuYW1lPSJPYmplY3REZWZpbml0aW9uIiB0e XBl
PSJjdXN0b20iPjxHZW5lcmFsIGljb25GaWxlTmFtZT0iIiBpc0NvbnRhY3RDZW50cmljPSJmY Wxz
ZSIgaXNOb3REaXNwbGF5ZWRJbk1lbnU9ImZhbHNlIiBvYmplY3RUaXRsZT0iVGlja2xlciIgb 2Jq
ZWN0VGl0bGVQbHVyYWw9IlRpY2tsZXJzIiBvcmRlcj0iMCIgcGFyZW50PSJNVEVSIiBwYXJlb nRS
ZXF1aXJlZD0iZmFsc2UiIHNlbGVjdGlvbk1ldGhvZD0iMiI+PC9HZW5lcmFsPg0KPERldGFpb EZp
ZWxkcyBlbnRpdHlDb2RlPSJUSUNLIj48Q2F0ZWdvcnkga2V5PSJUSUNLIiBuYW1lPSJUaWNrb GVy
IiBvcmRlcj0iMCIgc2l6ZT0iNiI+PEZpZWxkIGRlZmF1bHRWYWx1ZT0ibnVsbCIgZXh0cmFpb mZv
PSJFdmVudCBEYXRlIiBpc0RhdGFNYXJ0PSJubyIgaXNSZXF1aXJlZD0ibm8iIG5hbWU9IlRpR GF0
ZSIgdHlwZUlJRD0iMyI+PC9GaWVsZD4NCjxGaWVsZCBkZWZhdWx0VmFsdWU9Im51bGwiIGV4d HJh
aW5mbz0iVGlja2xlciBUeXBlIiBpc0RhdGFNYXJ0PSJubyIgaXNSZXF1aXJlZD0ibm8iIG5hb WU9
IlRpVHlwZSIgdGFibGU9IlRJVFkiIHR5cGVJSUQ9IjYiPjwvRmllbGQ+DQo8RmllbGQgZGVmY XVs
dFZhbHVlPSJudWxsIiBleHRyYWluZm89IlNlbmQgQ0MgVG8iIGlzRGF0YU1hcnQ9Im5vIiBpc 1Jl
cXVpcmVkPSJubyIgbmFtZT0iVGlTZW5kQ0NUbyIgcm9sZT0iVElDSV9DQ1RPIiB0eXBlSUlEP SI4
Ij48L0ZpZWxkPg0KPEZpZWxkIGRlZmF1bHRWYWx1ZT0ibnVsbCIgZXh0cmFpbmZvPSJEYXlzI FBy
aW9yIFRvIFNlbmQgRW1haWwiIGlzRGF0YU1hcnQ9Im5vIiBpc1JlcXVpcmVkPSJubyIgbmFtZ T0i
VGlEYXlzUHJpb3IiIHR5cGVJSUQ9IjIiPjwvRmllbGQ+DQo8RmllbGQgZGVmYXVsdFZhbHVlP SJu
dWxsIiBleHRyYWluZm89IlNlbmQgRW1haWwgVG8iIGlzRGF0YU1hcnQ9Im5vIiBpc1JlcXVpc mVk
PSJubyIgbmFtZT0iVGlTZW5kRW1haWxUbyIgcm9sZT0iVElDSV9TRVRPIiB0eXBlSUlEPSI4I j48
L0ZpZWxkPg0KPEZpZWxkIGRlZmF1bHRWYWx1ZT0ibnVsbCIgZXh0cmFpbmZvPSJEZXNjcmlwd Glv
biIgaXNEYXRhTWFydD0ibm8iIGlzUmVxdWlyZWQ9Im5vIiBuYW1lPSJUaURlc2MiIHR5cGVJS UQ9
IjkiPjwvRmllbGQ+DQo8L0NhdGVnb3J5Pg0KPC9EZXRhaWxGaWVsZHM+DQo8L0ltcG9ydD4NC jwv
VGVhbUNvbm5lY3RSZXF1ZXN0Pg0K]]></Content>
        <ContentType>17</ContentType>
        <Author keymap="Name">system</Author>
        <AuthorDate>2006-12-27</AuthorDate>
        <CheckedInBy>system</CheckedInBy>
    </Document>
</TeamConnectRequest>

Deleting Documents

Here is an example XML request to delete a Document in TeamConnect via XML worksheet:

<TeamConnectRequest>
<Authentication>
    <Username>george</Username>
    <Password>password</Password>
</Authentication>
<Document op="delete" Name="Carter" NumberString="Emp035295" />
</TeamConnectRequest>

Deleting Document relations

Here is an example XML request to delete Document relations in TeamConnect via XML worksheet.
In this example, the document that we wish to delete is named "completely_disposable.doc".

<TeamConnectRequest>
<Authentication>
    <Username>fred</Username>
    <Password>fred</Password>
</Authentication>
<Document op="delete" name="completely_disposable.doc">
</Document>
</TeamConnectRequest>