Answered

Send HTTP Req. to Sharepoint - no longer returning serverRelativeUrl

Like (0) Share

Report

Posted on 23 Oct 2024 10:13:49 by HS-23100958-0

Hi,
 
Recently, the "Send an HTTP request to Sharepoint" returns a different output when I try to GET info from an image column.
 
This is the output of an OLD run:
{
  "d": {
    "__metadata": {
      "id": "7c424089-eaab-4da4-ab2b-e20ca317fb6e",
      "uri": "https://[DOMAIN].sharepoint.com/sites/[SITE]/_api/Web/Lists(guid'c410efef-46a6-456e-a798-ca77b24c9661')/Items(1323)",
      "etag": "\"2\"",
      "type": "SP.Data.Inspectie_x0020_Resultaten_x0020_PicsListItem"
    },
    "[IMAGE]": "{\"type\":\"thumbnail\",\"fileName\":\"2c4aab55-4cea-4fcf-aef5-860c461b9ef3.jpeg\",\"fieldName\":\"[IMAGE]\",\"serverUrl\":\"https://[DOMAIN].sharepoint.com\",\"serverRelativeUrl\":\"/sites/[SITE]/SiteAssets/Lists/c410efef-46a6-456e-a798-ca77b24c9661/2c4aab55-4cea-4fcf-aef5-860c461b9ef3.jpeg\",\"id\":\"3430c542-ab3f-4bb3-8602-966faa627560\"}"
  }
}
 
This is the output of an NEW run:
{
  "d": {
    "__metadata": {
      "id": "3eba2611-0440-4e4a-801e-229d5b46f908",
      "uri": "https://[DOMAIN].sharepoint.com/sites/[SITE]/_api/Web/Lists(guid'c410efef-46a6-456e-a798-ca77b24c9661')/Items(1422)",
      "etag": "\"3\"",
      "type": "SP.Data.Inspectie_x0020_Resultaten_x0020_PicsListItem"
    },
    "[IMAGE]": "{\"fileName\":\"Reserved_ImageAttachment_[10]_[Afbeelding][36]_[9b918b28-a96b-4a31-aeef-9b7d08869f4a][1]_[1].jpeg\"}"
  }
}
 
As you can see, the fields from this Image column have been replaced by just a "fileName" field.
 
 

Categories:

Entity Extraction

All responses (6)

Answers (1)

TheRobRush 11,121 Super User 2025 Season 1 on 24 Oct 2024 at 17:21:26

Like (1)

Report

Send HTTP Req. to Sharepoint - no longer returning serverRelativeUrl

NW-24101307-0

I wrote up a step by step on how I got it working over here
NW-24101307-0 2 on 24 Oct 2024 at 13:32:55

Like (0)

Report

Send HTTP Req. to Sharepoint - no longer returning serverRelativeUrl

HS-23100958-0 can you please share your work with me?

I have a flow that works on the old rows, like yours. But I cant get i to work on the new rows... so annoying
HS-23100958-0 4 on 24 Oct 2024 at 08:43:05

Like (1)

Report

Send HTTP Req. to Sharepoint - no longer returning serverRelativeUrl

So, if you update your api to _api/Web/Lists(guid'[LISTGUID]')/Items(1)/AttachmentFiles

It will return the following:

This was indeed the solution, thank you!

FYI you're better off using the "Get attachments" action now (together with "Get attachment content"), easier to process the outputs.
Verified answer

narayan225 2,507 Super User 2025 Season 1 on 24 Oct 2024 at 01:37:50

Like (1)

Report
Send HTTP Req. to Sharepoint - no longer returning serverRelativeUrl

it seems to store it as an attachment now.

So, if you update your api to _api/Web/Lists(guid'[LISTGUID]')/Items(1)/AttachmentFiles

It will return the following:

{ "d": { "results": [ { "__metadata": { "id": "https://contoso.sharepoint.com/_api/Web/Lists(guid'1311aabd-0ae3-42b3-8382-f418d85dd0a4')/Items(1)/AttachmentFiles('Reserved_ImageAttachment_[5]_[Image][28]_[Annotation 2024-10-24 114613][1]_[7].png')", "uri": "https://contoso.sharepoint.com/_api/Web/Lists(guid'1311aabd-0ae3-42b3-8382-f418d85dd0a4')/Items(1)/AttachmentFiles('Reserved_ImageAttachment_%5B5%5D_%5BImage%5D%5B28%5D_%5BAnnotation%202024-10-24%20114613%5D%5B1%5D_%5B7%5D.png')", "type": "SP.Attachment" }, "FileName": "Reserved_ImageAttachment_[5]_[Image][28]_[Annotation 2024-10-24 114613][1]_[7].png", "FileNameAsPath": { "__metadata": { "type": "SP.ResourcePath" }, "DecodedUrl": "Reserved_ImageAttachment_[5]_[Image][28]_[Annotation 2024-10-24 114613][1]_[7].png" }, "ServerRelativePath": { "__metadata": { "type": "SP.ResourcePath" }, "DecodedUrl": "/Lists/Stationary Orders/Attachments/1/Reserved_ImageAttachment_[5]_[Image][28]_[Annotation 2024-10-24 114613][1]_[7].png" }, "ServerRelativeUrl": "/Lists/Stationary Orders/Attachments/1/Reserved_ImageAttachment_[5]_[Image][28]_[Annotation 2024-10-24 114613][1]_[7].png" } ] } }

And as you can see rom above, it will have ServerRelativeUrl, uri as well as the DecodeURL if you need it.
TheRobRush 11,121 Super User 2025 Season 1 on 23 Oct 2024 at 17:46:08

Like (0)

Report

Send HTTP Req. to Sharepoint - no longer returning serverRelativeUrl

I can add that it still works on old images added before whatever switch occured happened.

So appears to be an issue at time of CREATION of image in image column, these columns are not being generated on the new files.
TheRobRush 11,121 Super User 2025 Season 1 on 23 Oct 2024 at 17:42:59

Like (0)

Report

Send HTTP Req. to Sharepoint - no longer returning serverRelativeUrl

Anyone?

Think this may need to be seen by support at microsoft.

Community site session details

Send HTTP Req. to Sharepoint - no longer returning serverRelativeUrl

Helpful resources

News and Announcements

Quick Links

Announcing the Engage with the Community forum!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Leaderboard > Power Automate - AI Builder

Featured topics

Product updates

Community site session details

Send HTTP Req. to Sharepoint - no longer returning serverRelativeUrl

Helpful resources

News and Announcements

Quick Links

Announcing the Engage with the Community forum!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Subscribe to this forum!

Select categories

Leaderboard > Power Automate - AI Builder

Featured topics

Product updates