LAPI VBA Create mail folder

I would like to implement LAPI in VBA to create email folders into specific LivelinkID or to just move mails from Outlook to Livelink. I didn't find any specific documentation on how to implement this in VBA (or whether it's possible or not), any help would be much appreciated.

I'm actually using the VbaOutlook.OTM project-file and MAPI to move mails to Livelink but it's kinda slow and I need to use the fullpath into Livelink instead of just the ID.

Thank you.

Find more posts tagged with

Comments

Luc Pelletier

(we're using Livelink ® Version 9.7.1 and I don't have any root access to the server, I'm already using the web services to export some XML data from Livelink but I didn't find any documentation about the mail folders which are handled a little bit differently than the usual file or folder in Livelink)

Appu_Nair1

I have messed with LAPI for several years but unfortunately I did not do anything with VBA or email.LAPI's replacement is webservices and Enterprise connect i.If you are serious about programming in lapi you may have to extend it in Oscript to add the call.I have written somethings that show you how to convert a dataid into path and vice versa but that I reckon is not what you are looking for.

Webservices has inbuilt support for getnodebyid,getnodebypath etc.I do not know if they support email or not. You might want to look at how Enterprise Connect(XML API) doe sthat to see if that gives you better options.then again EC programming is also a black box to me.

here's an interesting thread about the future of lapi

https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objId=33077212&objAction=viewincontainer

My intention is not to help but to point you that OT does not really put any efforts helping people sticking on to lapi but rather they would have new projects done in webservices so you might not get the same amount of lapi help say 5 years back in this forum.

Luc Pelletier

I would really love going the webservice route, because it's easy to do with VBA, I'm using Fox with Firefox to look at the POST data of what I can do with the Web interface and I've already been able to construct some great URLs that do what I want. Just one example:

        postData = "func=ll&objAction=copyModel2&objID=" & modelId _
                    & "&nextURL=%2Flivelink%2Flivelink.exe" _
                    & "&DEST_NAME=" & folderName & "&DEST_ID=" & objId _
                    & "&COPY_Required=0&COPY_Edited=0&COPY_CacheID=0&CopyOption=0" _
                    & "&COPY_CatNames=Attributs+g%E9n%E9raux"

This portion of URL allows to copy an entire model structure folder to another destination. I really enjoy being able to do this in VBA.

You talked about getNodeById and getNodeByPath. Is there a way to convert a ID to a fullPath using the webservices the way I do? I would like to take for example 123456789 and get Livelink\Entreprise\myFolder1\myFolder2\myFolder123456789\. Is this possible? It would already help me a lot.

The problem I have is moving mails from Outlook to Livelink, as described in this topic: https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objId=33234071&objAction=viewincontainer

Actually using MAPI to do so, I need the whole Livelink fullPath, which is a lot to store in any MDB (Access 2003). Being able to return the fullPath from the server with only the LivelinkId would already help me A LOT even if it doesn't help me not using MAPI (which is really slow).

Luc Pelletier

Thanks for your input by the way and this is how I actually connect with the server, sending the postData above:

        Set ObjHTTP = New MSXML2.XMLHTTP
        ObjHTTP.Open "Post", LIVELINK_SERVER, False
        ObjHTTP.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
        ObjHTTP.send (postData)

I'm also sorry for my English, this is my 2nd language.

Appu_Nair1

See this file by another user in webservices

https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objaction=overview&objid=16680890

I was able to write some C# stuff based on that.

I wrote like this

//if you know parentid you can get a node's ID
Console.WriteLine(dm.GetNodeByName(dmOTAuth, 105360498, "Reports").ID.ToString());

also the TreeApplication has a lot of basic code to get you started

Luc Pelletier

He's using LivelinkNameChange.MemberService and LivelinkNameChange.DocumentManagement. Are those DLLs or something? I would love to add those as references to my VBA projects.

Actually, using a C# script to move the selected mail in Outlook into Livelink implies that I learn how are Outlook add-ins working, while with VBA is all integrated, except for the Livelink part.

I guess there is no way to return with a simple POST request as shown in my above reply the object's fullpath for a specific objId? I would have to implement this in C# and take a lot of time to learn how to interact with my VBA after this just to do so? That's really sad.

For me, I thought Web service (REST in this case) means being able to ask the server anything by POSTing some data. I thought it was totally language-independant. I guess I'm wrong.

Kyle_Swidrovich

Hi Luc,

The Content Web Services API for Content Server is not a REST-compliant web service. It uses SOAP for communication.

You can ask the server to do something via POST in this case, however, what you’re posting must conform to a certain protocol.

SOAP is language independent, however, some dev environments offering IDEs for certain languages come with libraries that facilitate communication with web services over SOAP (e.g., .NET = Microsoft WCF and Java = JAX-WS).

Not sure what’s available for you through VBA, however, VBA.NET may allow you to take advantage of Microsoft’s WCF for SOAP-based communication.

Kyle