You can use an OData object as a source in a data loader task.
When you create a data loader task to read data from OData, specify the OData source properties.
The following table describes the OData source properties:
Advanced Source Property
Description
Connection
Name of the source connection.
Select a source connection or create a new connection.
Maximum Page Size
Set the number of records to be fetched per page when you read data.
You can set the page size when you want to read a large amount of data from a source. Default is 50.
Note: The value must be less than the default page size of the server. Else, the server might return duplicate rows in the target file when you run the data loader task.
Rules and guidelines for primary key fields and watermark fields
When you read data from OData, the primary key fields are detected. You can also manually define the primary key fields and watermark fields. The default values are Automatically detect from source and Watermark fields not required.
You cannot set Date Time Offset as a Watermark field.