Dynamics Community Forum Thread Details

Custom API for Item details with Pictures

Hi All,

We are using On-Prem Business central,

i want to create a custom API which will send item detail , sales price detail and item picture with picture URL or binary string. i tried but in the picture content we are receiving only the media link URL and i don't know i to use this media link to show data in my web page, actually another application consuming this api.

below is my code.

query 50112 GetCustomerWithOrder
{
    QueryType = API;
    APIPublisher = 'QueryV1';
    APIGroup = 'QueryGroup';
    EntityName = 'Item';
    EntitySetName = 'Items';
    elements
    {
        dataitem(ItemDetails; Item)
        {
            column(ItemNo; "No.")
            {
            }
            column(Name; Description)
            {
            }
            column(Inventory; Inventory)
            {
            }
            column(Picture; Picture)
            {
            }
            column(Base_Unit_Price; "Unit Price")
            {
            }
            dataitem(Pricelist; "Sales Price")
            {
                DataItemLink = "Item No." = ItemDetails."No.";
                SqlJoinType = LeftOuterJoin;
                column(Unit_Price; "Unit Price")
                {
                }
                dataitem(pictures; "Picture Entity")
                {
                    DataItemLink = Id = ItemDetails.Picture;
                    SqlJoinType = LeftOuterJoin;
                    column(PictureContent; Content)
                    {
                    }
                }
            }
        }
    }
    var
        myInt: Integer;
    trigger OnBeforeOpen()
    begin
    end;
}