SharePoint Online List querying with "app only" API: XML output vs JSON Output

Question

Hi&nbsp;We have created a new list in a modern site.&nbsp;This list contain a rich-text column containing string values with encoded characters like &lt;, &gt;. Then we try to query with "app only" API like below.&nbsp;https://Sample.com/sites/ThanujaSite/_api/web/lists/getbytitle('SampleList')/items&nbsp;&nbsp;if the&nbsp;XML out put is targeted, then the output coming would look like &amp;lt; and &amp;gt; for the characters mentioned above which is not usable for us. However if we target JSON output, characters retrieves properly. But we need the XML output since it is to be feed on to another application for processing; and re-creating that app to accept JSON is more work for us.&nbsp;we would like to know, if this is a limitation in SP Online now?&nbsp;&nbsp;NOTE:&nbsp; graph API is not used because it always provide JSON output not the XML output. So using Graph API is a blocker for this requirement.&nbsp;Any help appreciated&nbsp;&nbsp;&nbsp;

notalex · Answer

XML will encode&nbsp;those characters otherwise it could mess up the output.&nbsp;&nbsp;You could decode the output of that after the fact with a html.decode for whatever language you are using :)

keetaya80 · Answer

NotAlex&nbsp;If I understood correctly, you suggest that we take the XML output with&nbsp;&amp;gt;, &amp;lt; etc then use decoding at the receiver module to get the &gt;, &lt; values, correct?&nbsp;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&nbsp;To note, when we request for JSON output with below GET request, it retrieves proper output (with values &gt;,&lt; etc)&nbsp;https://sample.com/sites/ThanujaSite/_api/web/lists/getbytitle('TestList')/items&nbsp;ThanksThanuja&nbsp;

Forum Discussion

SharePoint Online List querying with "app only" API: XML output vs JSON Output

Share

Resources