cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

SQL Server JSON Error

Hi all,

 

Just made the switch of data from SharePoint to SQL. However, I'm having trouble connecting to my SQL Server. I have made a test flow and keep getting this error:

 

Power Automate SQL Connector Error.PNG

 

I have never gotten this error before but now my flow won't run without triggering it. Can anyone tell me what the cause of it is?

 

Thanks,
Farhan

3 REPLIES 3
Highlighted
Super User II
Super User II

Re: SQL Server JSON Error

HI@farhandsome 

 

Indeed it's a strange case. Are you fetching all values or doing some sort of query to limit the information?

 

The issue here is that there's an invalid JSON but all of this should be abstracted in the action.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Highlighted
Helper IV
Helper IV

Re: SQL Server JSON Error

Looks like it went away after I refreshed.. lots of bugs with a SQL server if it is continuously updated.

Highlighted
Super User II
Super User II

Re: SQL Server JSON Error

hi @farhandsome 

 

Super strange but could be a temporary glitch in the system. At least it's solved.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Helpful resources

Announcements
secondImage

August 2020 CYST Winners!

Check out the winners of the recent 'Can You Solve These?' community challenge!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (4,826)