/fulcrum-python-tools

python tools to interact with the fulcrum API

Primary LanguageJupyter Notebook

Fulcrum Python Tools

Tools for interacting with the fulcrum app API using python. See http://developer.fulcrumapp.com/api/intro/ for more info on the Fulcrum API. Requests takes care of our HTTP chatting, and is automatically installed when using the steps below.

Tools

  • change-record-status.py - Update the status of every record that is older than 12 days. This is ment to be scheduled outside pyhton using crontab.
  • deleteRecords.py - Bulk delete records belonging to a particular changeset.
  • count-drives-record-status.py- The records status is updated based on the records status of a 2nd app. It was intended to show the condition of parks and garden based on the number of complaints recieved.
  • fulcrum-mailer.py- Shows count data of records over a time and according to status. Intented as a informal survey activity summary for management.
  • more-2-come

Setup

  • Run pip install fulcrum to install the fulcrum python library.
  • Copy change-record-status.py into your onto you linux machine and edit your formId, apiToken,newlabel and daysin change-record-status.py to suit you. You may change the field that is being update as well.

Usage

  • Do crontab -e and add the path of the script and the frequency eg minute hour day-of-month month day-of-week /path/to/change-record-status.py