getting an error with query list in another site using caml query: Failed to query list data. Object reference not set to an instance of an object.

Crazy question...what happens if you try doing the exact same thing but without the CAML query. See what happens if you use UI instead.

you cant query a list in another site unless you do a caml query

What about with the 'Call Web Service'?

ok i did the webservice, had to capitalize q in QueryOptions in the soap editor mode

In your CAML query the viewfields are missing, for example :

<Query>

<Lists>

     <List ID="{8DEC397E-694D-43FD-8496-EAA048F38ED5}"/>

</Lists>

<ViewFields>

     <FieldRef Name="Title"/>

</ViewFields>

<Where>

     <Eq>

          <FieldRef Name="EmployeeId"/>

          <Value Type="Text">10535</Value>

     </Eq>

</Where>

</Query>

Hope this helps

thanks that worked, didnt think i needed it since it had a return field and store in under that in the UI, thanks!