9

Does anyone knows where to find a CAML query builder that I can use for Office 365, Sharepoint Online? (if there exists one)

8

The 2 popular CAML query tools are Strammit CamlViewer and U2U CAML Builder. They both say they're for 2007, but it's been proven they work fine for 2010 versions as well.

Edit: and the BIWUG CAML Designer works for O365 too.

  • The problems with these are that I can't login in Office 365 ... – Ruben Herman Jan 25 '12 at 14:21
  • U2U you should be able to as you point it to a URL and can provide login credentials. – Eric Alexander Jan 25 '12 at 14:24
  • But I also need to fill in a domain. Any idea what to fill in there? – Ruben Herman Jan 25 '12 at 14:32
  • when you login on the web site, do you login like something\username? if so, that something is the domain. on my public 2010 site, it's ems\username, so using U2U, I'd put in ems as the domain. – Eric Alexander Jan 25 '12 at 14:40
  • No, to login we use an e-mail address and a password. We don't have to fill in a domain – Ruben Herman Jan 25 '12 at 14:41
3

Its an old question, but i will update for my finding..

there is SPCAMLQueryHelper

it has choice for office 365, i have tried it and its works :)

enter image description here

edit : in field username you should fill your email for o365 account, ex : username@mysubs.onmicrosoft.com

  • 1
    I've used this, very comfortable and straightforward. – Nit Jan 19 '15 at 21:45
  • Not working, might be due to MFA, can anyone confirm? – Jussi Palo Aug 20 '18 at 7:49
1

For the reference, people trying to find the same thing they can use http://karinebosch.wordpress.com/my-articles/caml-designer/

Select Client Object Model in settings

  • 1
    Download links behind the link are dead. – Jussi Palo Aug 20 '18 at 7:53
1

You can use QuickCAML, it is a very good tool for quickly authoring and testing CAML queries in SharePoint 2010 and 2013 (including SPO / Office 365).

How to use the QuickCAML see: https://www.youtube.com/watch?v=-FY2IehUjuc

Download link: https://github.com/sapientcoder/QuickCAML

  • 1
    This is the only one that works with MFA enabled SPO sites, thank you! – Jussi Palo Aug 20 '18 at 8:17
0

Saketa CAML Query Builder is a CAML query generator for any version of SharePoint and other object models alongside, that help to retrieve data from the SharePoint lists/ libraries.

  • Using this app requires registration, didn't do it, so cannot comment if it works. – Jussi Palo Aug 20 '18 at 7:52
-2

you can build your query while coding. check this cawl4SharePoint it is open source class. There are even extra features in it.

https://github.com/makdeniz/cawl4SharePoint

  • 1
    shameless self-plugs without disclosure are frowned upon, even if it is open source. – Ray Mar 27 '13 at 14:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.