How do I get the SData GET to return only the XML with the requested data items? It is currently returning a ton of unwanted HTML that is a waste to transmit on every GET. I have tried different Content-Type options, but nothing I tried has worked:
GET localhost/.../AR_Customer('01;ABF')
User-Agent: Fiddler
Host: localhost
Authorization: Basic d2ViOndlYg==
and the response is:
<?xml version="1.0" encoding="utf-8"?>
<entry xmlns:atom="http://www.w3.org/2005/Atom" xmlns:xs="www.w3.org/.../XMLSchema" xmlns:cf="www.microsoft.com/.../2005" xmlns="http://www.w3.org/2005/Atom" xmlns:sdata="schemas.sage.com/.../1" xmlns:xsi="www.w3.org/.../XMLSchema-instance" xmlns:opensearch="a9.com/.../" xmlns:sync="schemas.sage.com/.../1" xmlns:sme="schemas.sage.com/.../2007" xmlns:http="schemas.sage.com/.../1">
<author />
<content type="html"><![CDATA[<html>
<head>
<META http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="font-family: Verdana;">
<table cellpadding="4" cellspacing="0" style="background-color: white; font-family: Arial;border: 1px solid darkgray;font-size: x-small;">
*** LOTS OF UNWANTED HTML HERE ***
</table>
</body>
</html>]]></content>
*** THIS PART BELOW IS ALL I WANT ***
<id>localhost/.../id>
<http:httpStatus>200</http:httpStatus>
<sdata:payload>
<AR_Customer sdata:uri="localhost/.../AR_Customer('01;ABF')" xmlns="">
<ARDivisionNo>01</ARDivisionNo>
<CustomerNo>ABF</CustomerNo>
<CustomerName>American Business Futures</CustomerName>
<AddressLine1>2131 N. 14th Street</AddressLine1>
<AddressLine2>Suite 100</AddressLine2>
<AddressLine3>Accounting Department</AddressLine3>
*** WANTED DATA IS HERE ***
</AR_Customer>
</sdata:payload>