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.
This topic is 14 years and 2 months old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.
Locked
User avatar
ismailc
Posts: 37
Last visit: Tue Jun 09, 2015 12:16 am

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
Last visit: Tue Jun 09, 2015 12:16 am

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
This topic is 14 years and 2 months old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.
Locked