I have a SQL Server node which I am using to run a stored procedure which is returning 198k rows. I need to process this output through a workflow, but I keep getting a 413 status code error for most of the nodes I’ve tried to run after the SQL Server node.
I’m guessing that this is n8n complaining that the data payload is too big. I’ve tried a variety of mechanisms to break down the 198k payload, but no matter what I try I keep getting the 413 status error. Before I go any further, are there any tips for handling a large payload like this or am I beyond the limits of what I should be trying to do with n8n - if you say there is a method I will persevere, otherwise I’ll explore other options.