GetData
POST {{url_sage100}}/SqlService/rest/GetData
Request Body
{"query"=>"SELECT DO_DATE AS CA_DATE, SUM(DO_TotalHT) AS CA_AMOUNT FROM F_DOCENTETE WHERE DO_Domaine = 0 AND YEAR(DO_DATE) = 2013 GROUP BY DO_DATE ORDER BY DO_DATE"}
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
Content-Type | string | ||
Authorization | string |
RESPONSES
status: OK
"\u003cDataTable xmlns=\"http://schemas.datacontract.org/2004/07/System.Data\"\u003e\u003cxs:schema id=\"NewDataSet\" xmlns:xs=\"http://www.w3.org/2001/XMLSchema\" xmlns=\"\" xmlns:msdata=\"urn:schemas-microsoft-com:xml-msdata\"\u003e\u003cxs:element name=\"NewDataSet\" msdata:IsDataSet=\"true\" msdata:MainDataTable=\"DATA\" msdata:UseCurrentLocale=\"true\"\u003e\u003cxs:complexType\u003e\u003cxs:choice minOccurs=\"0\" maxOccurs=\"unbounded\"\u003e\u003cxs:element name=\"DATA\"\u003e\u003cxs:complexType\u003e\u003cxs:sequence\u003e\u003cxs:element name=\"CA_DATE\" type=\"xs:dateTime\" minOccurs=\"0\"/\u003e\u003cxs:element name=\"CA_AMOUNT\" type=\"xs:decimal\" minOccurs=\"0\"/\u003e\u003c/xs:sequence\u003e\u003c/xs:complexType\u003e\u003c/xs:element\u003e\u003c/xs:choice\u003e\u003c/xs:complexType\u003e\u003c/xs:element\u003e\u003c/xs:schema\u003e\u003cdiffgr:diffgram xmlns:diffgr=\"urn:schemas-microsoft-com:xml-diffgram-v1\" xmlns:msdata=\"urn:schemas-microsoft-com:xml-msdata\"/\u003e\u003c/DataTable\u003e"