Get User requesting service URL(ODATA)

[fabio.morciani]

Hi Guys!

Im creating some odata services so ours users can consume it with excel and work with some data and it is working!

The problem now is: some services need to filter the data by user.

How do i get the user (windows authentication) who is requesting the odata and pass it as a parameter for my odbcAdapter, wich is executing a storedprocedure?

im using IS 10.5, on-premisse installation.

[Holger_von_Thomsen]

Hi Fabio,

did you check if the user is present somewhere in the ODATA request data, i.e. some sort of header line like it is used in HTTP headers?

Regards,
Holger

[fabio.morciani]

that the point. How do i check this inside the integration service?

[skumar9]

Have you tried using pub.flow:getTransportInfo to get Session information. It should have user info in it.

[fabio.morciani]

no luck. pub.flow:getTransportInfo give me information about de http request, but only protocol, url, and the caller IP but not the username.

?

[rmg]

Hi fabio,

Nope…not anything related to user id it will not extract.

HTH,
RMG

[John_Carter4 (John Carter)]

You won’t get it from the getTransportInfo service, however you can do it with a java service.

You can use my package here

GitHub - johnpcarter/JcPublicTools: webMethods Integration Server package...

and the service is

pub.flow.session: getSessionID

the output also includes the userID associated with current call.

the java code is

public static final void getSessionID (IData pipeline)
        throws ServiceException
{
	// --- <<IS-START(getSessionID)>> ---
	// @sigtype java 3.5
	// [o] field:0:required sessionID
	// [o] field:0:required userID
	// [o] field:0:required uniqueID
   
   String sessionId = null;
   String name = null;
 
    if (Service.getSession() != null) 
    {
        try {
            sessionId = Service.getSession().getSessionID();
            name = Service.getSession().getUser().getName();
        } catch (Exception e) {
            throw new RuntimeException("Unable to retrieve the session ID : " + e);
        }
    }

    IDataCursor c = pipeline.getCursor();
    IDataUtil.put(c, "sessionID", sessionId);
    
    if (name != null && !name.equals("Default") && !name.equals("webTaskUser"))
    		IDataUtil.put(c, "userID", name);
    
   IDataUtil.put(c, "uniqueID", sessionId + getNextCount());
    c.destroy();
   
   // --- <<IS-END>> ---
}

enjoy
John.

[Sonam_Chauhan]

@John_Carter4 answered the question. But just adding … you may want to authorize based on the group instead of username (say, you have Single-signon setup and use Active Directory group to class your users).

Code:

//Returns details of the user controlling the currently executing session.
		
		//Get the current session
		Session currentSession = Service.getSession();
		
		//Get current user
		User user = currentSession.getUser();
		
		//Assign the username value to strUsername
		String strUsername = user.getName();
		
		Vector<String> vectorMembershipNames = user.membershipNames();
		String [] membershipNames = vectorMembershipNames.toArray(new String [vectorMembershipNames.size()]);
		
		//insert the username and other details into the pipeline
		IDataCursor idcPipeline = pipeline.getCursor();
		idcPipeline.insertAfter("username", strUsername);
		idcPipeline.insertAfter("membershipNames", membershipNames);