Rest api vba
In order to run any of the automations, they have to be downloaded from a library on the same site as the list being updated. You do not have permission to perform this action or access this resource." When one of the users with the issue tries it, the ResponseText comes back with (in part) "Access denied. When I run that function, I get the proper value to use for my list type in the metadata for my POST to create a list item. InStrRev(.ResponseText, "<") - InStr(.ResponseText, "SP.Data")) GetListType = Mid$(.ResponseText, InStr(.ResponseText, "SP.Data"), _ Set objXMLHTTP = CreateObject("MSXML2.XMLHTTP.6.0") And because I'm using REST to get the list type for my POST call, I can see that the issue even happens on GET calls: Private Function GetListType(listName As String) As StringĮntityType = "/_api/Web/Lists/getbytitle('" & listName & "')/ListItemEntityTypeFullName" The issue happens no matter the technique. I've rewritten the mechanism a few times, starting with ADO (which only worked by creating and running a VBS file on the fly), going to Lists.asmx, and finally ending up on REST calls. That tells me that it isn't group permissions on the list in question.
#Rest api vba update
Most of the visitors cannot update the list, but one can. Most of the owners can update the list, but one cannot. There are two user groups seeing the issue: owners and visitors. A small group of us can run the code and the list will update fine, but most users get some kind of access denied error. I've got a couple of hundred automations written in Excel that update a SharePoint list every time they're run.