Caml query builder Office 365 Sharepoint Online

Question

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

Eric Alexander · Accepted Answer · 2015-01-19T20:37:36.037

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.

edited Jan 19 '15 at 20:37

answered Jan 25 '12 at 14:16

Eric Alexander

43,293
10
53
93

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
it looks as if when a MS Online site is created it needs a domain and based on that domain, it creates the site like contoso-1.microsoftonline.com. Look at your URL and look to see what value in your URL looks like that and that should be your domain to use. – Eric Alexander Jan 25 '12 at 15:12
Apparently these don't support MFA, at least cannot login to any SPOs that have MFA enabled. – Jussi Palo Aug 20 '18 at 07:56

adhitya febrian · Answer 2 · 2014-01-02T05:20:19.503

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

edited Jan 02 '14 at 05:20

answered Jan 02 '14 at 05:15

adhitya febrian

496
1
5
12

1

I've used this, very comfortable and straightforward. – Etheryte Jan 19 '15 at 21:45
1

Not working, might be due to MFA, can anyone confirm? – Jussi Palo Aug 20 '18 at 07:49
Yes facing issue due to MFA – nbi Sep 30 '19 at 06:14

score 1 · Answer 3 · answered Jun 09 '18 at 17:02

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

answered Jun 09 '18 at 17:02

Clavin Fernandes

133
6

1

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

score 1 · Answer 4 · answered Jul 15 '12 at 14:24

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

answered Jul 15 '12 at 14:24

Nauman.Qazi

11
1

1

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

score -1 · Answer 5 · answered Apr 12 '18 at 10:54

-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.

answered Apr 12 '18 at 10:54

Rohith

51
6

Using this app requires registration, didn't do it, so cannot comment if it works. – Jussi Palo Aug 20 '18 at 07:52
registration does not work. It sucks. – Burre Ifort Jan 07 '20 at 14:20

score -2 · Answer 6 · answered Mar 27 '13 at 09:59

-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

answered Mar 27 '13 at 09:59

murat

1

2

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

Caml query builder Office 365 Sharepoint Online

6 Answers6

Linked