Search records using OData query action

Retrieves the records that match a specific OData query.

Input fields

• Object

• Select the SuccessFactors object. Because objects can have similar names, the list includes their internal names.

• Query

• Enter the OData query filters.

  See SAP documentation to learn more about filtering with the OData v2 API.

• Output fields

• By default, Workato will fetch all available fields in the selected record. You may use this input to filter for only the output fields you need.

  Optional field.

• Page size

• Specify the maximum number of records that a recipe returns.

  The maximum value for this field is 1000 records.

  Optional field.

• Offset

• Specify the number of records to skip.

  Optional field.

• From date

• Pick a date or enter it in MM/DD/YYYY format. SuccessFactors returns records from “from date” to the effective end date. You must not use “from date” together with “as of date”.

  Optional field.

• To date

• Pick a date or enter it in MM/DD/YYYY format. SuccessFactors returns records from the effective start date to the “to date”. You must not use “to date” together with “as of date”.

  Optional field.

• As of date

• Pick a date or enter it in MM/DD/YYYY format. You must not use "as of date" together with “from date” or “to date”.

  Optional field.

Output fields

The output fields vary depending on the object you select. To view the available data pills, review the output datatree.

DateTime fields

The system converts DateTime fields to UTC time. It infers the origin time zone from the instance's environment time zone (opens new window), unless otherwise stated. Learn more about Datatree and data pills.