Using suiteql how do I access the custom image file URL of the image located on the item page

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that SuiteQL does not support querying image fields directly. However, you can use a workaround to get the image URL. You can join the

ItemImage

table with the

File

table and the

MediaItemFolder

table to get the URL of the image file. Here is a sample query:

sql
SELECT
    ItemImage.Item,
    ItemImage.Name,
    ItemImage.AltTagCaption,
    ItemImage.SiteList,
    File.CreatedDate, 
    File.LastModifiedDate, 
    File.FileType, 
    File.FileSize, 
    File.URL,
    MediaItemFolder.AppFolder
FROM
    ItemImage
    INNER JOIN File ON
        ( File.Name = ItemImage.Name)
    INNER JOIN MediaItemFolder ON 
        (MediaItemFolder.id = File.Folder) 
WHERE
    ( Item = 1671 )

Please replace

1671

with the ID of the item you are interested in. This query will return the URL of the image file associated with the item. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******