Calling Business Rules from Excel Using Power Query
In the previous chapter, we looked at how we could collaborate to share and edit our decision models. We also saw how to deploy them onto the OpenShift cloud so that other people could run them through an automatically generated web interface.
That was very impressive, but our colleagues are still likely to be doing most of their work using Microsoft Excel. How can we link our business rules, AI, and decision models to Excel and make all the tools work together? That’s what this chapter covers, including the following:
- Five different ways to link rules, AI, decision models, and Excel – using Power Query, Visual Basic for Applications, Script Lab, Office Scripts, and Power Automate
- Machine-readable web pages using REST and how to link these to our decision service
- Swagger – a more human-friendly link to KIE and Kogito decision services
- Calling the decision service using Power Query with step...