Skip to main content
Version: 2.2.0

editTableRecord

This method allows editing a SoftExpert Suite pivot table record (DYN):

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

Java class
Requestweb/wwwroot/ws/java/form/EditTableRecordRequestType.java
Returnweb/wwwroot/ws/java/form/EditTableRecordResponseType.java

Request:

ID #RequiredDescription
UserXID of the user that edited the record
TableIDXTable ID #
TableFieldOIDXRecord OID column in the table
TableFieldIDTable 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
TableFieldValueTable 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
• Time: HH:MM
• Boolean: 0 or 1
TableFileFieldIDID # of the file type field of the table
FileNameFile name (with extension)
FileContentBinary content of the file
RelationshipIDRelationship ID #
RelationshipFieldIDRelated table field ID #
RelationshipFieldValueRelated 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
• Time: 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:UserID>?</urn:UserID>
<urn:TableID>?</urn:TableID>
<urn:TableFieldOID>?</urn:TableFieldOID>
<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
StatusSUCCESS: SUCCESS
FAILURE: FAILURE
CodeSUCCESS: 1 - Record edited successfully
FAILURE: The system will return a negative number, depending on which error was found.
DetailSUCCESS: The method executed successfully description will be returned
FAILURE: The description of the error that was found will be returned