query_odata
Execute flexible OData queries on SAP SuccessFactors entities with filtering, field selection, pagination, and sorting.
Instructions
Execute a flexible OData query against any SAP SuccessFactors entity.
Supports filtering, field selection, navigation expansion, pagination, and sorting.
Examples:
Active employees: entity='EmpEmployment', filter="endDate eq datetime'9999-12-31T00:00:00'"
Company details: entity='FOCompany', select='externalCode,name,country'
Job info with company: entity='EmpJob', expand='companyNav', top=5
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"entity": "<entity>"
},
"name": "query_odata"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top | No | Max records to return (1-1000) | |
| skip | No | ||
| entity | Yes | OData entity name (e.g., 'EmpJob', 'User', 'FOCompany') | |
| expand | No | ||
| filter | No | ||
| select | No | ||
| orderby | No | ||
| data_center | No | ||
| auth_user_id | No | ||
| auth_password | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||