REST API and Websocket for access to IBM iSeries (IBMi) and AS/400 systems

• Access to the IBMi via an expressjs REST API or Websocket
• Run commands by passing in your server host, username and password + the command

• Install Docker and Docker Compose
• Create a directory for your compose file. For example, iseries-api
• Create a docker-compose.yml file:

This example maps the ssl directory in the home directory. Inside this directory are two files fullchain.pem and privkey.pem which are files generated by Let's Encrypt. Change the environment variables to your own Home Assistant details

---
version: '3'

services:
  api:
    image: timmo001/iseries-api
    environment:
      CERTIFICATES_DIR: /ssl
    ports:
      - 28365:28365
    volumes:
      - ~/ssl:/ssl

This example shows how to set up the app without ssl. This is useful for testing, but is unsecure, so don't expose the app to the outside world.

---
version: '3'

services:
  api:
    image: timmo001/iseries-api
    ports:
      - 28365:28365

• Install Docker
• Run image

This example maps the ssl directory in the home directory. Inside this directory are two files fullchain.pem and privkey.pem which are files generated by Let's Encrypt. Change the environment variables to your own Home Assistant details

docker run -d \
  -e CERTIFICATES_DIR='/ssl' \
  -p 28365:28365 \
  -v ~/ssl:/ssl \
  timmo001/iseries-api

This example shows how to set up the app without ssl. This is useful for testing, but is unsecure, so don't expose the app to the outside world.

docker run -d \
  -p 28365:28365 \
  timmo001/iseries-api

• First clone the repository

• Checkout the version you want via releases

• Install packages

  yarn install

• Run

  yarn start

Connect to the same port as you would for the API. Sends stringified JSON as the result.

Run an SQL command and get the result back in JSON:

{
  "request": "sql",
  "hostname": "server_hostname",
  "username": "username",
  "password": "password",
  "command": "SELECT * FROM SOMESCHEMA.SOMETABLE",
  "get_columns": false
}

Note that get_columns requires a set schema. ie. requires SOMESCHEMA.SOMETABLE

• GET / - Test the api is active

• POST /sql - Run an SQL command and get the result back in JSON:

  {
    "hostname": "server_hostname",
    "username": "username",
    "password": "password",
    "command": "SELECT * FROM SOMETHING"
  }

  Supports SELECT UPDATE DELETE and INSERT commands.

• POST /insert - Batch insert data into a table:

  {
    "hostname": "server_hostname",
    "username": "username",
    "password": "password",
    "table": "ZZATTSTF",
    "data": [
      { "VLFD256A": "Test 09" },
      { "VLFD256A": "Test 10" },
      { "VLFD256A": "Test 11" },
      { "VLFD256A": "Test 12" }
    ]
  }

  Be sure that all items are the same in the data array.

• POST /ifs/read - Read a file from the IFS and return its data:

  {
    "hostname": "server_hostname",
    "username": "username",
    "password": "password",
    "path": "/path/to/file.txt"
  }

• POST /ifs/write - Write to a file in the IFS:

  {
    "hostname": "server_hostname",
    "username": "username",
    "password": "password",
    "path": "/path/to/file.txt",
    "data": "test data"
  }

• POST /ifs/delete - Delete a file in the IFS:

  {
    "hostname": "server_hostname",
    "username": "username",
    "password": "password",
    "path": "/path/to/file.txt"
  }

• POST /pgm - Run a program. Set the parameters with params and run with props.

  {
    "hostname": "server_hostname",
    "username": "username",
    "password": "password",
    "program": "MYPROGRAM",
    "params": [
      { "type": "DECIMAL", "precision": 10, "scale": 0, "name": "myId" },
      { "type": "NUMERIC", "precision": 8, "scale": 0, "name": "myDate" },
      { "type": "NUMERIC", "precision": 12, "scale": 2, "name": "myTotalValue" },
      { "type": "CHAR", "precision": 32, "scale": 0, "name": "myString" }
    ],
    "props": {
      "myId": 123,
      "myDate": "20170608",
      "myTotalValue": 88450.57,
      "myString": "This is a test"
    }
  }

• POST /message - Get AS400 messages.

  {
    "hostname": "server_hostname",
    "username": "username",
    "password": "password",
    "path": "/QSYS.LIB/YOURLIB.LIB/YOURMSGF.MSGF",
    "message_id": "AMX0051"
  }