2 Replies Latest reply: Nov 14, 2012 7:04 PM by PaulCo RSS

    specifying multiple books in WS2 web services query


      I am wondering if anybody has managed to use web services to query data and restrain by more than 1 book of business. According Oracle Support this can be done though the use of searchspec to determine the Book. I have tried this with no success

      Here is a SOAP message with just a single Book reference. It returns no results?

      <?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body>
      <ContactQueryPage_Input xmlns="urn:crmondemand/ws/ecbs/contact/">
      <ListOfContact xmlns="urn:/crmondemand/xml/Contact/Query">
      <Contact searchspec="([ContactFirstName] = 'John') AND ([BookId] = 'AHIA-N3S58')"><Id />

      For multiple books the searchspec would be

      <Contact searchspec="([ContactFirstName] = 'John') AND ([BookId] = 'AHIA-N3S58') AND ([BookId] = 'AHIA-N3S76')"><Id />

      Any guidance is appreciated.

      Edited by: user10730659 on 11-Nov-2012 20:59