CPI iFlow oData query option special character handling

[peter_21]

Dear Forum,

I have an oData adapter with query option where I try to use $filter= ID eq '${property.ID}'

If the ID property contains some special character (+?%&#/) the oData call will fail. Is there any option to convert special characters in the query options inline or use an expression in the content modifier to do the work?

I can insert a new mapping before the content modifier or write a script to manage this issue but maybe there is an easier method to do that.

Thanks,

Peter

[robsonchiarello · Accepted solution]

Hello Péter,

The common approach for these cases is to use a script to substitute these characters to another one.

E.g. xsltmapping.txt. (Rename the extension to .xsl)

Hope it helps!

Regards,

Robson Chiarello

[peter_21 · Accepted solution]

Hello Robson,

Thank you for your answer. I was hoping I would not get this answer but it is clear now that I can not make the work easier. 🙂

Regards,

Peter

[former_member610899 · Accepted solution]

Hi Robson,

Could you please give a detailed step for this solution. I have a similar requirement.

Best Regards,

Vaishali