Who's On?

	Membership:
	Latest: John Bonin
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5270

	People Online:
	Visitors: 410
	Members: 0
	Total: 410

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1375
Roger French	1315
mark.cook	1244

Accessing Lawson DME from an external app

6 Replies

0 Subscribed to this topic

17 Subscribed to this forum

Sort:

Author

Messages

Basic Member Send Private Message

Posts: 8

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

Deleted User

New Member Send Private Message

Posts: 0

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.

Basic Member Send Private Message

Posts: 8

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

Deleted User

New Member Send Private Message

Posts: 0

5/16/2008 1:45 PM

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

Deleted User

New Member Send Private Message

Posts: 0

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.

Basic Member Send Private Message

Posts: 8

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: 3351

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