newTableRecordList

This method allows adding multiple records to a SoftExpert Form pivot table.

To use this method, it is necessary to follow the standard documented below.

danger

• The web service supports on average the insertion of 100 records per request, considering a table with 10 columns. The capacity of records processed per request will vary depending on server configurations. The number of columns also impacts processing.
• If it is necessary to use numbers higher than the one mentioned in the previous paragraph, we recommend running tests in the test environment before using the resource in the production environment.

Java class
Request	web/wwwroot/ws/java/form/NewTableRecordListRequestType.java
Return	web/wwwroot/ws/java/form/NewTableRecordListResponseType.java

Request:

ID #	Required	Description
UserID		User ID
TableID	X	Table ID #
FormRecordList	X	Matrix; Grouper of multiple records that will be added
Record	X	Matrix; Grouper of the record that will be added
TableFieldList	X	Matrix; Grouper of multiple table fields that will be added to the record
TableField	X	Matrix; Table field grouper
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

Request structure:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:form">
   <soapenv:Header/>
   <soapenv:Body>
      <urn:newTableRecordList>
         <!--You may enter the following 3 items in any order-->
         <urn:UserID>?</urn:UserID>
         <urn:TableID>?</urn:TableID>
         <urn:FormRecordList>
            <!--1 to 1000 repetitions:-->
            <urn:Record>
               <urn:TableFieldList>
                  <!--Zero or more repetitions:-->
                  <urn:TableField>
                     <!--You may enter the following 2 items in any order-->
                     <urn:TableFieldID>?</urn:TableFieldID>
                     <urn:TableFieldValue>?</urn:TableFieldValue>
                  </urn:TableField>
               </urn:TableFieldList>
            </urn:Record>
         </urn:FormRecordList>
      </urn:newTableRecordList>
   </soapenv:Body>
</soapenv:Envelope>

Return:

ID #	Description
RecordListResponse	SUCCESS: Returns a vector with the metadata: • RecordListResponse: Matrix; Records o Record: Record ▪Returns a message about success or about the error found
Status	FAILURE: FAILURE
Code	FAILURE: Negative return code
Detail	FAILURE: Description of the error that was found