cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ChadBishop
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
pagonza
Community Support
Community Support

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
pagonza
Community Support
Community Support

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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (2,388)