cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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 50000SP set with LIMIT under 50000

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Flow failure with SP containing LIMIT of >= 50000 or no LIMIT restriction 

 

SP set with no LIMIT or 50000SP set with no LIMIT or 50000

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Flow failure showing JSON error

JSON error returnedJSON error returned

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Any explanation or guidance is greatly appreciated. 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Hello @ChadBishop 

 

Using the SQL connector you have some limitations

 

https://docs.microsoft.com/en-us/connectors/sql/#known-issues-and-limitations

 

Your issue probably is related with this limitation:

 

  1. The response size limit is 8MB through on-premises SQL server.
  2. The request size limit is 2MB through on-premises SQL server.

 

Hope this can help you!

 

View solution in original post

1 REPLY 1
Highlighted
Microsoft
Microsoft

Hello @ChadBishop 

 

Using the SQL connector you have some limitations

 

https://docs.microsoft.com/en-us/connectors/sql/#known-issues-and-limitations

 

Your issue probably is related with this limitation:

 

  1. The response size limit is 8MB through on-premises SQL server.
  2. The request size limit is 2MB through on-premises SQL server.

 

Hope this can help you!

 

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Users online (7,877)