I am using the Deltek VisionWS in a .NET project by referencing the API service.
I am trying to read some employee Data using the GetEmployeesByQuery method of the proxy class generated by the WebService:
Code: Select all
DeltekVisionOpenAPIWebServiceSoapClient service = new DeltekVisionOpenAPIWebServiceSoapClient("DeltekVisionOpenAPIWebServiceSoap");
string result = service.GetEmployeesByQuery(connXML, "select top 10 * EM.FirstName, EM.LastName , EM.Employee, Em.Status, EM.Email from EM", "Primary");
The API seems to return all columns from the "EM" table even I specifically named those I need, also can I return only a subset of the records by using T-SQL words like ( TOP , Order BY ) available for use in the Query parameter.
The "TOP" keyword seems to be ignored.
Thanks, Martin Kalyonski