Script: InfoLobby Table Query
Script:
- infolobby_table_query.pf
Function:
Query an InfoLobby Table with filter and sort
Arguments:
- "table_id" (integer - ID of table)
- "filters" (string - JSON filter conditions array as per API, eg: [{"field":"status","compare":"C","value":"foo"}])
- "fields" (string - JSON array of fields to return, eg: ["title","status"])
- "sort" (string - field ID to sort by, eg "title")
- "sort_dir" (string - sort direction, either "asc" or "desc")
- "limit" (integer - number of rows to return)
- "offset" (integer - offset to start from)
Returns:
- JSON object with array of table data
Try it out
Workflow Preview
Podio Workflow Automation
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/infolobby_table_query.pf
|
POST Params: |
table_id=[some token]&filters=[some token]&fields=[some token]&sort=[some token]&sort_dir=[some token]&limit=[some token]&offset=[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: |
table_id=[some token]&filters=[some token]&fields=[some token]&sort=[some token]&sort_dir=[some token]&limit=[some token]&offset=[some token]
|
Zapier
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
some token |
|
some token |
|
some token |
|
some token |
|
some token |
|
some token |
|
some token |
Basic Auth
(Click on "Basic Auth" to show value)
Foo Bar Baz
Sit velit repellat incidunt. Ut voluptatem voluptatibus autem assumenda sed. Incidunt magnam ratione illum. Ut tempore minima mollitia excepturi voluptatem modi maxime.