When

The when property allows you to control when a function, operation, guard, or error handler should execute. It uses a condition, typically based on the local state of the database. This makes functions more dynamic by ensuring they only run when certain conditions are met, helping to optimize performance, avoid redundant calls, and manage conditional logic efficiently.

• Conditionally skip function execution based on local state or query results.

• Prevent unnecessary API calls by checking if a condition has already been met.

• Dynamically execute operations or error handlers only under certain circumstances.

• Evaluate conditions on continuation unless configured otherwise.

Where to use the when property

Where	When
Main function	Determines whether the function should be executed. The when expression is evaluated after the parameters and queries are evaluated. The when expression is evaluated before token credentials are checked and inputTransforms are evaluated. The when expression is re-evaluated on each continuation.
Operations	Determines whether the operation should execute. Useful for selectively inserting, updating, or transforming data.
Error handler	Determines the conditions under which the error should be executed. Specify one or more error handling definitions. The first rule that matches the when condition will be used. A rule without a when condition will become the default error handler. If no rules are specified, default error handling will be used, i.e., checking for actual errors or using HTTP status codes and messages for REST providers.
Guard function	Evaluates whether the guard function should run, allowing conditional validation or control.

when

provider: DATA_PROVIDER_REST
method: DELETE
url: https://rest-data-service.net/api/v0.1/collections/books/items/{id}
when: [email protected]

Examples and code snippets

Conditional Function Execution

main-when-function

provider: DATA_PROVIDER_REST
url: https://graph.microsoft.com/v1.0/me/drive/root/children
method: GET
# Determine conditions when the main function executes.
when: [email protected] ? false:true 
useLocalCall: true

parameters:
  $top:
    location: query
    type: number
    required: false
  accessToken:
    location: header
    type: microsoft
    value: jigx.microsoft.oauth
    required: true
    
# In the function definition.
queries: 
  current-record: 
    statement: SELECT * FROM [local-countries] WHERE [id] = @id
    parameters:
      id: [email protected]
  existing-countries:
    statement: SELECT * FROM [local-countries]
    jsonColumns: [email protected]

Custom error handling error

This custom error message is shown only when the response status of 503 is recieved from the server.

when-error

error: 
  - title: Server is temporarily unavailable
    description: |
      The server is currently unavailable, please try again in a few minutes.
    details: [email protected]
    icon: on-error-sad
    notification: true
    operations:
      - type: operation.delete-insert
        table: [email protected] & "_error"
    # Condition that determines when a 503 custom error message executes.    
    when: [email protected] = 503