Sap Odata Connector strange behaviour

(1) Share

Report

Posted on by niklasjegg

505

Hi, i have just now created a copilot studio Agent that should call the SAP OData connector.

I am connecting via APIM Service to SAP which works fine as described in Martins blog. Hurray🎉 SAP OData connector now supports OAuth2 and SAP Principal Propagation

I am facing a very strange issue however. The agent is building my query strings - also fine (Base URI of the connector is my APIM)

This it the log i see in APIM

each query gets the ?$top=5 or anything else after the ? "deleted" and there is this silly forwardslash added to each query

For me this indicates that the SAP OData Connector is not passing the Query over the Internet? (i am not sure tho)

Does anyone have any help for me ?

Categories:

Flow Integration

Power Automate Flows

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

DAnny3211 63 on at

Like (0)

Report
Sap Odata Connector strange behaviour

Hi, It sounds like you're encountering an issue where the **OData query parameters** (such as `?$top=5`) are being stripped from the request when routed through the SAP OData connector via APIM. Additionally, the unexpected addition of a trailing slash (`/`) in the query path may be interfering with how SAP interprets the request. Here are a few things to check: 1. **Connector configuration**: Ensure that the `OdataQuery` parameter is explicitly defined and passed separately from the `relativePath`. Some connectors require query parameters to be set in a dedicated field rather than appended directly to the path. 2. **APIM rewrite policies**: Inspect the inbound and outbound policies in your APIM instance. It's possible that a rewrite or transformation policy is unintentionally modifying the URL structure or stripping query parameters. 3. **SAP OData endpoint behavior**: Some SAP services are sensitive to URL formatting. A misplaced slash or missing query string can lead to unexpected behavior or default responses. 4. **Reference documentation**: - SAP OData connector setup - Azure API Management policies - Martin's blog post #127881 — if available, this may contain specific guidance on OAuth2 and Principal Propagation. You might also consider logging the full request before it hits APIM to confirm whether the query string is present and correctly formatted. Thanks and best regards, Daniele **Note: This response was prepared with support from Copilot to ensure clarity and completeness.**

Was this reply helpful? Yes No