Script: Notion Table Query
Script:
- notion_table_query.pf
Function:
Query a Notion database with filter and sort
Arguments:
- "block_id" (string - URL of page or data-block-id of table)
- "filter" (string - JSON filter conditions as per API, eg: {"property":"Status","select":{"equals":"Closed"}})
- "sort" (string - JSON sort order as per API, eg: [{"timestamp":"last_edited_time","direction":"descending"}])
- "limit" (integer - number of rows to return)
- "cursor" (string - start cursor (optional - returned from previous call))
Returns:
- JSON object with array of table data in format: {"count":COUNT_OF_ITEMS,"cursor":NEXT_PAGE_ID,"results"[{BLOCK_ID:{COLUMN:VALUE,...}]}
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/notion_table_query.pf
|
POST Params: |
block_id=[some token]&filter=[some token]&sort=[some token]&limit=[some token]&cursor=[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: |
block_id=[some token]&filter=[some token]&sort=[some token]&limit=[some token]&cursor=[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 |
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.