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
Web Service Get List ID with VBSCRIPT to filter on
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.
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.
Web Service Get List ID with VBSCRIPT to filter on
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
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