newTableRecord

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

Request
ID #	Required	Description
UserID		User ID
TableID		Table ID #
TableFieldID	X1	Table field ID #
TableFieldValue		Table field value Notes according to the field type: •Number: numeric digits without thousand or decimal separators •Decimal: numeric digits without thousand separator and with dot (.) as decimal separator •Date: YYYY-MM-DD •Hour: HH:MM •Boolean: 0 or 1
RelationshipID	X1	Relationship ID #
RelationshipFieldID		Related table field ID #
RelationshipFieldValue		Related table field value Notes according to the field type: •Number: numeric digits without thousand or decimal separators •Decimal: numeric digits without thousand separator and with dot (.) as decimal separator •Date: YYYY-MM-DD •Hour: HH:MM •Boolean: 0 or 1 IMPORTANT: The value entered must exist in the related table so that the system inputs it.
TableFileFieldID	X1	ID # of the file type field of the table
FileName		File name (including its extension)
FileContent		Binary content of the file
RelatedRelationshipID	X1	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

Return
ID #	Description
Status	SUCCESS: SUCCESS FAILURE: FAILURE
Code	SUCCESS: 1 – Record successfully added FAILURE: Negative return code
Detail	SUCCESS: Success return description FAILURE: Description of the error that was found
RecordID	SUCCESS: Record code added