create-odata-query

What problem does it solve?

This Skill helps you create correct OData requests for Directum RX Integration Service so you can reliably query and update CRM/RX data without breaking entity naming rules or risking malformed filters.

Core Features & Use Cases

• Predicts correct OData entity set names using the entity schema and IntegrationServiceName mapping (e.g., I{IntegrationServiceName}s).
• Extracts entity property schema (field names, types, and navigation properties) to ensure your $select, $filter, and $expand match what the service expects.
• Validates metadata and consistency by locating IntegrationServiceName in .mtd and running post-change checks for alignment.

Use case examples

• Getting deals with related objects: fetch deals by pipeline, select specific fields, expand stage/counterparty, and apply ordering.
• Searching entities safely: filter by login/name while ensuring proper quoting and null checks in $filter.

Quick Start

Ask to create an OData query for the Deals dataset filtered by a pipeline id, returning only Id, Name, and Amount, with an expanded Stage, limited to 50 results.