Passing query paramater to $soap->GetListItems

ashesh28 has asked for the wisdom of the Perl Monks concerning the following question:

Hi All , I have a requirement to write a script to extract List items from SharePoint list using perl script. What i have

my $som = $soap->GetListItems(
    name(listName => $list_name),
    name(query => \value(
        name(Query => \value(
            name(OrderBy => \value(
                name('FieldRef' => {Name => 'Created', Ascending => 'F
+alse'}),
            )),
        )),
    )),
    name(rowLimit =>10)
);
[download]

This code does query the list item as required.But is it possible to pass query parameter to extract only certain items from the list , Lets say for example extract items where Field named ID is less than 10. Any insight would be helpful.

Comment on Passing query paramater to $soap->GetListItems Download Code

Replies are listed 'Best First'.
Re: Passing query paramater to $soap->GetListItems by Anonymous Monk on Jun 08, 2015 at 04:44 UTC
But is it possible to pass query parameter to extract only certain items from the list , Lets say for example extract items where Field named ID is less than 10. Any insight would be helpful. Here is a generic non-answer: sure anything is possible It depends on what the SharePoint api supports (this means you do the research, or ask on SharePoint forum) It also depends on what your soap toolkit supports, whether its something easy and out of the box, or something you have to work a little harder for ... It depends It always comes down to resources, having the correct docs, having a question focused enough to be answerable (more than a wish or a goal), having access to a demo/testing server you can develop against ... Happy hunting	[reply]

Replies are listed 'Best First'.

Re: Passing query paramater to $soap->GetListItems
by Anonymous Monk on Jun 08, 2015 at 04:44 UTC

But is it possible to pass query parameter to extract only certain items from the list , Lets say for example extract items where Field named ID is less than 10. Any insight would be helpful.

Here is a generic non-answer: sure anything is possible

It depends on what the SharePoint api supports (this means you do the research, or ask on SharePoint forum)

It also depends on what your soap toolkit supports, whether its something easy and out of the box, or something you have to work a little harder for ...

It depends

It always comes down to resources, having the correct docs, having a question focused enough to be answerable (more than a wish or a goal), having access to a demo/testing server you can develop against ...

Happy hunting

[reply]