Forum Discussion

east0n14's avatar
east0n14
Occasional Visitor
9 years ago

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</c‌​ustIssued><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?

 

No RepliesBe the first to reply