11

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

Improve this question

6 Answers 6

Reset to default
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.

Improve this answer
7
  • The problems with these are that I can't login in Office 365 ...
    – Ruben Herman
    Jan 25, 2012 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, 2012 at 14:24
  • But I also need to fill in a domain. Any idea what to fill in there?
    – Ruben Herman
    Jan 25, 2012 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, 2012 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, 2012 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 : [email protected]

Improve this answer
3
  • 1
    I've used this, very comfortable and straightforward.
    – Etheryte
    Jan 19, 2015 at 21:45
  • 1
    Not working, might be due to MFA, can anyone confirm?
    – Jussi Palo
    Aug 20, 2018 at 7:49
  • Yes facing issue due to MFA
    – nbi
    Sep 30, 2019 at 6:14
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

Improve this answer
1
  • 1
    Download links behind the link are dead.
    – Jussi Palo
    Aug 20, 2018 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

Improve this answer
1
  • 1
    This is the only one that works with MFA enabled SPO sites, thank you!
    – Jussi Palo
    Aug 20, 2018 at 8:17
-1

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.

Improve this answer
2
  • Using this app requires registration, didn't do it, so cannot comment if it works.
    – Jussi Palo
    Aug 20, 2018 at 7:52
  • registration does not work. It sucks.
    – Burre Ifort
    Jan 7, 2020 at 14:20
-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

Improve this answer
1
  • 2
    shameless self-plugs without disclosure are frowned upon, even if it is open source.
    – Ray
    Mar 27, 2013 at 14:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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