Script: Stream MySQL Query
Script:
- stream_mysql_query.pf
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:
- ID of the stream to use with stream_fetch
Try it out
GF Preview
The below is a mock representation of what the action should look like in 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]
|