Services88 DatabaseTable Upsert

• 1 minute to read

SOAP request and response examples Remote/Services88/DatabaseTable.svc Implemented by the SuperOffice.Services88.IDatabaseTableAgent.Upsert method.

Upsert

WSDL file for Services88/DatabaseTable

Obtain a ticket from the Services88/SoPrincipal.svc

Application tokens must be specified if calling an Online installation. ApplicationTokens are not checked for on-site installations.

Upsert Request

<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope
 xmlns:SOAP-ENV="http://www.w3.org/2003/05/soap-envelope"
 xmlns:SOAP-ENC="http://www.w3.org/2003/05/soap-encoding"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xmlns:xsd="http://www.w3.org/2001/XMLSchema"
 xmlns:NetServerServices882="http://schemas.microsoft.com/2003/10/Serialization/Arrays"
 xmlns:NetServerServices881="http://schemas.microsoft.com/2003/10/Serialization/"
 xmlns:DatabaseTable="http://www.superoffice.net/ws/crm/NetServer/Services88">
  <DatabaseTable:ApplicationToken>1234567-1234-9876</DatabaseTable:ApplicationToken>
  <DatabaseTable:Credentials>
    <DatabaseTable:Ticket>7T:1234abcxyzExample==</DatabaseTable:Ticket>
  </DatabaseTable:Credentials>
 <SOAP-ENV:Body>
   <DatabaseTable:Upsert>
    <DatabaseTable:TableName xsi:type="xsd:string"></DatabaseTable:TableName>
    <DatabaseTable:Columns xsi:type="NetServerServices882:ArrayOfstring">
     <NetServerServices882:string xsi:type="xsd:string"></NetServerServices882:string>
    </DatabaseTable:Columns>
    <DatabaseTable:Keys xsi:type="NetServerServices882:ArrayOfstring">
     <NetServerServices882:string xsi:type="xsd:string"></NetServerServices882:string>
    </DatabaseTable:Keys>
    <DatabaseTable:Data xsi:type="NetServerServices882:ArrayOfArrayOfstring">
     <NetServerServices882:ArrayOfstring xsi:type="NetServerServices882:ArrayOfstring">
      <NetServerServices882:string xsi:type="xsd:string"></NetServerServices882:string>
     </NetServerServices882:ArrayOfstring>
    </DatabaseTable:Data>
    <DatabaseTable:NomatchAction xsi:type="DatabaseTable:UpsertNomatchAction">NoChange</DatabaseTable:NomatchAction>
    <DatabaseTable:ReturnRowStatus xsi:type="xsd:boolean">false</DatabaseTable:ReturnRowStatus>
   </DatabaseTable:Upsert>

 </SOAP-ENV:Body>
</SOAP-ENV:Envelope>

Upsert Response

<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope
 xmlns:SOAP-ENV="http://www.w3.org/2003/05/soap-envelope"
 xmlns:SOAP-ENC="http://www.w3.org/2003/05/soap-encoding"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xmlns:xsd="http://www.w3.org/2001/XMLSchema"
 xmlns:NetServerServices882="http://schemas.microsoft.com/2003/10/Serialization/Arrays"
 xmlns:NetServerServices881="http://schemas.microsoft.com/2003/10/Serialization/"
 xmlns:DatabaseTable="http://www.superoffice.net/ws/crm/NetServer/Services88">
 <SOAP-ENV:Body>
  <DatabaseTable:UpsertResponse>
   <DatabaseTable:Response xsi:type="DatabaseTable:MassOperationResult">
    <DatabaseTable:Success xsi:type="xsd:boolean">false</DatabaseTable:Success>
    <DatabaseTable:Message xsi:type="xsd:string"></DatabaseTable:Message>
    <DatabaseTable:Inserts xsi:type="xsd:int">0</DatabaseTable:Inserts>
    <DatabaseTable:Updates xsi:type="xsd:int">0</DatabaseTable:Updates>
    <DatabaseTable:Deletes xsi:type="xsd:int">0</DatabaseTable:Deletes>
    <DatabaseTable:RowStatus xsi:type="DatabaseTable:ArrayOfUpsertRowStatus">
     <DatabaseTable:UpsertRowStatus xsi:type="DatabaseTable:UpsertRowStatus">
      <DatabaseTable:PrimaryKey xsi:type="xsd:int">0</DatabaseTable:PrimaryKey>
      <DatabaseTable:Action xsi:type="DatabaseTable:UpsertRowActionStatus">Inserted</DatabaseTable:Action>
      <DatabaseTable:RowKeys xsi:type="NetServerServices882:ArrayOfstring">
       <NetServerServices882:string xsi:type="xsd:string"></NetServerServices882:string>
      </DatabaseTable:RowKeys>
     </DatabaseTable:UpsertRowStatus>
    </DatabaseTable:RowStatus>
   </DatabaseTable:Response>
  </DatabaseTable:UpsertResponse>
 </SOAP-ENV:Body>
</SOAP-ENV:Envelope>