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!!