Hi,
A document (sharepoint) is linked to a custom entity and image files can be uploaded there.
These image files are also requested to be displayed in the SSRS report.
When we trying to pull "AbsoluteUrl" field with "RetrieveAbsoluteAndSiteCollectionUrlRequest", sharepoint file url is returned directly (for example, https://{sharepoint_url}/sites/{organization_name}/{custom_entity_name}/{relativeurl})
or
When we trying to pull "absoluteurl" field from "sharepointdocumentlocation" table via fetch, "absoluteurl" field is empty.
As I understand it, I need the following url directly to display the image on SSRS: https://{sharepoint_url}/sites/{organization_name}/{custom_entity_name}/{relativeurl}/{file_name}
For example; file_name = example.png
But I can't find this url anywhere.
When I try to create the url myself, I can find the sharepoint_url, organization_name, custom_entity_name, relativeurl parameters from the "sharepointdocument" and "sharepointdocumentlocation" tables, but I could not find the filename anywhere.
Is there something wrong here or is there another way to add the related images to SSRS?
