Retrieve data using a REST API to our school database
I work for a school and we are using a very big system for the management of all our teachers, students, courses, and so.
I'd like to work with Bonita to to automate some processes. I can access my school database using ar rest api. With it, I first have to authenticate then I'm gonna get a token. Finally, I will be able to query my database by asking it to send me the result of a query in the form of a json file.
Is it possible to use Bonita to automate this process and use the json file to make some other jobs. If yes, should I have to buy the business version to do that ?
I could imagine asking the school database all notes of a specific student for example ...
The final idea is to make a process for the students requesting a day off. I should first authenticate the student, than requesting the class this student belongs to. Finally, with that information, I should send another request using another Rest Api to the Untis Database Software (software to manage timetables). With that, I could have the list of courses this student is going to misss....
Thanks to all for your help.
I believe your requirement should be addressed by "connectors in" functionality defined for a task. You should be able to get student's data (user_id) after authentication and call business process that does the rest (connecting to external system and fetch required data for a student and further processing)