Http request failed: the content was not a valid JSON.
I'm receiving this error when executing a sql stored procedure v2 (premium). The SQL Stored Proc will return, at this time, 53k+ records. This is causing the error. If I place a LIMIT (10, 100, 1000, 10000, and 20000) in the Stored Proc, the Flow runs successfully. Setting the LIMIT to 50000 or removing it altogether will cause the error.
Is there a maximum size limit on the size of a JSON return from a stored procedure?
Here is my scenario... 1) I have an on-prem MariaDB MySQL replica that, for the most part, is read-only (I can create SQL Views). 2) I have linked that MySQL DB to MS SQL Server. 3) I use that linked server in a Stored Procedure that calls the MySQL data. 4) I Parse the data and prepare it for updating records in Common Data Service to be used in Dynamics 365 CRM (Sales Hub).
Flow success with SP containing LIMIT of <= 20000
SP set with LIMIT under 50000
Flow failure with SP containing LIMIT of >= 50000 or no LIMIT restriction
SP set with no LIMIT or 50000
Flow failure showing JSON error
JSON error returned
Any explanation or guidance is greatly appreciated.