SQL Server JSON Error

[farhandsome]

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:

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

[manuelstgomes]

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

[farhandsome]

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

[manuelstgomes]

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