calling LiveLink Search API from Oracle PL/SQL Stored Proc

[foralexhui]

Anyone with experience with accessing Livelink via "Livelink Search API" from a Oracle PL/SQL stored proc?

Bascially, I would like to grab some meta data related to certain scanned doc in Livelink and stored them in Oracle data table.

My main problem is that my Oracle (as a client) is not NTLM compatible. but I did request a user/pwd pair created for me from my Livelink admin guy. So I need some info or clarification about the Livelink authentication+cookies workflow to code my PL/SQL code.

Any suggestions?

PS: I don't have access to Opentext knowledgeBase.

 

[appnair]

I do not know the answer to your qn.If you are coding in Oracle why do you need to use the searchxmlapi to get metadata wouldn't it be just much easier to do a view on the category that you are trying to report ?

Searchapi is used IMHO to query and make the livelink serachengine do the work....

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

 

[foralexhui]

It is the silly corporate enterprise policy. The Oracle server/instance that I am on is from another app/domain. Livelink lives on another Oracle server.

I am asking my Oracle server to behave like a client. So it is like writing a .Net desktop/Winform app that access Livelink meta-data using LL search API. Conceptually, it is trying to integrate to Livelink datastore.

It is silly but most corp world environments are like that.

Any info on how cookies are used in livelink to maintain connection between a client and Livelink server?

Alex

 

[appnair]

on first time login to a livelink webserver the webserver issues a cookie to the browser.After login there is a LLCookie
that has your info for subsequent login is that what you are asking.Depending on how the administration is set up the cookie expires using pre-defined mechanisms.

When IWA is present on the livelink webserver the webserver authnticates and issues the cookie.However livelink will use the REMOTE_USER variable in the http header to authenticate the user.

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

 

[foralexhui]

Cool. I saw LLCookie with Firefox. It is set to expire at the end of the session.
I will try preserving the Cookie during my session within my Oracle PL/SQL Stored Proc.

I will also check out the REMOTE_USER header.

Thank you very much.


Will let you know the outcome.

 

[foralexhui]

Hey appnair:

1 more question.

Other than cookie "LLCookie".
Should I be preserving 2 other cookies "LLInProgress" and
"LLTZCookie" that I saw?

They appeared in the response header from my initial login URL
request like this.

Set-Cookie: LLInProgress=; Expires=Sun, 01 Jan 1995 08:00:00 GMT; path=/Livelink/
Set-Cookie: LLCookie=7GSQ5UllsQsER%2F3EDKvTZ55Dcdif7FGZe7mRykJU7lI%3D; path=/Livelink/
Set-Cookie: LLTZCookie=0; path=/Livelink/

 

[appnair]

I do not know that but in the LAPI documentation there is a method that does allocatesessionfromcookie ie after initial authentication.Perhaps if you trace its working you will get better ideas.I am tempted tso aay that the Time Zone Cookie is only so that the GUI can report current correct time and the inProgress to vet that the call has passed the webserver.

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

 

[foralexhui]

LLInProgress may be used when you are "paging" your search API result using the SATRTAT and GOFOR options.

e.g. if func=search returns 1000 rows, but I want 200 rows at a time. then LLInProgress is used to stored a session ID to indicate which page I was on.

But it is just my guess. Since I don't have access to LAPI documentation. I can't really tell.

Thanks anyway.