Sharepoint rest api number in column name

Question

This is a new issue i have found that if you add any number in the column name then the internal name of that column is very random. Its happening in Sharepoint Online, not sure if its there in on premise. Example we have a column named 12Column then the internal name of that column is _x0031_2Column This seems to be happening if we start a column name with a number. When we check the column mapping from rest call to the list items we get the column tag as <d:OData__x0031_2Column m:null="true" /> Not sure what can be done to handle this as i need to get this column as a filter for my rest call.

Any approach help is appreciated

why not name it as text first so that the internal name can be set. Later rename it to 12Column — dsouzajoel22
– dsouzajoel22, Commented Jan 19, 2017 at 8:37
Which is your question? How to get the internal column name? How to change the internal column name? (not possible) — Cecilia
– Cecilia, Commented Jan 19, 2017 at 9:09
I need to get the column values by putting it in Rest query select. Now if i put OData__x0031_2Column in the query in browser it fetches me the details but this cannot be hard coded. It needs to be generic for all types of column names. — Sree Kuttan
– Sree Kuttan, Commented Jan 19, 2017 at 9:26
And actually it will be end users who will be naming columns so cant ask them to do that. — Sree Kuttan
– Sree Kuttan, Commented Jan 19, 2017 at 9:27

Reego · Accepted Answer · 2017-01-19 11:39:03Z

3

It should not be an issue for you. First of all, to apply your filter you need to know the column internal name from SharePoint, it can not be guessed in any way. Additionally, I believe OData forbids entity properties starting with an underscore, I can't find where it is written though. Because SharePoint column names can start with an underscore, SharePoint will prefix such column names with "OData_" to conform to the specification when dealing with the REST endpoint.

answered Jan 19, 2017 at 11:39

Reego

1263 bronze badges

Add a comment |

Community · Accepted Answer · 2017-05-23 12:41:29Z

1

In (almost all) programming languages Variables can not start with digits.

Source: https://stackoverflow.com/questions/342152/why-cant-variable-names-start-with-numbers

Because then a string of digits would be a valid identifier as well as a valid number

  int 15 = 21;
  or
  var 15 = 21;

In JavaScript it is possible to use Object Keys with (leading) digits

var myObj = {};
myObject[ '15-myvar' ] = 21;

But it is not considered good practice,
since you can not do

console.log( myObj.15-myvar );

edited May 23, 2017 at 12:41

CommunityBot

1

answered Jan 19, 2017 at 9:45

Danny '365CSI' Engelman

21.2k7 gold badges37 silver badges80 bronze badges

Add a comment |

EnzoBurris · Accepted Answer · 2025-11-14 15:56:17Z

0

Just ran into this issue migrating sharepoint list items. I added a prefix when looking for columns that start with an underscore. Ther insert request also requires the prefix.

code in python

prefix = 'OData_' if column[0] == '_' else ''

answered Nov 14 at 15:56

EnzoBurris

1

Add a comment |

Stack Exchange Network

Sharepoint rest api number in column name

3 Answers 3

Your Answer

Hot Network Questions

Sharepoint rest api number in column name

3 Answers 3

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions