Adding WF attachments to IDM using Exit Point

Hi,

Today I was able to make a proof of concept for one of the missing features in ION Work Flows - the ability to copy the entire WF attachments to IDM.

This solution is using Workflow Exit Point that queries the SQL table Infor_xxx_Mingle.dbo.MingleAttachment with the Workflow ID, and for each record found it uploads the file to IDM (using icp jar).

Here is an example:

1. Starting WF with input CUNO, and some attachments

2. The Exit Point in the WF adds the attachments to IDM:

3. IDM attributes can be controlled in WF variables, like CUNO (id2). id3 is the WorkFlow ID, etc...

(done on IOS 12.0.30)

Jonathan

Find more posts tagged with

ION Workflow

Comments

Legacy Contributor

This is exactly what I was needing! Thanks for doing this!

Legacy Contributor

Great, could you guide how to do that please?

Legacy Contributor

I am having a problem on how you grabbed the attachment. I found the mingle database files but I'm not seeing the correct key fields to connect the workflow to the correct attachment. Also, can you provide sample java code or possibly the APIs you are using to push it to IDM?

Legacy Contributor

You don't mind share us the way how you do it please? Or anyone can share? Thanks

Jonathan Amiran

Hi,

Please note that this is a "proof of concept " solution is for OnPrem only.

You will need to have:

OAUTH2 ionapi file generated from ION to be able to upload files to IDM
InforOS sql connection data
Infor's WorkflowExit NetBeans project

https://github.com/jonathanamiran/idm-workflow-exitpoint/blob/master/GetMingleAttachments.java

The GetMingleAttachments class is using the WorkflowId to search Ming.le database for attached documents, then it will upload the document to IDM.

You need to test this Java code first, after it works fine, compile it to JAR and import it to the WorkflowExit NetBeans project.

There you need to write something like this:

private static final String ATTACH_IDM = "AttachIDM";

public java.util.List<Variable> execute(WorkflowInfo workflowInfo, String command, List<Variable> inputVariables) throws ExternalLogicException {

if (command == null || command.isEmpty() || CONCATENATE.equalsIgnoreCase(command)) {
return ConcatenateStrings(inputVariables);
}

if (SPLIT.equalsIgnoreCase(command)) {
return splitStrings(inputVariables);
} else if (DESCRIPTION_FROM_TREE.equalsIgnoreCase(command)) {
return getDescriptionFromTree(inputVariables);
} else if (SHOW_NOTES.equalsIgnoreCase(command)) {
return showNotes(inputVariables);
} else if (ATTACH_IDM.equalsIgnoreCase(command)) {
return attachIDM(inputVariables,workflowInfo.getWorkflowId());

} else {
throw new RuntimeException("Unknown command '" + command + "'");
}

}

private List<Variable> attachIDM(List<Variable> inputVariables,Long WorkflowId) {

String cuno = VariableHelper.getStringValue("CUNO", inputVariables);

System.out.println("cuno:" + cuno);

idm.wf.tools.GetMingleAttachments doit=new idm.wf.tools.GetMingleAttachments();

Map<String,String> attr = new HashMap<>();

String DocType="MDS_GenericDocument";
attr.put("MDS_id2", cuno );
attr.put("MDS_id3", Long.toString(WorkflowId) );
attr.put("MDS_EntityType", "WorkflowAttachment" );

// System.out.println(attr.);
doit.lstWFattachments(Long.toString(WorkflowId),DocType,attr);
return inputVariables;
}

Best regards,

Jonathan

Legacy Contributor

From your attached URL above, under public GetMinglettachments, can i know what's the function of this code: scanFolder("D:\Infor\SupplierInvoiceScanner\in"); and where can i get it.

Besides, i failed to connect SQL Server even though i enter the correct host name.

Thanks

Jonathan Amiran

Hi,

I think that scanFolder function is not used here (it's a function to get a list of files in a folder) - the SQL query gets the path and filename of the attached WF file.

What error do you get when trying to connect to the SQL server? (make sure that server/instance,user name and password are correct)

Copyright © 2025 Infor. All rights reserved.