Alteryx SharePoint Input Error

[AnilKumarN]

Hello All,

I am facing below SharePoint input error : Not well formatted JSON Stream, but I could see it runs successfully sometimes, but most of the times it fails, I thought it could be internet issue, but I have good internet speed too.

can someone help me to fix it.

[IraWatt]

@AnilKumarN Very strange error, makes it sound like SharePoint is not sending valid data. Are you importing a list? 

[Matt_D]

If you Google this error it points to it being an issue with the request header or body, not the returned data so could be a bug in the SharePoint Tool? I would raise this with the Alteryx support team.

[AnilKumarN]

Hi @Irawatt, yes I'm trying to import list.

[Matt_D]

@AnilKumarN just a thought, are there any special characters in the list data that would need escaping in JSON? I would have thought the tool would have done this but I'm not sure.

A JSON string must be double-quoted, according to the specs, so you don't need to escape '.

If you have to use special character in your JSON string, you can escape it using \ character.

See this list of special character used in JSON :

\b  Backspace (ascii code 08)
\f  Form feed (ascii code 0C)
\n  New line
\r  Carriage return
\t  Tab
\"  Double quote
\\  Backslash character