I am reading SFDC attachments and need to filter on name like 'abc_%'. I'm getting 'abcd...' in the results when I only want 'abc_...'. I can't find any documentation on how to escape the underscore character. Thanks!
Looks like you may need to escape that underscore with a backslash: Salesforce Developers
Thanks for your suggestions but I have tried the query with the back slash before the underscore with 'abc\_%' as a static value and it did not work.
Hmm I was able to reproduce the same problem however querying SFDC with the backslash escape outside of Boomi returned the expected result.
I would recommend raising to Boomi support for further evaluation if you haven't done so already.
Retrieving data ...