Dynamics Community Forum Thread Details

Unable to Fetch Image from SharePoint List (Image Column) using Microsoft Graph API

Hello experts,
I’m integrating SharePoint with Business Central (via AL + Graph API) to create BC Items based on list entries.

All text, choice, and boolean fields work fine — but I’m completely stuck with fetching the Image that’s uploaded via the Image column in SharePoint List.
After Microsoft’s recent changes, images uploaded to SharePoint’s Image columns are now stored as hidden attachments, not in Site Assets or /Attachments. Instead, the field just contains metadata like this:
"Image": "{\"fileName\":\"Reserved_ImageAttachment_[5]_[Image][32]_[...].png\",\"originalImageName\":\"Screenshot.png\"}"

Has anyone here found a supported approach to fetch that actual image file?
I’m specifically avoiding Power Automate and would like a direct integration in AL.

If you’ve solved this or have any pointers from Microsoft docs / roadmap, I’d love to hear them!

Thanks in advance!

Categories:

Dynamics 365 general

I wanted to share some insights about fetching images from SharePoint Image columns in Business Central via AL + Graph API. After Microsoft’s recent changes, images uploaded to the Image column are stored as hidden attachments, not in Site Assets or /Attachments. That’s why the field only gives metadata like this:

"fileName": "Reserved_ImageAttachment_[...].png",
"originalImageName": "Screenshot.png"

The good news is we can still fetch the actual image directly using Graph API — no need for Power Automate. Here’s the approach:

Get the hidden attachments

Each list item exposes its attachments through the driveItem relationship. You can call:
```
 
```
GET /sites/{siteId}/lists/{listId}/items/{itemId}/driveItem/children

This gives all files attached to the item.

Match the correct file

Use the fileName from the metadata to identify which child item is your image.

Fetch the image content

Once you have the right driveItem ID, fetch the binary with:
```
 
```
GET /drive/items/{driveItemId}/content

Now you have the actual image, ready to use in AL or store in BC.

Permissions

Make sure your app has Files.ReadWrite.All or Sites.ReadWrite.All. Without these, you won’t see the hidden files.

So, while it’s a bit different from how it used to be, this method works and is currently the supported way to get images directly from SharePoint Image columns using AL.

Quick Links