• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums User Experience Lawson Design Studio

DME query to L_HAPI table

 8 Replies
 0 Subscribed to this topic
 12 Subscribed to this forum
Sort:
Author
Messages
KHessing
Basic Member
Posts: 10
Basic Member
11/8/2011 7:04 PM
Has anyone attempted to do a DME call to the L_INDEX table? Or any of the 'L_' tables? I am able to do a DME call to APINVOICE and get my results but not to the L_INDEX. Was wondering if these tables can be used in Design Studio. Here is my code that is not returning results:

var x = portalWnd.DMEPath;
 x += "?PROD="+strPDL;
 x += "&FILE=L_HAPI";
 x += "&FIELD=OBJECT;NAME";
 x += "%26SELECT=L_INDEX=" + result;
 x += "&OUT=CSV&DELIM=~&NOHEADER";

var objhttp=portalWnd.objFactory.createInstance("http");
 objhttp.Open("GET",x,false);
 objhttp.Send("UserInfo");
 var sReturn2=objhttp.responseTEXT

alert(sReturn2);

My alert displays 'OBJECT' and 'NAME' but not the values for the fields. Any help would be appreciated. Thanks!
KHessing
Basic Member
Posts: 10
Basic Member
11/8/2011 7:43 PM
FYI, I have another DME that runs prior to this one and is returning the variable result. This has a valid value that is in my database table L_HAPI in L_INDEX field. Thanks.
Robert Spurr
Veteran Member
Posts: 130
Veteran Member
11/8/2011 8:37 PM
As far as I know you can't DME the tables in question. You have to use a CGI call like (cgi-lawson/writeattach.exe) or (cgi-lawson/getattachrec.exe)
KHessing
Basic Member
Posts: 10
Basic Member
11/9/2011 4:16 PM
Thanks for your response Robert! Do you have any documentation on the getattachrec.exe? I found some in Lawson Support but does not provide alot of information. I am trying to retrieve the Invoice Image for the vendor invoice combination on AP20. Does anyone have an example of this nature? Thanks much!
Robert Spurr
Veteran Member
Posts: 130
Veteran Member
11/9/2011 5:58 PM
I wish it was that easy. The best way to start is go to AP20 and click on the comment button followed by an Crtl+Alt+A and there you will find the syntax used by AP20. From there you can tweak the URL to your liking.
Sample: (cgi-lawson/getattachrec.exe?_AUDT=A&_IN=APISET1&K1=1000&K2=272&_FN=APINVOICE&K3=632625802&K4=0&_ATYP=C&K5=0&_TYP=CMT&_OPM=C&_OUT=XML&_ATTR=TRUE&_DRIL=TRUE&_AOBJ=TRUE&_PDL=TRAIN&_ON=Invoice+Note%2FReport%2FCheck+Comments) The K1-K9 match to the index used.
KHessing
Basic Member
Posts: 10
Basic Member
11/9/2011 6:24 PM
Thanks again Robert!! I appreciate your help!! I will give this a try..
KHessing
Basic Member
Posts: 10
Basic Member
11/11/2011 5:58 PM

Unfortunately I am still having issues with this. Here is my code I am trying to use:

//code for getattachrec.exe
var x = "http://lawson.fbfs.com:7740/cgi-lawson/getattachrec.exe";
x += "?_OUT=XML";
x += "&_PDL= TRAIN9";
x += "&_FN=APINVOICE";
x += "&_IN=APISET1";
x += "&K1=" + vComp;
x += "&K2=" + vVen;
x += "&K3=" + vInv;
x += "&K4=" + vSuff;
x += "&K5=" + vCanSeq;
x += "&_ATYP=U";
x += "&_AUDT=I";
x += "&_USCH=HTTP";
x += "&_KS=zz";
x += "&_OPM=A";
x += "&_DATA=TRUE";
 alert(x);

//Return value from call
var objhttp=portalWnd.objFactory.createInstance("http");
//var objhttp = new ActiveXObject("Msxml2.XMLHTTP")
objhttp.Open("GET", x, false)
objhttp.Send("UserInfo")

//Display value from call
var vURL = objhttp.responseTEXT
alert("URL:" + vURL)

Please see attached document with values of 'x' and 'URL'  along with error message. Does anyone have any thoughts on what I am doing wrong? I have tried several different ways of doing this procedure but this seems to be the closest I have come. Any help would be much appreciated. Thanks!

Attachments
Robert Spurr
Veteran Member
Posts: 130
Veteran Member
11/15/2011 8:20 PM
It takes some trail and error. The following works for me in a browser:

(With data elements)
https://{Server}/cgi-lawson/getattachrec.exe?
&_PDL=TRAIN&_FN=APINVOICE&_IN=APISET1&_ATYP=C&_OPM=C
&_DATA=TRUE&_ECODE=FALSE&K1=1160&K2=272&K3=641767014&K4=0
&K5=0&_OUT=XML

(Data element place holders)
https://{Server}/cgi-lawson/getattachrec.exe?
&_PDL={Prodcutline}&_FN=APINVOICE&_IN=APISET1&_ATYP=C&_OPM=C
&_DATA=TRUE&_ECODE=FALSE&K1={Company}&K2={Vendor}&K3={Invoice}&K4={Suffix}
&K5={Cancel Seq}&_OUT=XML
KHessing
Basic Member
Posts: 10
Basic Member
11/18/2011 7:12 PM
Thank you so much for your help!! I was able to get this to work!! What a great way to end the week!!