Dec 20 2021 08:50 PM - edited Dec 20 2021 08:53 PM
I need to update multiple named range in an Excel file. Currently I need to send one graph api patch call per named range. The issue is it generates a new version every time. I have 8 named range to update, so it generates 8 versions of the Excel file in SP. Is it possible to do it with one call where I could specify the named ranges and values in the body?
PATCH https://graph.microsoft.com/v1.0/drives/[drive-id]/list/items/[Item-ID]/driveItem/workbook/names/CUSTOMER-NO/range
BODY
{
"values": [
["12345"]
]
}
Thanks