webMethods

webMethods

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

[SOLVED]Add List item to Sharepoint List: Data at the root level is invalid. Line 1, position 1.

  • 1.  [SOLVED]Add List item to Sharepoint List: Data at the root level is invalid. Line 1, position 1.

    Posted Thu March 20, 2014 09:03 AM

    Hi everyone

    I have made a consumer Web service that connects to my Sharepoint site. The service works fine because when I test the connection with the method ‘GetListItems’ it shows all the items in that list.

    But when I try to add an item to that list the error in the subject is shown.

    Here’s the pipeline the service gives me:

    For the variables tns:listName, user, pass and _port I filled in the same data as I did with ‘GetListItems’ so those should be correct.

    For *body I filled in the XML below:

    <Batch OnError="Continue" ListVersion="1">
<Method ID="1" Cmd="New">
<Field Name="Title">SAG BPMS</Field>
<Field Name="Description">Book</Field>
<Field Name="Email">emans@test.be</Field>
<Field Name="Storage_x0020_Location">Kast 3</Field>
<Field Name="Position_x0020_in_x0020_Storage">Schap 5</Field>
<Field Name="Course_x0020_Date">2014-03-23T00:00:00+0:00</Field>
<Field Name="Person">-1;#Emans Kevin</Field>
</Method>
</Batch>

    This code worked fine in SoapUI so I don’t know what causes the error I’m getting to be thrown.

    Hopefully that’s enough information, if not, please don’t hesitate to ask.

    With kind regards
    Kevin


    #webMethods
    #API-Management
    #soa


  • 2.  RE: [SOLVED]Add List item to Sharepoint List: Data at the root level is invalid. Line 1, position 1.

    Posted Mon March 31, 2014 08:40 AM

    Apparently the XML created with the data provided isn’t correct.

    Now I have typed the entire XML as it should be, converted it to a node and then a document and, mapped that document to tns:updateListItems. Now everything works as it should.

    Hardcoded XML:

    <tns:UpdateListItems xmlns:tns="http://schemas.microsoft.com/sharepoint/soap/">
<tns:listName>{D3205B25-5EC2-42A7-9F3B-2299A002E213}</tns:listName>
<tns:updates>
<Batch OnError="Continue" ListVersion="1">
<Method ID="1" Cmd="New">
<Field Name="Title">SAG BPMS DEV</Field>
<Field Name="Description">Book</Field>
<Field Name="Email">test@test.be</Field>
<Field Name="Storage_x0020_Location">Kast 1</Field>
<Field Name="Position_x0020_in_x0020_Storage">Schap 1</Field>
<Field Name="Course_x0020_Date">2014-03-22T00:00:00+0:00</Field>
<Field Name="Person">-1;#Emans Kevin</Field>
</Method>
</Batch>
</tns:updates>
</tns:UpdateListItems>

    #soa
    #API-Management
    #webMethods


  • 3.  RE: [SOLVED]Add List item to Sharepoint List: Data at the root level is invalid. Line 1, position 1.

    Posted Thu April 10, 2014 05:46 AM

    You could have
    used documentToXMLString by passing empty values to tns:updateListItems - Here you will have the required xml instead of manually framing it !!!?


    #soa
    #API-Management
    #webMethods


  • 4.  RE: [SOLVED]Add List item to Sharepoint List: Data at the root level is invalid. Line 1, position 1.

    Posted Wed February 10, 2016 05:55 PM

    im getting the same issue. imported the wsdl and trying to run the webservice connector. webservice is using pub.client:soapClient.

    Can anyone let me know why its not working in connector and what should be done before passing data to connector?

    passing below similar data in the lsit:updates

    SAG BPMS Book emans@test.be Kast 3 Schap 5 2014-03-23T00:00:00+0:00 -1;#Emans Kevin

    ListName: CRM Test

    Error reported as Data at the root level is invalid. Line 1, position 1.
    example.JPG


    #API-Management
    #soa
    #webMethods


  • 5.  RE: [SOLVED]Add List item to Sharepoint List: Data at the root level is invalid. Line 1, position 1.

    Posted Mon February 15, 2016 03:57 PM

    working fine.

    i formed the wm document structure like below and mapped to top level tns:updates document instead of mapping xml string to *body which was cause of the issue.

    tns:updates


    SAG BPMS DEV
    Book
    test@test.be
    Kast 1
    Schap 1
    2014-03-22T00:00:00+0:00
    -1;#Emans Kevin


    </tns:updates>

    example.JPGhttps://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/ec0729e3b181e21e2c9c187cd9f28709f19f0b1c.jpeg 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/ec0729e3b181e21e2c9c187cd9f28709f19f0b1c.jpeg 2x" data-dominant-color="F6F6F6">
    example.JPG946×261 41.8 KB


    #soa
    #API-Management
    #webMethods


Related Content