Repository for publishing the integrated story of Maximo Manage + Watson.ai + Watson Assistant & Discovery

This example of github repo is to demonstrate of the ability to leverage certain AI and Generative AI functionality already built into the product as well as all the new use cases that are being continuosuly added into the product. this is an example of showcasing Watson Assistant be integrated with Maximo Manage module

Below diagram presents the architecture view of application flow

High level architecture

Technical Flow

Pre-Requisites for setup

1. Maximo Manage module installed and ability to make API requests to the application
2. Watson Assistant Project created to upload the code snippet
3. Environment to deploy "Flask" or 'IBM Code engine" to setup API's to make requests (API) from Watson Assistant

Maximo DB Interface

In this documentation lets explore about the following.

• How to run the application locally
• How to create Docker image
• How to deploy the Docker image in the Code Engine (to access the app remotely)
• Creating Open API using Swagger
• Create Custom Extension in Watson Assistant
• Add Custom Extension to Watson Assistant
• Create Action in Watson Assistant to call the custom extension

1. Run Locally

To run the application locally follow the below steps.

CLICK ME

1.1 Download the repo

1. Download this repo

2. Goto to the root folder of the repo.

3. Do the following steps.

1.2 Env file

1. Create .env file with the below entries.

2. Update all the properties accordingly.

LOGLEVEL=INFO

GENAI_API="https://us-xxxxxx.ibm.com/ml/v1/text/generation?version=2023-05-29"
### IBMCloud API Key
GENAI_KEY="xxxxxxx"
GENAI_PROJECT_ID="1c915286-xxxxxxfa4e"

MAXIMO_ATTRRIBUTE_URL="https://xxxxxx.com/maximo/api/os/MXAPIMAXATTRIBUTE?oslc.where=persistent=1%20and%20objectname=%22"
MAXIMO_RUNSQL_URL="https://xxxxxxxxxxxx.com/maximo/api/script/runsql?lean=1&ignorecollectionref=1"
MAXIMO_API_KEY="xxxxxxxxxxxxx"

1.3 Run the app

1. Runs the below command to start the app

python main.py

2. Open the below urls in a browser to verify the app is running.

http://localhost:8080/hello/

http://localhost:8080/books/

http://localhost:8080/maximo/

3. Run the below curl script to test the maximo api.

curl -X 'POST' \
  'http://localhost:8080/maximo/' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -d '{
  "query": "What is the worktype of workorder 1309?"
}'

It would give the output like the below.

{
  "result": [
    {
      "WORKTYPE": "PM"
    }
  ]
}

2. Create Docker Image

You can create docker images using podman and run the app in the code engine.

Here docker.io is used as a image repository. You can use as per your wish.

In the below example we used gandigit as a docker id. You have to change it to your docker id.

CLICK ME

2.1 Docker login

1. Run the below command to login into docker.io

podman login -u gandigit docker.io

2.2 Create Image

1. Run the below command to create docker image

podman build --platform linux/amd64 -f Dockerfile -t docker.io/gandigit/maixmo-db-interface:latest .

2.3 Push image to the Image Repository

1. Run the below command to push the created image to the repository

podman push docker.io/gandigit/maixmo-db-interface:latest

3. Deploying the Docker Image in Code Engine

Lets deploy the created docker image in the Code Engine.

CLICK ME

3.1 Create Project

1. In Projects screen, click on Create button

2. Choose Location as per your need.

3. Enter any Project Name

4. Click on Create button

Project is created.

5. Click on the created project

3.2. Create Application

1. In Application screen, click on Create button

2. Enter any Application Name

3. Enter the Docker Image name that we already created.

4. Click on Configure image button

5. Choose https://index.docker.io/v1/ in the Registry server drop down list.

The rest of the details would be auto filled based on the docker image name that we entered in the previous screen.

6. Click on Done button in the image configuration screen.

7. Click on Create button

8. Application got created.

3.3. Create Environment variable

1. Click on the application name from the above screen.

The application page get displayed.

2. Click on Configuration tab.

3. Click on Environment Variables tab.

4. Click on Add environment variable menu.

5. Choose Literal value Option.

6. Enter Environment variable name and Value columns values.

7. Click on Add Option.

8. Click on Add Option. The variable got created.

9. Similarly create an entry for each Environment variables mentioned in the .env-sample file.

10. Click on Deploy Option to redeploy the app with the created environment variables.

3.4. Open the Application

1. In the application screen, Click on the Open URL link to open the application.

4. Creating Open API using Swagger

Lets create open API using swagger. This open api json is needed to create extension in Watson Assistant for WA and this app integration.

CLICK ME

Create Open API

1. Open the URL https://converter.swagger.io/ in your browser

2. In the GET / Convertor method, click on the Try it out button

3. In the URL text box enter the App url suffixed with swagger.json

   Ex: https://maxxxxxxxx.appdomain.cloud/swagger.json

4. Click on Execute button

The Open API json should have got created.

5. Click on Download button

6. Open the downloaded json and update the App url as highlighted

The download file may look like this ./files/OpenAPI-Maximo.json

7. In the above file you need to change the line no. 10 "url": "https://xxxx.appdomain.cloud" with the appropriate url from the code engine.

5. Create Custom Extension in Watson Assistant

Lets create Custom Extension in Watson Assistant to call the app.

CLICK ME

1. In Watson Assistant, Click on Integration button

2. Click on Build custom extension button

3. Click on Next button

4. Enter any Name for the extension.

5. Click on Drag and drop file here or click to upload link

6. Choose the Open API Json that was generated in the previous section.

7. Click on Next button

8. See the list of APIs imported.

9. Click on Finish button

Extension got created.

6. Add Custom Extension to Watson Assistant

Once the Custom Extension is created, it has to be added to WA.

CLICK ME

1. In the created Extension, Click on Add button

2. Click on Add button

3. Click on Next button

4. Click on Next button

5. Click on Finish button

Extension got added.

Now this extension can be used in WA.

7. Create Action in Watson Assistant

Lets create action in WA to use this extension.

CLICK ME

7.1 Create Action

CLICK ME

1. Click on Actions menu in WA

2. Click on New action button

3. Click on Start from scratch tile

4. Enter name for the action.
5. Click on Save button

6. Click on customer starts with Tile

7. Edit the default start phrase to any. Ex: Hi

8. Click on Save button

7.2 Create 1st Step

CLICK ME

1. Click on Step 1 title

2. Enter the text like Welcome to Maximo Assistant

3. Click on Save icon

4. Click on New Step button to create new step.

7.3 Create 2nd Step

CLICK ME

1. Enter the text like Enter your Query :

2. Click on Define customer response link

3. Click on T Free Text Option

4. It looks like this.

7.4 Create 3rd Step with extension

CLICK ME

1. Click on New Step button on the above screen

2. Enter the text like Processing your Query .....

3. Click on Continue to next step link

4. Click on Use an extension Option

5. Choose Maximo-Db-Interface for Extension
6. Choose Post method example for Operation
7. Choose Tr query for Parameters
8. In To field choose Action step variables

9. Choose 2. Enter your query: for To field (This is from the 2nd step)

10. It will look like the below.
11. Click on Apply button

12. It will look like the below.

7.5 Create 4th Step to show results

CLICK ME

1. Click on New Step button on the above screen

2. Enter the text like Here is the response for your Query. .....

3. Click on Fx icon

4. Click on Maximo-Db-interface (step 3) Option

5. Choose body.result.

The Python app returns JSON with a key called result, which WA retrieved from the Open API uploaded in the extension creation section above

6. It will look like the below.

7.6 Preview the WA

CLICK ME

1. Click on Preview button on the above screen

2. Enter the text Hi (Remember that the customer starts with the step where we entered 'Hi'.)

3. It shows 3 options. Choose the action Gan Maximo Assistant that we created

4. Enter your query What is the worktype of workorder 1309?

5. See the response from the app.