Parameters

Parameters are placeholders for values that are passed at runtime. The Table service type offers pre-defined service parameters and user-defined custom parameters.

Service Parameters

The following parameters can be added to the URL of Table services:

Custom Parameters

Custom parameters user defined placeholders for values that are passed at runtime. They can be used to create dynamic WHERE Clauses.

There are two types of custom parameters:

• Scalar parameters represent a single value.
• List parameters represent multiple values.

Scalar Parameters

Scalar parameters are single values that are used as placeholders. The placeholders need to be populated with actual values at runtime.

To create a scalar parameter:

1. Open the Custom Parameters tab.
2. Click [Add Scalar]. A new parameter is added to the list of parameters.
3. Select the parameter name and overwrite the parameter name with a name of your choice. This is important for parameter mapping when exposing the service to 3rd party tools or via MCP.
4. Select one of the following data types from the Type dropdown:
   • Text: Used for any type of SAP selection field.
   • Number: Used for numeric SAP selection fields.
   • Flag: Used for SAP selection fields that require an ‘X’ (true) or a blank ‘‘ (false) as input value.
5. Click [OK].

The parameter is added to the service.

List Parameters

List parameters contain multiple values separated by commas e.g., [value_1],[value_2],[value_n]. The placeholders need to be populated with actual values at runtime.

To create a list parameter:

1. Open the Custom Parameters tab.
2. Click [Add List]. A new parameter is added to the list of parameters.
3. Select the parameter name and overwrite the parameter name with a name of your choice. This is important for parameter mapping when exposing the service to 3rd party tools or via MCP.
4. Click [OK].

The parameter is added to the service.

Use Custom Parameters in WHERE-Clauses

Custom Parameters in the WHERE Clause Text Mode

Add an @ symbol before a value to mark it as a runtime parameter, e.g., enter @myParameter instead of a value. Example:

T001W~WERKS BETWEEN @PlantLow AND @PlantHigh

Custom Parameters in the WHERE Clause Editor Mode

To use custom parameters in the WHERE clause editor mode:

1. Open the WHERE clause editor.
2. Add a new WHERE clause criteria.
3. Click the Parameter component ([]). parameter dropdown list is added to the criteria.
4. Select a custom parameter from the dropdown list.
   

The parameter is added to the WHERE clause and must be replaced with an actual value at runtime.

Pass Values at Runtime

There are two ways to populate parameters with values at runtime:

• Add the parameter / value pairs to the service URL, see Pass Query Parameters.
• Add the parameters / value pairs in the request body of the service call, see Pass Body Parameters.

For more information, see Runtime Parameters.