Read full image path

Gets the full path of an image file from an Image type field. By default, the Image field returns a JSON document; this example extracts and concatenates fields to get the full URL.

SELECT *,(JSON_VALUE(MyImageField,'$.serverUrl') || JSON_VALUE(MyImageField,'$.serverRelativeUrl')) as DevicePhotoUrl,
    FROM "My SharePoint List Name"