Share via

Create RangeBorder MS Graph - Not Working

Andzej Kucerenko 15 Reputation points
2024-02-20T11:49:05.42+00:00

Hello, I am facing issues while using the following MS Graph API POST Request to create RangeBorder for an existing excel file. https://learn.microsoft.com/en-us/graph/api/rangeformat-post-borders?view=graph-rest-1.0&source=docs

https://graph.microsoft.com/v1.0/me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='<address>')/format/borders
Json Body: {
"id": "EdgeTop",
"color": "#000000",
"style": "Continuous",
"sideIndex": "EdgeTop",
"weight": "Thin"
} When I attempt to use this I get the following return message: 405 Method Not Allowed

{
    "error": {
        "code": "UnknownError",
        "message": "{\"error\":{\"innerError\":{}}}",
        "innerError": {
            "date": "2024-02-20T11:45:58",
            "request-id": "4cae7f06-ce89-4413-a8c7-95a0acc5f770",
            "client-request-id": "4cae7f06-ce89-4413-a8c7-95a0acc5f770"
        }
    }
}

I tried doing it as a patch instead of a post for an existing border to amend border attributes. There was no error (200 Status) but it also did not do anything on the borders. Would you be able to double check from your side if this API call is working properly or there might be a bug?

Microsoft Security | Microsoft Graph

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.