[isams] iSAMS API - GoogleScript

[BFish]

Just out of curiosity if anyone has any iSAMS API scripts they've developed in house? Our school invests in a workflow called Kissflow (love it) and we are trying to get iSAMS student lists into a Google Sheet so that we can then import daily into Kissflow. Unfortunately, after 12 hours of reading and studying I have struck out

[dhicks]

Just out of curiosity if anyone has any iSAMS API scripts they've developed in house? Our school invests in a workflow called Kissflow (love it) and we are trying to get iSAMS student lists into a Google Sheet so that we can then import daily into Kissflow.

 

Yes, I'm working on this at the moment. We've recently moved to iSAMS from another MIS, for which I had an assortment of Python scripts that would extract data and then format it in various ways as needed - assorted sets of CSV files for importing into various services that need lists of usernames and so on, and some formatted, printable PDF documents. I'm currently working on moving that code over to deal with iSAMS data - hopefully it shouldn't take too much work once I get started as it should just be a case of making sure the data extracted from iSAMS is in the format needed for the rest of the scripts.

 

The scripts I have so far aren't ready for general use yet - they include a general configuration script that I haven't tested much yet, and I wouldn't want someone to run it and mangle a working setup.

[supportman]

Is there an API tuturial or specification anywhere for iSams? I'd be interested in taking a look.

[dhicks]

Is there an API tuturial or specification anywhere for iSams?

 

Not that I've discovered so far - last time I check (a few weeks ago), the "developer" section of their website was closed for updates. The batch API section is actually pretty self-explanatory - you can select which data is returned for each separate API key, and the interface for selecting that data is sensible and well-organised, with different types of data in different sections and so on. So far I've simply set up to extract basic data on pupils and staff for username export and similar, I'm working up to getting more complex data out.

[Bgmcderm]

Hi, its been a while since you posted this, how have you gotten on since, we are mid deploying iSAMS and I expect we will need to use the API to grab key information to support other business processes like AD account creation, O365 account creation, Moodle course assignments etc ... would be great to hear how you have progressed. Also has anyone tried a direct database connection as opposed to operating via API?

[TechMonkey]

Hi, its been a while since you posted this, how have you gotten on since, we are mid deploying iSAMS and I expect we will need to use the API to grab key information to support other business processes like AD account creation, O365 account creation, Moodle course assignments etc ... would be great to hear how you have progressed. Also has anyone tried a direct database connection as opposed to operating via API?

(Not stalking you honest!)

Have you looked at SalamanderSoft? They tap into the iSAMS APIs to automatically provision users, M365 licenses, create mailboxes and definitely used to sync with Moodle. They can build really intricate rules and I haven't found anything they haven't been able to do yet.

 

If you are iSAMS hosted, they are very touchy about you accessing the database directly, they really push you to use the API. You can get access, you will have to nominate an IP that will be allowed. We do it to create SSRS reports.