OrderHed Image Attachment

rachelv · April 21, 2026, 3:23pm

I’m having issues with my kinetic function that has a goal of attaching an image, taken from an API pull, to an Order. Below are the steps in my function that upload and link the images:

// ================================================================
// STEP 3: Upload the image to Epicor via AttachmentSvc
// ================================================================
string uploadedFilePath = "";
string attachFileName   = $"PCID_{pcidString}_WS_{CurrentWorkstation}_{DateTime.Now:yyyyMMdd_HHmmss}.jpg";
//string base64Image      = Convert.ToBase64String(imageBytes);

try
{
    using (var attachSvc = Ice.Assemblies.ServiceRenderer
           .GetService<Ice.Contracts.AttachmentSvcContract>(this.Db as Ice.IceDataContext))
    {
        uploadedFilePath = attachSvc.UploadFile(
            docTypeID,
            $"PCID_{pcidString}",
            attachFileName,
            imageBytes
        );
    }

    if (string.IsNullOrEmpty(uploadedFilePath))
    {
        resultMessage = "AttachmentSvc returned an empty file path after upload.";
        return;
    }

    resultMessage = $"Image uploaded successfully | Path: {uploadedFilePath}";
}
catch (Exception ex)
{
    resultMessage = $"File upload error: {ex.Message}";
    return;
}

// ================================================================
// STEP 4: Link the uploaded image to each Sales Order
// ================================================================
List<string> successOrders = new List<string>();
List<string> failedOrders  = new List<string>();
int orderIndex = 1;

foreach (int orderNum in orderNums)
{
    try
    {
        // Generate unique filename per order by appending index
        string orderAttachFileName = orderNums.Count > 1
            ? $"PCID_{pcidString}_WS_{CurrentWorkstation}_{DateTime.Now:yyyyMMdd_HHmmss}_{orderIndex}.jpg"
            : attachFileName;

        // Upload a separate copy of the image for each order if multiple orders
        string orderFilePath = uploadedFilePath;
        if (orderNums.Count > 1)
        {
            using (var attachSvc = Ice.Assemblies.ServiceRenderer
                       .GetService<Ice.Contracts.AttachmentSvcContract>(this.Db as Ice.IceDataContext))
            {
                orderFilePath = attachSvc.UploadFile(
                    docTypeID,
                    $"PCID_{pcidString}",
                    orderAttachFileName,
                    imageBytes
                );
            }
        }

        using (var soSvc = Ice.Assemblies.ServiceRenderer
                   .GetService<Erp.Contracts.SalesOrderSvcContract>(this.Db as Ice.IceDataContext))
        {
            var soDS = soSvc.GetByID(orderNum);

            if (soDS == null || soDS.OrderHed.Count == 0)
            {
                failedOrders.Add($"{orderNum} (not found)");
                orderIndex++;
                continue;
            }

            var newAttach = soDS.OrderHedAttch.NewRow()
                            as Erp.Tablesets.OrderHedAttchRow;

            if (newAttach == null)
            {
                failedOrders.Add($"{orderNum} (could not create attachment row)");
                orderIndex++;
                continue;
            }

            newAttach.Company   = company;
            newAttach.OrderNum  = orderNum;
            newAttach.DrawDesc  = $"PCID Camera Capture | PCID: {pcidString} " +
                                  $"| Workstation: {CurrentWorkstation} " +
                                  $"| Camera: {cameraName} " +
                                  $"| Order: {orderIndex} of {orderNums.Count} " +
                                  $"| {DateTime.Now:yyyy-MM-dd HH:mm:ss}";
            newAttach.DocTypeID = docTypeID;
            newAttach.FileName  = orderFilePath;
            newAttach.RowMod    = "A";

            soDS.OrderHedAttch.Add(newAttach);
            soSvc.Update(ref soDS);

            successOrders.Add(orderNum.ToString());
        }
    }
    catch (Exception ex)
    {
        failedOrders.Add($"{orderNum} (error: {ex.Message})");
    }

    orderIndex++;
}

Right now in Epicor, the trigger for this function is a simple button on a custom label print screen, the DocumentType pictured below is the one that I am using within the function.

I am having an issue while testing, the function completes successfully but when I check the order header that should have an attachment, there is no attachment. Am I missing a key connection somewhere?

kve · April 21, 2026, 4:41pm

First, does the new attachment show up if you search for it in File Attachment / Attachment Path Maintenance?

Also, in your function:

…does the successOrders list contain all of the orders in your list?

rachelv · April 21, 2026, 5:30pm

The new attachment doesnt show up unless a file is manually added
To answer your second question, theoretically yes if they all make it through the try block. That line you highlighted is just setting up the array to store the order nums. Those orders are tied to a PCID and a PCID has a number of orders tied to it and this function is supposed to tie an image to all orders under a single PCID.
I should also preface that we are using DocStar.

rachelv · April 21, 2026, 8:37pm

I’ve updated the code since, this is what I am doing now. I still am not getting the image attachment on Order Header. Am I not handling the image attachment correctly or is DocStar not linking it back to Order Header?

// ================================================================
// STEP 3: Upload ONCE - DocStar stores it and returns a reference
// ================================================================
string uploadedFilePath = "";
string attachFileName = $"PCID_{pcidString}_WS_{CurrentWorkstation}_{DateTime.Now:yyyyMMdd_HHmmss}.jpg";

try
{
    using (var attachSvc = Ice.Assemblies.ServiceRenderer
           .GetService<Ice.Contracts.AttachmentSvcContract>(this.Db as Ice.IceDataContext))
    {
        // DocStarFileExistsForTableRow fires here internally before upload
        // DocStarUploadFile fires here - only need to do this ONCE
        uploadedFilePath = attachSvc.UploadFile(
            docTypeID,
            $"PCID_{pcidString}",
            attachFileName,
            imageBytes
        );
    }

    if (string.IsNullOrEmpty(uploadedFilePath))
    {
        resultMessage = "AttachmentSvc returned an empty file path after upload.";
        return;
    }

    resultMessage = $"Image uploaded successfully | Path: {uploadedFilePath}";
}
catch (Exception ex)
{
    resultMessage = $"File upload error: {ex.Message}";
    return;
}

// ================================================================
// STEP 4: Link the uploaded image to each Sales Order
//         Use GetNewOrderHedAttch instead of NewRow() so that
//         DocStar/ECM metadata is properly initialized
// ================================================================
List<string> successOrders = new List<string>();
List<string> failedOrders  = new List<string>();
int orderIndex = 1;

foreach (int orderNum in orderNums)
{
    try
    {
        using (var soSvc = Ice.Assemblies.ServiceRenderer
                   .GetService<Erp.Contracts.SalesOrderSvcContract>(this.Db as Ice.IceDataContext))
        {
            var soDS = soSvc.GetByID(orderNum);

            if (soDS == null || soDS.OrderHed.Count == 0)
            {
                failedOrders.Add($"{orderNum} (not found)");
                orderIndex++;
                continue;
            }

            // Use GetNewOrderHedAttch to mirror what the UI does -
            // this properly initializes the DocStar/ECM fields
            soSvc.GetNewOrderHedAttch(ref soDS, orderNum);

            // Find the newly added row (RowMod = "A")
            var newAttach = soDS.OrderHedAttch
                                .FirstOrDefault(r => r.RowMod == "A");

            if (newAttach == null)
            {
                failedOrders.Add($"{orderNum} (GetNewOrderHedAttch returned no new row)");
                orderIndex++;
                continue;
            }

            newAttach.Company   = company;
            newAttach.OrderNum  = orderNum;
            newAttach.DrawDesc  = $"PCID Camera Capture | PCID: {pcidString} " +
                                  $"| Workstation: {CurrentWorkstation} " +
                                  $"| Camera: {cameraName} " +
                                  $"| {DateTime.Now:yyyy-MM-dd HH:mm:ss}";
            newAttach.DocTypeID = docTypeID;
            newAttach.FileName  = uploadedFilePath; // Reuse same DocStar reference
            // RowMod is already "A" from GetNewOrderHedAttch

            soSvc.Update(ref soDS);

            successOrders.Add(orderNum.ToString());
        }
    }
    catch (Exception ex)
    {
        failedOrders.Add($"{orderNum} (error: {ex.Message})");
    }

    orderIndex++;
}

klincecum · April 21, 2026, 10:04pm

Doesn’t ecm use different upload methods? What did the trace say?

rachelv · April 21, 2026, 10:08pm

The trace doesnt even show the function hitting the network

klincecum · April 22, 2026, 12:54am

No, I mean when manually attaching. What does it show?

rachelv · April 22, 2026, 12:31pm

It attaches normally but that is not the way that is being asked, our business wants it automated by a button click from a different screen