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 | |
---|---|
Request | web/wwwroot/ws/java/form/NewTableRecordRequestType.java |
Return | web/wwwroot/ws/java/form/NewTableRecordResponseType.java |
Request:
ID # | Required | Description |
---|---|---|
UserID | User ID | |
TableID | Table ID # | |
TableFieldID | X¹ | Table field ID # |
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 • Time: HH:MM • Boolean: 0 or 1 | |
RelationshipID | X¹ | 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 • Time: HH:MM • Boolean: 0 or 1 IMPORTANT: The value entered must exist in the related table so that the system inputs it. | |
TableFileFieldID | X¹ | ID # of the file type field of the table |
FileName | File name (with extension) | |
FileContent | Binary content of the file | |
RelatedRelationshipID | X¹ | 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. |
RelatedRelationshipValue | Value 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 |
---|---|
Status | SUCCESS: SUCCESS FAILURE: FAILURE |
Code | SUCCESS: 1 - Record successfully inserted FAILURE: Negative return code |
Detail | SUCCESS: Â Success return description FAILURE: Description of the error that was found |
RecordID | SUCCESS: Â Record code added |