Web Service Get List ID with VBSCRIPT to filter on for UpdateListItems

ismailc · #1 (**permalink**) January 13th, 2010, 02:33 AM

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!

ismailc · #2 (**permalink**) January 13th, 2010, 04:32 AM

Please, i need to get the retunring filed "ows_ID" value
in my vbscript wscript.echo .responseText then i see all the values but no clue on getting the "ows_ID" value

Please Help

elizas · #3 (**permalink**) January 27th, 2010, 08:32 AM

Generally web applications in SharePoint are created using the out-of-box functionality provided within Central Administration. But because of some client's needs there might be a requirement of creating these web applications within a custom utility solution. This functionality can be achieved programmatically using Microsoft SharePoint APIs. By this, one can easily create a web application & associate a content database to it, register the web application in the IIS server, create an associated application pool and define different credentials for the web aplication.

Thanks
Eliza

Need to download code?

Navigation