Special characters in OData filter query

[former_member779262]

Hello,

I need to query MarketingPermissions ( /sap/opu/odata/sap/API_MKT_CONTACT_SRV;v=0003/MarketingPermissions ) and filter by ContactPermissionID, which is actually an email address. We have data with the plus character '+' (e.g. john.doe+1234@liamg.mock).

The query works if I encode the '+' charchter with %2B and run the query in Postman:

https://{{mktHostname}}:443/sap/opu/odata/sap/API_MKT_CONTACT_SRV;v=0003/MarketingPermissions?$top=1... eq 'john.doe%2B1234@liamg.mock'

The query does also work if I encode the entire email address ('+' and '@'):

https://{{mktHostname}}:443/sap/opu/odata/sap/API_MKT_CONTACT_SRV;v=0003/MarketingPermissions?$top=1... eq 'john.doe%2B1234%40liamg.mock'

But, the query does not work if I use it within an iFlow in CI - OData V2 adapter. What is CI doing differently? What can I do to make it work?

[former_member779262]

Yes, that is probably a solution. Drawback is: I use the Data V2 connector with filter in many places, and I would need change all of them.

[maik_bosch]

Maybe instead of using Odata adapter you can sue HTTP adpater in CPI