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

HTTP request sharepoint error json with field value with \\

 

Hi, I need some help with a bug.
Every time I run the flow and a name comes like this, I get error in the json format  with this field value


"FieldValue":"176748_\\10.1.1.206\Storage\pdf\1000-LEG\33_337890.pdf"

when sending a request.
I would like to know if the problem is the \\ or . I have to identify the format of the file .pdf , .xlsx , etc.

Thanks in advance

 

elaaadani_0-1615664656816.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
mccoydblueloop
Frequent Visitor

I had this isse last night and at 11pm and it took me till 1am to try using single quotes instead of double quotes in the JSON and it worked. I'm gonna say try this:

 

'FieldValue':'176748_\\10.1.1.206\Storage\pdf\1000-LEG\33_337890.pdf'

View solution in original post

3 REPLIES 3
Expiscornovus
Super User II
Super User II

Hi @elaaadani,

 

As far as I am aware you need to escape the backslash character.

invalidcharacterescaping.png

 

You can use another backslash for that.

 

[{"FieldValue":"176748_\\\\10.1.1.206\\Storagepdf\\1000-LEG\\33_337890.pdf"}]

 

 

escapebackslash.png

 

https://powerusers.microsoft.com/t5/Building-Flows/Escaping-JSON-Invalid-Characters/td-p/568274

 

mccoydblueloop
Frequent Visitor

I had this isse last night and at 11pm and it took me till 1am to try using single quotes instead of double quotes in the JSON and it worked. I'm gonna say try this:

 

'FieldValue':'176748_\\10.1.1.206\Storage\pdf\1000-LEG\33_337890.pdf'

View solution in original post

@mccoydblueloop thank you, but I have the same problem 


{"odata.error":{"code":"-1, Microsoft.SharePoint.Client.InvalidClientQueryException","message":{"lang":"es-ES","value":"Secuencia JSON con formato incorrecto."}}}

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Users online (28,982)