SQL Injection issue with AND

Question

Hi, When I am using AND condition in the input JSON data, I am getting a 403 forbidden error when running through HTTPS Local override secure URL which due to WAF SQL Injection. Can some one suggest how to mask the condition with AND .

tstack · Answer

Can you provide some more details?  Are you building a query in a SQL Execute snap?  If you could export and attach your pipeline, that would help us understand what you’re trying to achieve.

madhavikarri · Answer

Hi @tstack
I have got the issue resolved. This is happening since the APP GAteway firewall is blocking SQL data as in seems like SQL injection.I have handled the data by passing condition as array elements and have appended AND with in snaplogic.

Forum Discussion

SQL Injection issue with AND

Recent Discussions

Pagination and nextCursor in header

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?