IDM API - Update Documents

Hi all,

Inside a data flow I want to update the file of a document in IDM via IDM API. Here is what I got so far:

I have a custom BOD that contains information about the file that should be uploaded to a existing document in IDM (base64 encoded string, filename, etc..).

In the next step, I make a POST-request to get the pid of the document I want to update.

In a further step, I want to call the PUT-request with the pid I got from the first request and the data inside my custom BOD as body.

But the problem I have here is that the information I need for the PUT-request are in two separate BODs. One BOD contains the result of the first request and the other contains data about the new file.

Is there a possibility to merge these two BODs into one BOD or do I have to approach this differently?

Thanks in advance!

Best regards,

Sarah

Find more posts tagged with

Infor Document Management (IDM)

Accepted answers

All comments

Brandon Watson

Hello Sarah - You have the right steps, you just do not need the separate branches. You will need to pass your Custom BOD to the POST search/item, and then map the PID to an existing element in your custom bod. Typically I map it to an element that has a value in which I do not need in the later steps. If you do not have an open element, I would recommend adding a custom attribute to an element in your BOD. You could then write the PID to this open, and unused, attribute. You would then be able to pass your entire BOD, with PID, to the PUT item request.

The idea is to transform your current BOD with the additional data needed and pass the same BOD onto the next step in the Flow. I hope this makes sense for your and helps guide you on this project. I will be more than happy to add additional information if you need.

Thanks!

sarah-gisi

Hi Brandon,

Thank you for the reply. I still don't quite understand how I can pass my Custom BOD containing the new file to the POST request.

My request body looks something like this:

Where do I add the Custom BOD?

Brandon Watson

Hello Sarah - You can map in the fields you need from the Custom BOD to the corresponding values in the request body. Below is the request body you pasted above with an XPath to the element in itself. You will want to replace the <IonApiRef>xpath/to/element/in/custom/bod<IonApiRef> with the XPath of your custom bod. You can then do the same thing with the Response, by using in example of your custom BOD and mapping the response, <IonApiRef>item/pid<IonApiRef, to an element inside your custom BOD.

The below document contains examples of XPath and JSONPath that are helpful.

Infor ION Technology Connectors Administration Guide–Cloud Edition

<queries xmlns="">http://infor.com/daf">
<query>
<entities><IonApiRef>queries/query/entities</IonApiRef></entities>
<useTextSearch><IonApiRef>queries/query/useTextSearch</IonApiRef></useTextSearch>
<arguments>
<argument>
<key><IonApiRef>queries/query/arguments/argument/key</IonApiRef></key>
<operator<IonApiRef>queries/query/arguments/argument/operator</IonApiRef>operator>
<value><IonApiRef>queries/query/arguments/argument/value</IonApiRef></value>
<logicalType><IonApiRef>queries/query/arguments/argument/logicalType</IonApiRef></logicalType>
</argument>
</arguments>
</query>
</queries>

sarah-gisi

Hi Brandon,

Thank you for your response. Sorry for the late answer. I've had other projects I had to finish first before I could continue with this one.

I tried doing the steps you proposed and I also read the documentation about this topic.

Unfortunately, I still have one problem: If I understand correctly, a new document is created for the output. Furthermore, you can only map the data from the response to the output document.

I still don't quite understand how I can access the data of the Custom BOD I sent to the API Connection Point as input because after the GET request the data of the Custom BOD is "lost".

Copyright © 2025 Infor. All rights reserved.