Hi, I'm using Web Service with VBScipt
I can no longer go Title to do my filtering. I need to determine the ID to the filtering.
My UpdateListItems Method works when i have Title or ID (which is now unkown), Then I used the FileRef
Code:
dates the columns where items are listed
batch = batch + " <Field Name='ID'>3</Field>"
batch = batch + " <Field Name='FSObjType'>1</Field>"
batch = batch + " <Field Name='Vendor'>8888888</Field>"
batch = batch + " <Field Name='Site'>8888888</Field>"
---Updates document within Library then filter works on FileRef
---but it works only when renaming the document within the folder.
batch = batch + " <Field Name='FSObjType'>1</Field>"
batch = batch + " <Field Name='FileRef'>http://.../Test/temp4.txt</Field>"
batch = batch + " <Field Name='BaseName'>temp4.txt</Field>"
Please are there any other options i can filter on to get the item on item list level or perhaps the GETID method as last resort
I have started with the GETLISTITEMS Method to return the ID, my filter works & i can see all the values for that specific Item:
Code:
batch = "<Query><Where><Eq><FieldRef Name='FileLeafRef'/><Value Type='Folder'>AB Test</Value></Eq></Where></Query>"
wfields = "<viewFields><FieldRef Name='ows_ID'/></viewFields>"
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 + " <GetListItems xmlns='http://schemas.microsoft.com/sharepoint/soap/'>"
request = request + " <listName>" & list & "</listName>"
request = request + " <query>" & batch & "</query>"
request = request + " <ViewFields>" & strviewfields & "</ViewFields>"
request = request + " </GetListItems>"
request = request + " </soap:Body>"
request = request + "</soap:Envelope>"
But how do i retrun the 'ows_ID' value & insert to Vbscript Var
Please Assist!