Forum Discussion
keetaya80
Jan 08, 2019Brass Contributor
SharePoint Online List querying with "app only" API: XML output vs JSON Output
Hi We have created a new list in a modern site. This list contain a rich-text column containing string values with encoded characters like <, >. Then we try to query with "app only" API like belo...
NotAlex
Jan 10, 2019Iron Contributor
XML will encode those characters otherwise it could mess up the output.
You could decode the output of that after the fact with a html.decode for whatever language you are using :)
keetaya80
Jan 13, 2019Brass Contributor
NotAlex If I understood correctly, you suggest that we take the XML output with >, < etc then use decoding at the receiver module to get the >, < values, correct?
However, do you have any information why this output retrieves this way? Is it limitation with Office 365 as when we query the same in our old 2010 on-premise list it works perfectly
To note, when we request for JSON output with below GET request, it retrieves proper output (with values >,< etc)
https://collab.lilly.com/sites/MDIT-IEP-DEV/_api/web/lists/getbytitle('TestList')/items
Thanks
Thanuja