I have an app that pulls data from custom column by internal name. If I create the column and delete it, than create it again, SharePoint still has the internal name saved and then appends a 0 to the internal name, which breaks my app. So lets say the columns internal name was 'Test' when I created it, then I deleted it and immediately tried to recreate it. The columns internal name is now 'Test0'. Lets say I deleted it again and recreate it quickly. Now the columns internal name is 'Test1'. The columns internal name needs to be 'Test'. All the internal names from the previously created and deleted columns still exist in the db. How long do I have to wait for those to disappear? I have waited 12 hours and they are still there! I need the internal names to be right when I create the column for when I demo my app. Is there some way to delete a column and also delete its internal name from the db? Please help!!!
For any one else experiencing this issue, I found a solution. It turns out the document library was the thing remembering the internal name of the column. When I deleted the column, remade it, and uploaded a document to a NEW document lib using the column, which had NOT previously used the deleted column, then the internal name of the api response was correct. So the solution is either to wait for a few days, use a new document library, or add code to spfx custom web part to account for possible columns with 0, 1, 2..ect appended to the internal name.