IDM API Call using WebRequest (HttpWebRequest) in .Net C# using REST

I am trying to call a REST API for IDM (Infor Document Manager) from .Net C#.

This works great against M3 & Grid API's, but for some reason, not working against the IDM Specific API for some reason.

Has anyone else encountered this issue?

Sample of code not working for IDM REST API's for some reason (I have highlighted the statement that it fails on - authentication issue) :

using System;
using System.Data.SqlClient;
using System.IO;
using System.Net;
using System.Text;
using Microsoft.SqlServer.Server;

</code> <code>public partial class StoredProcedures
{

</code><code>[Microsoft.SqlServer.Server.SqlProcedure]
public static void GetImageIDM(
String serverInstance,
int IDM_Port,
String appInstance,
String IDMSection,
String IDM_ID)
{

</code><code>SqlPipe pipe_msg = SqlContext.Pipe;
try
{

</code><code>requestString = "<a href="https://myserver.mydomain.com:7443/infor/IDM/api/items/search?%24query=%2FCOSTING%5B%40OPTIVA_SYMBOL_ID%3D%22ITEMNUMBER%22%5D&%24offset=0&%24limit=1">">myserver.mydomain.com:7443/.../search</a>

</code> <code>HttpWebRequest request = (HttpWebRequest)WebRequest.Create(requestString);

</code> <code>request.Method = "GET";
request.ContentLength = 0;
request.Timeout = 3600;

</code> <code>request.ContentType = "application/xml; charset=UTF-8";
request.Accept = "application/json";

</code> <code>request.CookieContainer = cookies;

</code> <code>CredentialCache netCred = new CredentialCache();
netCred.Add(new Uri(requestString), "Basic", new NetworkCredential("myuser@mydomain.com", "MyPwd"));
request.Credentials = netCred;
pipe_msg.Send(request.RequestUri.ToString());

</code> <code>var httpResponse = (HttpWebResponse)request.GetResponse(); //*** This is where it fails!!!***
pipe_msg.Send("httpResponse: " + httpResponse.ToString());
pipe_msg.Send("request.HaveResponse: " + request.HaveResponse.ToString());

</code> <code>string response;
using (var streamReader = new StreamReader(httpResponse.GetResponseStream()))
{

</code><code>response = streamReader.ReadToEnd();
pipe_msg.Send("response: " + response.Substring(0, 3900));

</code><code>}

</code><code>}
catch (Exception ex)
{

</code><code>SqlContext.Pipe.Send("Error (GetImageIDM): " + ex.Message);

</code> <code>}

</code><code>}

}

René

Find more posts tagged with

API Usage

Accepted answers

All comments

unknown

Do yourself a favor and use the RestSharp (https://restsharp.dev/) library and Postman (https://www.postman.com/) to test the API (which will generate the RestSharp code for you to use).

Rene Bottern

Great idea, except that I can't use 'third party' DLL's since they are not accepted for my solution.

I'm building this out as a CLR SQL Stored Procedure on SQL Server 2016, and it does not allow DLL's not authorized.

0712131256598360.doc

unknown

Is that a company directive? Because it is not a technical one. See this article that illustrates the process for using third party libraries: https://www.e-iceblue.com/Tutorials/Utilize-Spire-in-SQL-CLR/Utilize-Spire.PDF-in-SQL-CLR.html

Rene Bottern

I am fairly sure it's NOT a "company directive", since I have FULL Admin rights on this Server (it's my local machine), and also, this used to work as per your link in SQL 2012, but I have tried a bunch of different ways to register the DLL on SQL 2016, but regardless of setting all the Configuration Parameters to allow for it, it will not allow me to do so (even Standard Microsoft DLL's not part of authorized list are allowed!).

If you have a solution for this, it would be GREATLY appreciated, since I can't find an answer for this anywhere.

As stated before, I can do this for any other API in the Grid except the IDM Specific ones.

unknown

So you are executing this within SQL server? And authentication fails for the IDM endpoint. What version are you on?

Are you trying to access the IDM proxy or IDM in an Infor OS installation?

The reason basic authentication would fail is if the router does not support basic authentication. So go to the endpoint in grid and check if it has basic authentication enabled. As we are using more and more SAML and redirects there types of things will be harder to do when basic authentication is not enabled.

Rene Bottern

Thanks Karin,
I will check if this might resolve my problem (turns out I already had 'basic' so that wasn't it unfortunately). Also, I have an open Ticket with Infor on this one that has gone to development, but it's been a couple of weeks without a response so hopefully they will respond soon as well.

Copyright © 2025 Infor. All rights reserved.