I have a list in sharepoint, where I have put the totals of the columns I am interested in.

ID Count=50

Certification Count=9

I want to display these counts on another page. I have found a code to do it for the ID column, but it doesn't work when I try to adapt it for the Custom column I created called Certification.

_api/web/lists/getbytitle('Community Map')/items => this works fine and is giving me back 50 items

_api/web/lists/getbytitle('Community Map')/items?$select=ID => this works fine and is giving me back 50 items

_api/web/lists/getbytitle('Community Map')/items?$select=Certification => this doesn't work and I get HTTP 400 The webpage cannot be found.

Could you please let me know what's wrong in my url?

Thanks and regards,


  • Do you get this error on hitting the url in browser or in your ajax / http call? Also check the internal name of your custom column. – harshal gite Sep 11 '18 at 20:19

Your Url seems fine. Mention the type of Certification Column(Single line of text or something else?).

Also Just check your url is in following format or not:

_api/web/lists/getbytitle('List Name')/items?$select=CustomColumnName

Where "List Name" => Display name of your list and

"CustomColumnName" => Internal name of your custom column

  • have you tried this? – Ganesh Sanap Nov 15 '18 at 12:49

@ harshal gite: It is both that don't work: the URL in browser and in the code. The browser is giving me HTTP400 and the code is giving me back an error.

@ Ganesh Sanap: The column type is single line of text. I don't think it is the list name as it is working fine when I put select=ID

I have this problem no matter which custom column I pick. What is the internal column name and how can I see it?

I use the column name that I have defined in my list settings. Is there another one?

Thanks, Maud

  • Hi Maud - welcome to SP SE. I think your Answer would be better posted as a comment instead - try out using 'add a comment' instead. – Tally Sep 12 '18 at 14:13
  • Hello, I tried put it says I need 50 points to comment. – Maud Sep 16 '18 at 11:22

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.