editTableRecord

This method allows editing a form record associated with the SoftExpert Suite company:

To insert each of these items, it is necessary to follow the standard documented below.

Java class
Request	web/wwwroot/ws/java/administration/EditTableRecordRequestType.java
Return	web/wwwroot/ws/java/administration/EditTableRecordResponseType.java

Request:

ID #	Required	Description
IdCommercial	X	Company name
User	X	ID of the user that edited the record
TableID		Table ID #
TableFieldID		Table field ID #. Comments: • If a blank field is entered, the value will be edited to empty; • If there is a table field that has not had its ID # entered in the request, its value will remain the same.
TableFieldValue		Table field value. Notes according to the field type: • Number: numeric digits without thousand and decimal separators; • Decimal: numeric digits without thousand separator and with period (.) as decimal separator; • Date: YYYY-MM-DD; • Hour: HH:MM; • Boolean: 0 or 1.
TableFileFieldID		ID # of the file type field of the table
FileName		File name (with extension)
FileContent		Binary content of the file
RelationshipID		Relationship ID #
RelationshipFieldID		Related table field ID #
RelationshipFieldValue		Related table field value. Notes according to the field type: • Number: numeric digits without thousand and decimal separators; • Decimal: numeric digits without thousand separator and with period (.) as decimal separator; • Date: YYYY-MM-DD; • Hour: HH:MM; • Boolean: 0 or 1.

Request structure:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:form">
   <soapenv:Header/>
   <soapenv:Body>
      <urn:editTableRecord>
         <urn:IdCommercial>?</urn:IdCommercial>
         <urn:UserID>?</urn:UserID>
         <urn:TableID>?</urn:TableID>
         <urn:TableFieldList>
            <urn:TableField>
               <urn:TableFieldID>?</urn:TableFieldID>
               <urn:TableFieldValue>?</urn:TableFieldValue>
            </urn:TableField>
         </urn:TableFieldList>
         <urn:RelationshipList>
            <urn:Relationship>
               <urn:RelationshipID>?</urn:RelationshipID>
               <urn:RelationshipField>
                  <urn:RelationshipFieldID>?</urn:RelationshipFieldID>
                  <urn:RelationshipFieldValue>?</urn:RelationshipFieldValue>
               </urn:RelationshipField>
            </urn:Relationship>
         </urn:RelationshipList>
         <urn:TableFieldFileList>
            <urn:TableFieldFile>
               <urn:TableFieldID>?</urn:TableFieldID>
               <urn:FileName>?</urn:FileName>
               <urn:FileContent>cid:1036611368430</urn:FileContent>
            </urn:TableFieldFile>
         </urn:TableFieldFileList>
      </urn:editTableRecord>
   </soapenv:Body>
</soapenv:Envelope>

Return:

ID #	Description
Status	SUCCESS: SUCCESS FAILURE: FAILURE
Code	SUCCESS: 1 – Record edited successfully FAILURE: The system will return a negative number, depending on which error was found
Detail	SUCCESS: The method executed successfully description will be returned FAILURE: The description of the error that was found will be returned