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

  • Question

  • Here is the request I am sending to

    http://bla.bla.bla/mylisturl/_vti_bin/Lists.asmx

     

    <?xml version="1.0" ?>

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

    <S:Body>

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

    <listName>{B4ECE44A-1949-4DE9-B814-9D970C027B1A}</listName>

    <viewName />

    <query>

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

    <Where>

    <Eq>

    <FieldRef Name="Title" />

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

    </Eq>

    </Where>

    </Query>

    </query>

    <viewFields>

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

    <FieldRef Name="Title" />

    <FieldRef Name="Namespace" />

    <FieldRef Name="Service_x0020_Name_x0020_Local_x" />

    </ViewFields>

    </viewFields>

    <queryOptions>

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

    <IncludeMandatoryColumns>FALSE</IncludeMandatoryColumns>

    </QueryOptions>

    </queryOptions>

    <webID />

    </GetListItems>

    </S:Body>

    </S:Envelope>

     

     

    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">

    <soap:Body>

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

    <GetListItemsResult>

    <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_Namespace="http://greeter/"

    ows_Service_x0020_Name_x0020_Local_x="GreeterService"

    ows_MetaInfo="10;#"

    ows__ModerationStatus="0"

    ows__Level="1"

    ows_ID="10"

    ows_owshiddenversion="3"

    ows_UniqueId="10;#{C542314F-7947-47BA-9F29-BD6600BFAC2E}"

    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>

    </listitems>

    </GetListItemsResult>

    </GetListItemsResponse>

    </soap:Body>

    </soap:Envelope>

     

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

    http://msdn2.microsoft.com/en-us/library/lists.lists.getlistitems.aspx

     

    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!

     

    Thanks,

     

    Duncan

    • 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.

    Cheers
    Sreenath
    http://sreenath.net
    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