odata_export_entity
Export any D365 F&O data entity via OData (transactional, no DMF project required). Universal: works for ANY public entity. Supports $select, $filter, $orderby and follows server paging automatically. Returns CSV (default) or JSON. Use for live/ad-hoc exports and small-to-medium volumes. For very large bulk exports prefer dmf_export_package. Resolve the entity set name from the KB first (find_entity_for_table / get_data_entity_info) -- do not invent entity names.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| filter | No | Optional OData $filter expression. | |
| format | No | Output format: 'csv' (default) or 'json'. | csv |
| select | No | Optional $select (comma-separated fields). Empty = all fields. | |
| maxRows | No | Max rows to return (0/empty = no cap, follows all pages). Default 1000. | |
| orderBy | No | Optional $orderby expression. | |
| entitySet | Yes | OData public entity set name, e.g. 'CustomersV3', 'ReleasedProductsV2'. | |
| outputPath | No | Optional file path to also write the full result to (e.g. C:\temp\export.csv). | |
| crossCompany | No | Set true to query across all legal entities (adds cross-company=true). |