Web Service Get List ID with VBSCRIPT to filter on

Anything VBScript-related, including Windows Script Host, WMI, ADSI, and more.
Forum rules
Do not post any licensing information in this forum.

Any code longer than three lines should be added as code using the 'Select Code' dropdown menu or attached as a file.
Locked
User avatar
ismailc
Posts: 37
Joined: Mon Nov 09, 2009 6:11 pm

Web Service Get List ID with VBSCRIPT to filter on

Post by ismailc »

Good day, just when i thought i was done.
I can no longer go Title to do my filtering.I need to determine the ID to the filtering.
Any examples using VBSCRIPT get the List ID with Web Services to filter on for UpdateListItems
'some varsurl = "http://srv08-za143/workspace/department ... .asmx"list = "Vendor Request"id = 2title = "test"'wscript.arguments(0)
'the camlbatch = "<Batch OnError='Continue' ListVersion='1'>"'batch = "<Batch OnError='Continue' PreCalc='TRUE' ListVersion='0'>"batch = batch + " <Method ID='1' Cmd='Update'>"
batch = batch + " <Field Name='ID'></Field>"batch = batch + " <Field Name='FSObjType'>1</Field>"batch = batch + " <Field Name='BaseName'>AB Test</Field>"batch = batch + " <Field Name='FileLeafRef'>AB Test</Field>"batch = batch + " <Field Name='Vendor'>999999</Field>"batch = batch + " <Field Name='Site'>999999</Field>"
batch = batch + " </Method>"batch = batch + "</Batch>"
'soap wrapper plus some info in bodyrequest = "<?xml version='1.0' encoding='utf-8'?>"request = request + "<soap:Envelope xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'"request = request + " xmlns:xsd='http://www.w3.org/2001/XMLSchema'"request = request + " xmlns:soap='http://schemas.xmlsoap.org/soap/envelope/'>"request = request + " <soap:Body>"request = request + " <UpdateListItems xmlns='http://schemas.microsoft.com/sharepoint/soap/'>"request = request + " <listName>" & list & "</listName>"request = request + " <updates>" & batch & "</updates>"request = request + " </UpdateListItems>"request = request + " </soap:Body>"request = request + "</soap:Envelope>"
'post it up and look at the responsewith CreateObject("Microsoft.XMLHTTP") .open "POST", url, False , null, null .setRequestHeader "Content-Type", "text/xml; charset=utf-8" .setRequestHeader "SOAPAction","http://schemas.microsoft.com/sharepoint ... eListItems" .send request 'wscript.echo .responseText end with
Please help

User avatar
ismailc
Posts: 37
Joined: Mon Nov 09, 2009 6:11 pm

Web Service Get List ID with VBSCRIPT to filter on

Post by ismailc »

Good day, just when i thought i was done.
I can no longer go Title to do my filtering.I need to determine the ID to the filtering.
Any examples using VBSCRIPT get the List ID with Web Services to filter on for UpdateListItems
'some varsurl = "http://srv08-za143/workspace/department ... .asmx"list = "Vendor Request"id = 2title = "test"'wscript.arguments(0)
'the camlbatch = "<Batch OnError='Continue' ListVersion='1'>"'batch = "<Batch OnError='Continue' PreCalc='TRUE' ListVersion='0'>"batch = batch + " <Method ID='1' Cmd='Update'>"
batch = batch + " <Field Name='ID'></Field>"batch = batch + " <Field Name='FSObjType'>1</Field>"batch = batch + " <Field Name='BaseName'>AB Test</Field>"batch = batch + " <Field Name='FileLeafRef'>AB Test</Field>"batch = batch + " <Field Name='Vendor'>999999</Field>"batch = batch + " <Field Name='Site'>999999</Field>"
batch = batch + " </Method>"batch = batch + "</Batch>"
'soap wrapper plus some info in bodyrequest = "<?xml version='1.0' encoding='utf-8'?>"request = request + "<soap:Envelope xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'"request = request + " xmlns:xsd='http://www.w3.org/2001/XMLSchema'"request = request + " xmlns:soap='http://schemas.xmlsoap.org/soap/envelope/'>"request = request + " <soap:Body>"request = request + " <UpdateListItems xmlns='http://schemas.microsoft.com/sharepoint/soap/'>"request = request + " <listName>" & list & "</listName>"request = request + " <updates>" & batch & "</updates>"request = request + " </UpdateListItems>"request = request + " </soap:Body>"request = request + "</soap:Envelope>"
'post it up and look at the responsewith CreateObject("Microsoft.XMLHTTP") .open "POST", url, False , null, null .setRequestHeader "Content-Type", "text/xml; charset=utf-8" .setRequestHeader "SOAPAction","http://schemas.microsoft.com/sharepoint ... eListItems" .send request 'wscript.echo .responseText end with
Please help

Locked