Script: Stream MySQL Query

Script:

Function:

Create a stream to return a multi-row result from a MySQL query

Arguments:

"conn" (string - mysql connection name)
"sql" (string - sql query with ? for placeholders, eg: SELECT * FROM mytable WHERE status=? )
"params" (text - JSON array of parameters in order as required by query, eg: ["foo"] )

Returns:

Try it out

The below is a mock representation of what the action should look like in PWA/GlobiFlow (with our Chrome Extension).

Capture Result of a Remote ProcFu Script

Header(s):	*************************************** you@yourdomain.com
varname =
From URL:	https://procfu.com/exe/stream_mysql_query.pf
POST Params:	conn=[some token]&sql=[some token]¶ms=[some token]

If you do not have our Chrome Extension, the step should look something like this (click on "Headers" to show value).

Capture Result of a Remote POST or GET

Header(s):
Follow Redirects:
varname =
From URL:
POST Params:	conn=[some token]&sql=[some token]¶ms=[some token]

The below is a mock representation of what the action should look like in Zapier.

Action

POST

Choose app & event

Webhooks by Zapier

Action Event

Set up action

URL

Payload Type

Data

Basic Auth

(Click on "Basic Auth" to show value)