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 |