The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Accessing the SLX API within ASP.NET
Posted: 20 Sep 06 12:43 PM
|
fiogf49gjkf0d Is it possible to access the SalesLogix API from within an ASP.NET application?
If so how do you do it, is it by using Create Object or by adding a reference top the project?
--
Many Thanks
Duncan |
|
|
|
Re: Accessing the SLX API within ASP.NET
Posted: 20 Sep 06 1:04 PM
|
fiogf49gjkf0d Hi Duncan,
So what exactly are you wanting to do? Reference the SlgxApi.dll, the Application object, SalesLogix Provider?
1) Don't use the SlgxApi.dll from a web app. You're headed for poor performance and a whole lot of issues. Pretend this option isn't there (since it's really only still around for legacy purposes & backwards compatibility)
2) Don't use the Application object in a web app. The application object requires the client to be running on the server and that just doesn't make any sense at all for a web or serviced application. Not really even a remotely reasonable option.
3) SalesLogix Provider is the way to go. Just use the classes in the System.OleDb namespace and fly along as normal.
So, when you say "SalesLogix API" what exactly are you referring to? |
|
|
|
Re: Accessing the SLX API within ASP.NET
Posted: 20 Sep 06 1:23 PM
|
fiogf49gjkf0d Thanks Ryan, its good to know what not to use and why.
Basically I want access to some of the saleslogix functions i.e.
GetContactGroups() or GetNextSLXID("tablename")
I know the two above aren't the correct function names, but as I don't have access to SLX now, its a best guess
---
Many Thanks
Duncan |
|
|
|
Re: Accessing the SLX API within ASP.NET
Posted: 20 Sep 06 2:28 PM
|
fiogf49gjkf0d Those kinds of functions require access to the application object, which is only accessible if the client is running. Won't help you for a web app.
For many things there is a way to do it without accessing the application object.
For creating ID's see this: http://www.slxdeveloper.com/page.aspx?action=viewarticle&articleid=87
For getting contact groups, you'll have to dig those from the database.
If you run into any functionality you can't get to, post it here and we'll see if there's another way to accomplish it.
As an aside, it is frustrating when you run into things that require the client and cannot be done via the OLE DB provider alone (things that don't require user context that is). Some day we'll have a complete set of business objects we can use from any app regardless of whether the client is running or not. For now we'll just dream  |
|
|
|
Re: Accessing the SLX API within ASP.NET
Posted: 20 Sep 06 3:16 PM
|
fiogf49gjkf0d Thanks Ryan,
I've already put together a function to read groups which is relatively straight forward until you get to groups that have "within the last xxx days"
The blob file for this is all over the show and means creating a pretty complex scrip to interrogate and tern it it to something useful.
It looks like Sage are planning big architecture changes for v7.2/v8 with a move to .Net, so hopeful that will include opening up these business objects for external use.
Thanks for the help!
--
Duncan |
|
|
|
Re: Accessing the SLX API within ASP.NET
Posted: 20 Sep 06 3:20 PM
|
fiogf49gjkf0d Just on another point do you or someone else have a list of the call that can be made via the SLX Provider or is it just the slx_dbids
Thanks Again
--
Duncan |
|
|
|
Re: Accessing the SLX API within ASP.NET
Posted: 20 Sep 06 3:32 PM
|
fiogf49gjkf0d Here's the list as of 6.1, guess it is time to update this for 6.2 & 7.0. BTW, there is a doc from Sage about the OLEDB provider that has the complete list as well. I guess I'll see if I can post that here (you being a bp should have access to it already, if you're not sure ask Spragg and I am sure he has it).
-Ryan |
|
|
| |
| |
|
Re: Accessing the SLX API within ASP.NET
Posted: 21 Sep 06 2:34 AM
|
fiogf49gjkf0d Thanks Mike, the full list provided by Mr Spragg for any one who needs it is as follows
fx_rowaccess()
slx_ClearGlobalID
slx_CycleLogFile
slx_DBIDs
Slx_GetConcurrentAvailable
slx_GetLoggedInServerInfo
slx_GetNativeConnInfo
slx_GetServerList
slx_getUserInfo
slx_RefreshDictionary
slx_RefreshLogServer
slx_RefreshRWPass
slx_RefreshUser
slx_RWPass
slx_SendClientLog
slx_SetGlobalID
slx_SetLogging
slx_settimezone
slx_TestLogPath
slx_timezonelist
slx_WNDeleteCAO
slx_WNInsertAccount
slx_WNInsertCAO
slx_WNInsertContact
slx_WNInsertOpp
slx_WNUpdateCAO
sp_AliasList
|
|
|
|