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

ismailc · 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 · 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 · 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