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