on 2022 Jun 07 2:26 PM
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?
Request clarification before answering.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Maybe instead of using Odata adapter you can sue HTTP adpater in CPI
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
18 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.