SQL Query pulling extra data
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-19-2015
09:00 AM
08-19-2015
09:00 AM
SQL Query pulling extra data
I am using this query in SOAPUI against our SOAP API.
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:del="http://tempuri.org/Deltek.Vision.WebServiceAPI.Server/DeltekVisionOpenAPIWebService"> <soapenv:Header/> <soapenv:Body> <del:GetProjectsByQuery> <!--Optional:--> <del:ConnInfoXML><![CDATA[<VisionConnInfo> <databaseDescription>Description</databaseDescription> <userName>USERNAME</userName> <userPassword>PASSWORD</userPassword> <integratedSecurity>Y</integratedSecurity> </VisionConnInfo>]]></del:ConnInfoXML> <!--Optional:--> <del:Query>SELECT WBS1,Name,Principal FROM PR WHERE PR.WBS1='H15032.00'</del:Query> <!--Optional:--> <del:RecordDetail>'Project'</del:RecordDetail> </del:GetProjectsByQuery> </soapenv:Body> </soapenv:Envelope>
The request goes through and gives me a response, however it gives me additional fields also. I just want to pull the column specifed in query itself like WBS1, Name, and Principal fields only.
I get A massive response with every field in the database table, here is a very small snippe rof the return.
<custLetterofIntent>Y</custLetterofIntent><custIssued>2015-06-03T00:00:00.000</custIssued><CreateUser>KGOODENOW</CreateUser><CreateDate>2015-06-03T15:51:20.913</CreateDate><ModUser>KGOODENOW</ModUser><ModDate>2015-06-03T15:52:29.227</ModDate><CustContractStatus>LOI</CustContractStatus></ROW></Projects_ConsultantAgreements></REC></RECS>]]></GetProjectsByQueryResult>
Am I missing something?
0 REPLIES 0
