Answered

Send HTTP Req. to Sharepoint - no longer returning serverRelativeUrl

(0) Share

Report

Posted on 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:

AI Builder

I have the same question (0)

All responses (6)

Answers (1)

Sort by

TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!

Anyone?

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

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

narayan225 2,547 Moderator on at

Like (1)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
HS-23100958-0 4 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
NW-24101307-0 2 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (1)

Report
Copy link

Link copied!

NW-24101307-0

I wrote up a step by step on how I got it working over here

Was this reply helpful? Yes No