Merge documents into one single PDF file and store it in IDM

Mohit Valluri

Hi,

I'm trying to to merge multiple documents from IDM into one single PDF file and store it user FSM_PaymentOutputFileHeader document type. There will be more than 1000 documents (each containing 2-3pages) to merge. For this requirement, I am currently using Submit API Below is the input and target that I have provided.

Submit API

{
"input": [
{
"type": "xquery",
"xquery": "/FSM_PayablesPaymentOutput[@BankTransactionCode = "EPIC_MAIN" AND @CashCode = "SHCD" AND @TransactionNumber >= "1244" AND @TransactionNumber <= "1246" ] SORTBY(@LASTCHANGEDTS DESCENDING )"
}
],
"targets": [
{
"type": "item",
"include": [
"MVTEST20250910.pdf"
],
"itemdatafile": {
"type": "data",
"base64": "PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiIHN0YW5kYWxvbmU9Im5vIj8+CjxpdGVtIHhtbG5zPSJodHRwOi8vaW5mb3IuY29tL2RhZiI+Cgk8ZmlsZW5hbWU+TVZUZXN0MjAyNTA5MTAucGRmPC9maWxlbmFtZT4KCTxpc0FyY2hpdmVkPmZhbHNlPC9pc0FyY2hpdmVkPgoJPGVkaXRhYmxlPnRydWU8L2VkaXRhYmxlPgoJPGVudGl0eU5hbWU+RlNNX1BheW1lbnRPdXRwdXRGaWxlSGVhZGVyPC9lbnRpdHlOYW1lPgoJPGF0dHJzPgoJCTxhdHRyPgoJCQk8bmFtZT5DYXNoTWFuYWdlbWVudEdyb3VwPC9uYW1lPgoJCQk8dHlwZT4wPC90eXBlPgoJCQk8dmFsdWU+MTAwMDwvdmFsdWU+CgkJPC9hdHRyPgoJCTxhdHRyPgoJCQk8bmFtZT5DYXNoTWFuYWdlbWVudEFjY291bnQ8L25hbWU+CgkJCTx0eXBlPjA8L3R5cGU+CgkJCTx2YWx1ZT4xNzAxNDMxOTc4PC92YWx1ZT4KCQk8L2F0dHI+CgkJPGF0dHI+CgkJCTxuYW1lPlBheW1lbnRPdXRwdXRGaWxlSGVhZGVyPC9uYW1lPgoJCQk8dHlwZT4wPC90eXBlPgoJCQk8dmFsdWU+MTE2PC92YWx1ZT4KCQk8L2F0dHI+Cgk8L2F0dHJzPgo8L2l0ZW0+",
"filename": "MVTEST20250910.pdf"
}
}
],
"batchId": "MV1",
"jobPriority": true,
"orderedJob": true,
"orderNumber": 0,
"orderSize": 0,
"largeJob": true
}

Below XML coverted to base64

<?xml version="1.0" encoding="UTF-8" standalone="no"?><item xmlns="http://infor.com/daf">
<filename>MVTest20250910.pdf</filename>
<isArchived>false</isArchived>
<editable>true</editable>
<entityName>FSM_PaymentOutputFileHeader</entityName>
<attrs>
<attr>
<name>CashManagementGroup</name>
<type>0</type>
<value>1000</value>
</attr>
<attr>
<name>CashManagementAccount</name>
<type>0</type>
<value>1701431978</value>
</attr>
<attr>
<name>PaymentOutputFileHeader</name>
<type>0</type>
<value>116</value>
</attr>
</attrs>
</item>

When I executed the Submit API, it was success and a Job id is generated. Upon checking the Job id status using another API, below is the response

I couldn't find any new document in the IDM for FSM_PaymentOutputFileHeader data type. Below are the few questions that I have

1. Is using Submit API a right approach for this requirement?
2. If yes, Can it merge more than 1000 documents or is there a limit?
3. Why I am unable to generate a new document from the above API call?

Please suggest if this is achievable or if there is any other alternate solution.

Thanks in advance.