Uploading CSV file to Infor IDM using IDM Api

Hi There,

I need some help on finding API for uploading a CSV file to IDM from External system, currently I'm using api/items API to upload the file, However, it's only creating an Icon of the file in IDM but not the whole file. Below is the JSON data which I'm providing to API and I'm testing it from Postman. Also, In JSON I can only give the details of the file but, where do provide the actual file payload? I see that there is an option for BINARY where I can upload the file but with POST request I can only use either RAW or BINARY.

{

"item": {

"attrs": {

"attr": [

{

"name": "Upload_Id",

"value": "TLLU52381532_OV.csv"

}

]

"resrs": {

"res": [

{

"filename": "TLLU52381532_OV.csv",

"base64": "Y29udGVudCBoZXJlLg=="

}

]

"acl": {

"name": "Public"

"entityName": "ASN_Upload"

}

Thank you in advance for your help.

Find more posts tagged with

Infor Document Management (IDM)

Accepted answers

Christiaan Rentier

IDM/api/Items is meant for adding an Item including the corresponding file. IDM/api/items/{pid}/resource is meant for updating a resource. Preferably do all in one API call.

You must base64 encode the binary string there. Please test first removing the == at the end! Secondly try removing the array for res like below:

"resrs": {

"res": {

"filename": "TLLU52381532_OV.csv",

"base64": "Y29udGVudCBoZXJlLg=="

}

All comments

unknown

Hi @christiaan-rentier Could you provide some guidance on this request.

Thank you.

Rene Bottern

Try this API instead, it will allow you to upload in 'octet-stream BASE64' format (essentially any type of object), although you should be able to do the same with API you used above in the 'base64' string.

Christiaan Rentier

IDM/api/Items is meant for adding an Item including the corresponding file. IDM/api/items/{pid}/resource is meant for updating a resource. Preferably do all in one API call.

You must base64 encode the binary string there. Please test first removing the == at the end! Secondly try removing the array for res like below:

"resrs": {

"res": {

"filename": "TLLU52381532_OV.csv",

"base64": "Y29udGVudCBoZXJlLg=="

}

unknown

Hi Christiaan,

Thanks for your help!

1. I have tried the approach you mentioned for IDM/api/Items, by removing == and [] array, but it still creates an Icon of the file, not with data in it.

2. Second API - IDM/api/items/{pid}/resource must be reaching the server, However, It says unsupported Media Type while I'm trying to send .csv file. Although If we upload the .csv file manually in this same IDM ASN_Upload folder in Infor IDM, it's accepting.

3. Below is the configuration I'm using from Postman

API Parameters

Content-type

Body - Form-data

Result - Unsupported format

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

<error xmlns="">http://infor.com/daf">

<message>HTTP 415 Unsupported Media Type</message>

<detail>HTTP 415 Unsupported Media Type</detail>

</error>

Not sure where it's going wrong, Let me know if anything I'm missing here.

Thank you, Appreciate your help.

unknown

Hello Rene Bottern,

Thanks for your response.

I have tried this API and the result says, Unsupported format. I have replied in this thread, Kindly check I'm missing anything.

Thank you.

Rene Bottern

I think there's something I'm missing here?

If you upload a file with CSV extension, it will show as a Icon as indicated in IDM, and when you try to open it, it will try an open this in Excel.

If you use a 'TXT' extension instead, the content will who in the Preview like below.

unknown

Hi Rene Bottern and Christiaan.

Found the issue, the value of base64 was wrong. Once I passed the corrected base64 value, .csv file is created in IDM using IDM/api/Items.

Anyway, thanks for your time, it was helpful for me to troubleshoot the issue and fix it.

Thank you.

Ford GTL.pdf

Copyright © 2025 Infor. All rights reserved.