This happens because SharePoint has its own url encoding of special characters
To find yours go to the following URL for your SharePoint site:
https://<site>/_api/web/lists/getbytitle(‘<List Name>’)?$select=ListItemEntityTypeFullName
OR to find it from the GUID go here:
https://<site>/_api/Web/Lists(guid'GUID-ID')
To find your GUID go to the settings of your list and look in the URL. It will look like this b778bbec-dd69-4a6c-9437-c73972c36292
Here is an example on how to fill in the above
- site
- This is your SharePoint site after the https. If the list is in the sub domain then include the subdomain as well
- example: with sub domain https://contoso.com/sales
- This is your SharePoint site after the https. If the list is in the sub domain then include the subdomain as well
- List Name
- Go to your custom list in SharePoint and use the title name you see there on the page
- example: My list url is https://contoso.com/sales/Company_Dashboard however I renamed the title Company Dashboard. I will use the name Company Dashboard because that is the list name
- Go to your custom list in SharePoint and use the title name you see there on the page
Full Example URL: https://contoso.com/sales/_api/web/lists/getbytitle(‘Company Dashboard’)?$select=ListItemEntityTypeFullName
Once you put your correct URL in you will be prompted to open or save the xml file
Open it and you should see something like below and the correct name you want for development is near the bottom:
In the above example _x005f_ translates to the underscore special character (_)
Go here for a known list
References:
https://nishantrana.me/2013/10/03/a-type-named-sp-data-listitem-could-not-be-resolved-by-the-model-when-a-model-is-available-each-type-name-must-resolve-to-a-valid-type-error-in-sharepoint-2013/
https://sharepoint.stackexchange.com/questions/274172/the-x0020-of-the-internal-name-for-a-sharepoint-column
https://stackoverflow.com/questions/28057890/whats-the-sharepoint-rest-endpoint-to-get-a-web-by-its-id