Calling SharePoint Online REST API returns ? instead of umlaut within the data

%3CLINGO-SUB%20id%3D%22lingo-sub-401472%22%20slang%3D%22en-US%22%3ECalling%20SharePoint%20Online%20REST%20API%20returns%20%3F%20instead%20of%20umlaut%20within%20the%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-401472%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20call%20SharePoint%20Online%20REST%20API%20to%20lookup%20a%20list%20item%20any%20values%20returns%20that%20contain%20umlauts%20(%C3%A4%20%C3%B6%20%C3%BC)%20are%20substituted%20for%20questions%20marks%20(%3F)%3C%2FP%3E%3CP%3Ethis%20is%20the%20URL%20i%20tried%20directly%20in%20the%20browser%3F%3C%2FP%3E%3CPRE%3Ee.g.%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Ehttps%3A%2F%2F%26lt%3Btenant%26gt%3B.sharepoint.com%2Fsites%2F%26lt%3Bsitename%26gt%3B%2F_api%2Flists%2Fgetbytitle('%26lt%3Blistname%26gt%3B')%2Fitems%3F%24select%3DTitle%2CId%2CHashcode%2CFilename%2CTitle%2FTitle%26amp%3B%24filter%3D(guid%20eq%20'62f0ff31-3d20-478a-a0d7-19f2d5709e71')%3C%2FPRE%3E%3CP%3EI%20get%20this%20in%20the%20Filename%20-%20EU-Konformit%C3%A4tserkl%C3%A4rung_de%2Cen.pdf%20is%20returned%20as%20EU-Konformit%3Ftserkl%3Frung_de%2Cen.pdf%3C%2FP%3E%3CP%3EWhat%20am%20I%20missing%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-407202%22%20slang%3D%22en-US%22%3ERe%3A%20Calling%20SharePoint%20Online%20REST%20API%20returns%20%3F%20instead%20of%20umlaut%20within%20the%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-407202%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F139670%22%20target%3D%22_blank%22%3E%40John%20Seto%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%C2%B4ve%20tried%20to%20reconstruct%20this%20in%20my%20environment%20(swedish)%20but%20for%20me%20it%20works%20fine.%20What%20kind%20of%20field%20type%20are%20you%20using%20for%20FileName%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-441761%22%20slang%3D%22en-US%22%3ERe%3A%20Calling%20SharePoint%20Online%20REST%20API%20returns%20%3F%20instead%20of%20umlaut%20within%20the%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-441761%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F55998%22%20target%3D%22_blank%22%3E%40Maggan%20W%C3%A5hlin%3C%2FA%3E%26nbsp%3Bsorry%20for%20the%20late%20reply%2C%20I%20was%20expecting%20an%20email%20if%20anyone%20replies%20to%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ere%3A%20the%20field%20type%20-%20%22Single%20line%20of%20text%22%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

When I call SharePoint Online REST API to lookup a list item any values returns that contain umlauts (ä ö ü) are substituted for questions marks (?)

this is the URL i tried directly in the browser?

e.g. https://<tenant>.sharepoint.com/sites/<sitename>/_api/lists/getbytitle('<listname>')/items?$select=Title,Id,Hashcode,Filename,Title/Title&$filter=(guid eq '62f0ff31-3d20-478a-a0d7-19f2d5709e71')

I get this in the Filename - EU-Konformitätserklärung_de,en.pdf is returned as EU-Konformit?tserkl?rung_de,en.pdf

What am I missing?

2 Replies
Highlighted

@John Seto 

 

I´ve tried to reconstruct this in my environment (swedish) but for me it works fine. What kind of field type are you using for FileName? 

Highlighted

@Maggan Wåhlin sorry for the late reply, I was expecting an email if anyone replies to me.

 

re: the field type - "Single line of text"