Hi, i'm using soapenv to get data from SharePoint list librarys.
There are some things i didn't found answers to ..
- How should get data from library which is located in other site/subsite ?
- What is the best way to write this jQuery CAML Querys ? Now, i'm using NotePad :) then copy/paste it to SharePoint site, into Content Editor Web Part which is not very nice and efficient
- How to write CAML to get Items, which were created in last hour ? I wrote this kind of CAML to get items which are 1 day old. I use U2U CAML Builder but there are Variables which are not recognized by Content Editor Web Part (like that ..[Today-1Day(s)])
<soapenv:Envelope xmlns:soapenv='http://schemas.xmlsoap.org/soap/envelope/'>
<soapenv:Body> \
<GetListItems xmlns='http://schemas.microsoft.com/sharepoint/soap/'>
<listName>location</listName> \
<query> \
<Query> \
<Where> \
<Gt> \
<FieldRef Name='Created' /> \
<Value Type='DateTime'><Today OffsetDays='-1' /></Value> \
</Gt> \
</Where> \
</Query> \
</query> \
<viewFields> \
<ViewFields> \
<FieldRef Name='Title' /> \
<FieldRef Name='Latitude' /> \
<FieldRef Name='Longitude' /> \
</ViewFields> \
</viewFields> \
</GetListItems> \
</soapenv:Body> \
</soapenv:Envelope>";