Getting back spurious fields to GetListItems query, even with IncludeMandatoryColumns set FALSE RRS feed

  • Question

  • Here is the request I am sending to



    <?xml version="1.0" ?>

    <S:Envelope xmlnsTongue Tied="http://schemas.xmlsoap.org/soap/envelope/">


    <GetListItems xmlns="http://schemas.microsoft.com/sharepoint/soap/">


    <viewName />


    <Query xmlns:ns2="http://schemas.microsoft.com/sharepoint/soap/" xmlns="">



    <FieldRef Name="Title" />

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






    <ViewFields xmlns:ns2="http://schemas.microsoft.com/sharepoint/soap/" xmlns="">

    <FieldRef Name="Title" />

    <FieldRef Name="Namespace" />

    <FieldRef Name="Service_x0020_Name_x0020_Local_x" />




    <QueryOptions xmlns:ns2="http://schemas.microsoft.com/sharepoint/soap/" xmlns="">




    <webID />






    Here is the response I am getting back:


    <?xml version="1.0" encoding="utf-8" ?>

    <soap:Envelope xmlnsTongue Tiedoap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">


    <GetListItemsResponse xmlns="http://schemas.microsoft.com/sharepoint/soap/">


    <listitems xmlnsTongue Tied="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlnsBig Smilet="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urnTongue Tiedchemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">

    <rsBig Smileata ItemCount="1">

    <z:row ows_Title="Greeter"









    ows_FSObjType="10;#0" ows_Created="2007-07-16 11:27:44"

    ows_FileRef="10;#sites/caasd_strategic_cm/SOAregistry/Lists/CAASD Services/10_.000" />

    </rsBig Smileata>







    Here is the link to Microsoft's documentation of the API:



    My question: Since I have specified <IncludeMandatoryColumns>FALSE</IncludeMandatoryColumns> why am I getting values back for fields in addition to the ones I specified in the viewFileds argument? (ows_Metainfo, ows__ModerationStatus, etc.)


    Any help appreciated.  But please note - I'm NOT using a microsoft development environment - I'm accessing the sharepoint web service API from a java client running in a Linux environment.  So, please don't respond in MS-ese!





    • Moved by Mike Walsh FIN Friday, August 14, 2009 2:37 PM prog q (From:SharePoint - General Question and Answers and Discussion)
    Tuesday, January 8, 2008 2:53 AM

All replies

  • Not much help in solving your problem, but you are not alone - the same thing happens to me - it appears IncludeMandatoryColumns just gets ignored.


    Tuesday, April 8, 2008 8:20 AM
  • Duncan, did you ever find a solution to this problem?

    Friday, August 14, 2009 2:06 PM
  • Moving to the programming forum.

    WSS FAQ sites: http://wssv2faq.mindsharp.com and http://wssv3faq.mindsharp.com
    Total list of WSS 3.0 / MOSS 2007 Books (including foreign language) http://wssv3faq.mindsharp.com/Lists/v3%20WSS%20FAQ/V%20Books.aspx
    Friday, August 14, 2009 2:36 PM
  • Facing the same problem here.

    I just need to fetch one field from a list and instead I get 10 - 9 system columns which are data heavy as well. Seems like I have to take these columns whether I want them or not. :( If any of you do find a way to remove those spurious fields, please post here and help me out.

    Sunday, January 10, 2010 7:58 PM
  • Hi, I'm using Vbscript

    I can see all the values from all the fields using wscript.echo .responseText

    but how do i get the value of only field which i want to pass to a var

    "<viewFields><FieldRef Name='ows_ID'/></viewFields>"

    I know the column but how to get the val - struggling :(

    Please help
    Wednesday, January 13, 2010 8:44 AM
  • Oh my god, problem raise since 2008, until now still no solution ?

    I got special character in my tiff files Author properties. when i run GetListItems webservice,  i get error in XML document (6, 340).

    I think is cause by the mandatory field "ows_MetaInfo", please help to apply the IncludeMandatoryColumns in your GetListItems webserive.

    Tuesday, February 28, 2012 1:20 AM