Office365-REST-Python-Client icon indicating copy to clipboard operation
Office365-REST-Python-Client copied to clipboard

Can't get data when colon (x003a) is in the column name

Open noelem opened this issue 3 years ago • 0 comments

Hello,

So I think I found a bug.

It seems that, when I try to get the item properties, whenever a colon i.e., " : " appears in the column name in a SharePoint list, I cannot get the data from that specific column.

Although, if a construct a mapping-list based on a field object it will contain column names with " : "

mapping_list = {f.properties["InternalName"]: f.properties["Title"] for f in fields}

Focus_x0020_Group_x003a_BI': 'Focus Group:BI'

If I construct a list based on the item object, the above column does not appear:

item_property_column_name_set = set()
for item in items:
    for i in item.properties.keys():
        item_property_column_name_set.add(i)

display(item_property_column_name_set)

Am I missing something?

Br Noel

noelem avatar Sep 08 '22 11:09 noelem