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 |