You can create the following rule types in API Creator:
Use the icon that displays to the left of the rule in the list of rules as a visual indicator for the various rule types.
Sums designated child attribute, with optional child qualification condition.
Counts designated child rows using a defined relationship, with optional child qualification condition.
Derive an attribute value using other attributes in that entity, or parent entity (changes are propagated).
If a formula rule returns nothing, then the value of the column is unchanged:
Copy attribute from parent on creation.
Multi-attribute expression of class/parent attributes that must be met for a transaction to succeed.
Purchaseorder.NotEmptyon commit as:
Validation runs after all rows are processed.
Layer7 Live API Creatorexecutes whenever a row is inserted, updated, or deleted (when you have enabled the rule for that type of event).
For more information:
See the example for
allocateFromTosystem method. For more information about this method, see The allocateFromTo System Method.
For inserts, fires when
Layer7 Live API Creatormaps resource rows to table rows. This occurs in advance of the other event rules and is typically used to compute primary keys.
Minimum value of a child attribute, with optional child qualification condition.
Maximum value of a child attribute, with optional child qualification condition.
Automatically inserts a parent if it does not already exist.
Create parent for GroupBy, for example,
empsalesto track total sales for employee each month.