Prev
Next
Forums Integration / Customization S3 Customization/Development

Accessing Lawson DME from an external app

 6 Replies
 0 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
rc
Basic Member
Posts: 8
Basic Member
4/30/2008 1:56 PM

    I have been successful in sending a URL (pasted below) to the Lawson DME and having it return an XML or CSV file to a web browser. I can embed the username and password in the URL to bypass the SSO login screen, however, when I try the same URL using my downloaded http_get.c program it returns the SSO login screen. Anyone have any suggestions? is there some http options/settings I need to change? Does the web browser do something magical that I cannot in my C program?

    http://ServerName/sso/SSO...7E&_serviceName=SSOP

    mccreaja
    Basic Member
    Posts: 9
    Basic Member
    5/16/2008 12:13 PM
      Did you ever solve this? I am in the same boat. See my post on AGS and SSO. Let me know if you come up with anything. It's definitely something with the cookies.
      rc
      Basic Member
      Posts: 8
      Basic Member
      5/16/2008 12:46 PM

        There is a little sample Java program in an IOS Developer guide found on the Lawson support site that provides the API to login to SSO and call the DME. This only works on version 9...I believe just passing the URL with login info embedded will work on version 8, I have yet to try as I am awaiting the install...

        mccreaja
        Basic Member
        Posts: 9
        Basic Member
        5/16/2008 1:45 PM

          Where can I expose this API? I think I need the LHC.jar file.

          darwincollins
          Posts: 3
          5/30/2008 1:26 PM
            I responded to this thread earlier but don't see the post. In our case, we found that we need to now make two calls to the gateway (instead of 1). First one to get authenticated, get cookie, and then the 2nd to make the call to do actual work.
            rc
            Basic Member
            Posts: 8
            Basic Member
            5/30/2008 3:56 PM
              Does anyone have trouble with the data coming back from these URLs? I request quarterly deduction data for two employees in my URL using the | as the OR conditional (employee=1000|employee=1002) and I get all the employees? aggravating...I also have a problem with the amount of data coming back, it only returns so much then I get a RELOAD URL like
              RELOAD=/servlet/Router/Data/Erp?FILE=QUARTDED&OTMMAX=600&INDEX=QTDSET1&NEXT=TRUE&%28EMPLOYEE=1000%7C1002%29&FIELD=COMPANY%3BPROCESS-LEVEL%3BEMPLOYEE%3BPAYROLL-YEAR%3BQUARTER%3BDED-CODE%3BDED-AMT%3BTAX-WAGES%3BWAGE-AMOUNT%3BEXCESS&PROD=HR&OTMDELIM=%7E&SELECT=COMPANY%3D4321&OUT=CSV&SORTASC=COMPANY;QUARTER&BEGIN=4321=1200=2006=1=US=TEFW=spaces=spaces=spaces=RETIR=MN=Y&
              I try submitting this URL so I can concat this to the original but there is duplicate data? Anyone know whats going on here?


              John Henley
              Posts: 3353
              5/30/2008 7:01 PM
                What are you using as the &OUT parameter? For XML 25 records are returned. For CSV I think it's 10,000 records. Both I think can be overridden by adding &MAX=999999 or by changing $LAWDIR/system/iosconfig.xml ...
                Thanks for using the LawsonGuru.com forums!
                John