Skip to main content
Version: 2.2.0

newTableRecord

This method allows creating records in a SoftExpert Form pivot table. To use this method, it is necessary to follow the standard documented below:

Java class
Requestweb/wwwroot/ws/java/form/NewTableRecordRequestType.java
Returnweb/wwwroot/ws/java/form/NewTableRecordResponseType.java

Request:

ID #RequiredDescription
UserIDUser ID
TableIDTable ID #
TableFieldIDX¹Table field ID #
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
RelationshipIDX¹Relationship 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
IMPORTANT: The value entered must exist in the related table so that the system inputs it.
TableFileFieldIDX¹ID # of the file type field of the table
FileNameFile name (with extension)
FileContentBinary content of the file
RelatedRelationshipIDX¹ID # of the relationship with the main table.
This parameter will be used when the request is made for a grid table with the need to link the record to the main table.
RelatedRelationshipValueValue of the OID field of the main table record that will be related
info

X¹ - At least one of the parameters (TableFieldID, RelationshipID, TableFileFieldID, and RelatedRelationshipID) must be entered so that the record is added.

Request structure:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:form">
<soapenv:Header/>
<soapenv:Body>
<urn:newTableRecord>
<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:1365316695114</urn:FileContent>
</urn:TableFieldFile>
</urn:TableFieldFileList>
<urn:RelatedTo>
<urn:RelatedRelationshipID>?</urn:RelatedRelationshipID>
<urn:RelatedRelationshipValue>?</urn:RelatedRelationshipValue>
</urn:RelatedTo>
</urn:newTableRecord>
</soapenv:Body>
</soapenv:Envelope>

Return:

ID #Description
StatusSUCCESS: SUCCESS
FAILURE: FAILURE
CodeSUCCESS: 1 - Record successfully inserted
FAILURE: Negative return code
DetailSUCCESS:  Success return description
FAILURE: Description of the error that was found
RecordIDSUCCESS:  Record code added