MySQL Fetch

This activity provides your flogo application the ability to fire a select query to mySQL database and fetch the required data returning it as a JSON string.

Installation

Flogo Web

Use the below link for to install this activity in Flogo Web

https://github.com/Ganitagya/flogo-contrib/activity/mysqlfetch

Flogo CLI

flogo add activity github.com/Ganitagya/flogo-contrib/activity/mysqlfetch

Schema

Inputs and Outputs:

"input":[
   {
      "name": "host",
      "type": "string",
      "required": true
    },
    {
      "name": "username",
      "type": "string",
      "required": true
    },
    {
      "name": "password",
      "type": "string",
      "required": true
    },
    {
      "name": "database",
      "type": "string",
      "required": true
    },
    {
      "name": "query",
      "type": "string",
      "required": true
    }
  ],
  "output": [
    {
      "name": "result",
      "type": "any"
    }
  ]

Settings