v0.19.0 - New Guides and Sample Scripts, New Google Admin Connector, Support for Minimal Install, and More!

New Connectors

• Google Admin connector by @crayolakat in #644

Enhancements

• Add filtering to Action Network connector by @joe-irving in #641
• Support for minimal installs / modular dependencies by @cmc333333 in #632
• VAN: Activist Code Apply - Omit Contact History by @jburchard in #663
• Support Python 3.9 and 3.10; drop 3.6 by @cmc333333 in #664

Fixes / Improvements

• Update init shortcuts by @shaunagm in #634
• Remove built docs from git repo by @shaunagm in #656
• Update README license to match docs by @cmc333333 in #658
• Fix bug in 'make html' by @shaunagm in #660
• Bump paramiko from 2.7.2 to 2.10.1 by @dependabot in #652
• Updates to PDI Wrapper by @salice in #654
• Updated for Google Dependencies by @SorenSpicknall in #667
• Remove VAN method workaround that stripped query parameters from URL by @shaunagm in #675
• Only unpack dicts in P2A campaigns response if the response has data by @SorenSpicknall in #649
• Create bug and addition issue templates by @SorenSpicknall in #668

Documentation

• 'Getting Started With Parsons' training guide by @shaunagm in #631
• Use case and sample scripts by @mkwoods927 in #630
• Miscellaneous connector docs updates by @shaunagm in #638
• Pandas DF vs Parsons table docs by @Tomiiwa in #646
• Fixed issues with Parsons table documentation by @0saurabh0 in #647
• Multiversion support for docs website display by @shaunagm in #639
• VAN connector docs by @Tomiiwa in #650
• Run docs build on any change to main branch by @shaunagm in #657
• Action Network Docs Update by @Tomiiwa in #655
• Update main branch references in README by @SorenSpicknall in #666
• Added Table of Contents to README by @Tomiiwa in #678

New Contributors

• @Tomiiwa made their first contribution in #646
• @0saurabh0 made their first contribution in #647
• @joe-irving made their first contribution in #641
• @salice made their first contribution in #654

Full Changelog: v0.18.1...v0.19.0

v0.18.1 - New ActBlue Connector, Docs Additions, and Small Fixes

New Connectors

• New ActBlue Connector (h/t @torimarbois and @Eudaimonius)

Fixes / Improvements

• ActBlue and ControlShift docs sidebar reference fix (h/t @shaunagm)
• ControlShift init reference fix (h/t @ChrisC )
• Removal of an unnecessary file accidentally included in a previous PR (h/t @cmc333333)

Documentation

• Guidance for sample scripts and use cases published (h/t @shaunagm)
• Instructions written for dev sandboxes (h/t @neverett and @shaunagm)

New Contributors

• @torimarbois made their first contribution in #618
• @Eudaimonius made their first contribution in #618
• @cmc333333 made their first contribution in #627

Full Changelog: v0.18.0...v0.18.1

v0.18 - License Update, New Connectors, and lots of Improvements

New Connectors

• New Bluelink Connector (h/t @kupad)
• New Quickbase Connector (h/t @SorenSpicknall)
• New ControlShift Connector (h/t @ChrisC)

Enhancements

• ActionKit & Shopify Connector updates (h/t @crayolakat)
• ActionNetwork Connector updates (h/t @cmdelrio)
• VAN Connector updates (h/t @jburchard)
• Redshift & S3 improvements (h/t @Jason94 @dannyboy15 @neverett @SorenSpicknall)
• Database boolean parsing (h/t @dannyboy15)

Fixes / Improvements

• Zoom Webinar Registrant Endpoint Fix by @ydamit

Documentation

• Added Shopify and ActionKit documentation (h/t @crayolakat)
• Misc fixes and clarifications (h/t @mkwoods927 @LaurieJ @vignesh-ponraj @shepardjma @SorenSpicknall )

New Contributors

• @LaurieJ made their first contribution in #567
• @elliotlrichardson made their first contribution in #562
• @kupad made their first contribution in #561
• @vignesh-ponraj made their first contribution in #578
• @nilatti made their first contribution in #574
• @cmdelrio made their first contribution in #573
• @Jason94 made their first contribution in #563
• @neverett made their first contribution in #607

Full Changelog: v0.17.2...v0.18.0

v0.17.2 - Lots of Security and Connector Bugfixes

Enhancements:

• Adds get_survey_question() and update_survey_question() to ActionKit (h/t @crayolakat)
• Adds Google Cloud Storage as an option for the Cloud Storage Utility & VAN (h/t @jburchard)
• Updates statupdate and compupdate copy options for Redshift (h/t @dannyboy15)

Fixes / Improvements:

• Cleans up leaky logs (h/t @ydamit)
• Fixes for GET request params & Tag ID's in Hustle (h/t @ChrisC)
• Uses Python floats as a Redshift default (h/t @ydamit)
• Adds typecast param to insert_record() for Airtable (h/t @thebbennett)
• Fixes van connector for NGPVAN API update (h/t @bxjw & @bella)
• Updates urllib3 security vulnerability (h/t @ChrisC)

Documentation:

• Adds updated NGPVAN API documentation URLs to repo docs (h/t @djs-djs)

v0.17.1 - A Fix for Database Imports + New petl Method

Enhancements:

• Added a new use_petl() method to the Parsons table to more cleanly expose underlying petl functionality (h/t @dannyboy15)

Fixes / Improvements:

• Fixed a bug causing failed local imports of Parsons' generic database methods on some systems (h/t @SorenSpicknall)

Documentation:

• Added documentation for the new use_petl() method (h/t @dannyboy15)

v0.17.0 - New Methods Galore + Future-Proofing TargetSmart Class

Enhancements:

• Added get_event() method and get_events() methods to ActionKit class (h/t @dannyboy15)
• Added download_file() method to the Box class (h/t @dannyboy15)
• Added ActionKit mailer methods (h/t @crayolakat)
• Added RockTheVote.get_state_requirements() method (h/t @sarah-russell12)
• Added optional folder_id to create_spreadsheet() method to the Sheets connector in the Google class (h/t @mkwoods927)
• Added ability to drop dependent objects when altering a table using the Redshift class copy() method (h/t @dannyboy15)
• Improved performance of DBSync class and improved logging. Additionally, add the ability to set retries and source/destination chunk sizes. (h/t @eliotst)
• Added ordering to Bloomerang class (h/t @dannyboy15)
• Add STFP.get_files() method that allows users to retrieve files using regex. (h/t @tiburona)
• Add Shopify class (h/t @crayolakat)

Fixes / Improvements:

• Change SurveyGizmo class to Alchemer to reflect new product name (h/t @jburchard)
• Modify CivisClient class to return futures and allow kwargs to be passed through (h/t @eliotst)
• Updated URL used for SFTP connections in the TargetSmart class (h/t @ChrisC)
• Updated versions of dependencies for Jinja, Httplib, Gspread, petl (h/t @SorenSpicknall)
• Updated Table.from_json() method to leverage petl.fromjson() method (h/t @dannyboy15)
• Bug fixes for MySQL class methods (h/t @ydamit)
• Bug fix for Hustle class get_leads() method (h/t @elyse-weiss)
• Bug fix for Redshift class rs_create_table() method (h/t @SorenSpicknall)
• Fix JWT tokens in Zoom class (h/t @ydamit)
• New create DatabaseCreateStatement to standardize the creation of the database tables (h/t @dannyboy15)
• Various test fixes (h/t @eliotst)

Documentation:

• Add How To documentation on writing unit tests. (h/t @eliotst)

v0.16.0 - Box, SurveyGizmo, and sample scripts

Feature additions:

• New SurveyGizmo Connector - Download surveys and survey responses as Parsons Table from the SurveyGizmo API (h/t @coreyhaines)
• New Box Connector - Upload, download, and manage files in the Box app (h/t @davidpablocohn)
• Periscope/Sisense for Cloud Data Teams Connector - Publish and manage shared dashboards through the Sisense for Cloud Data Teams API (h/t @rgriff23)

Enhancements:

• Add the ability to create and update advocates in Phone2Action Connector (h/t @eliotst)
• Support bulk applying activist codes in the VAN Connector (h/t @jburchard)
• Add a warning to the Redshift Connector encourage best practices around setting a distkeys and sortkeys when creating a table (h/t @tiburona)
• Add a method to just list names of columns in Redshift (h/t @elyse-weiss)
• Allow using manifest files when creating a Parsons Table from data in S3 (h/t @dannyboy15)
• Add support for extended reports with the Rock the Vote Connector (h/t @natashamathur, @dannyboy15)
• Improve ActionKit Connector’s bulk_upload_table method (h/t @schuyler1d)
• Allow users to opt out of altering columns of a Redshift table on upsert (h/t @eliotst)

Fixes:

• Fix to generate_data_types for the Postgres connector (h/t @dannyboy15)
• Improve ActionKit Connector’s connection management (h/t @eliotst)
• Allow specifying S3 region when running a copy from a different region than the Redshift database (h/t @eliotst)
• Fix a bug in the statement generated when specifying a delimiter when unloading data out of Redshift (h/t @jburchard)
• Handle default arguments better when adding a person to ActionNetwork (h/t @rgriff23)
• Fix the update_lead method on the Hustle Connector (h/t @elyse-weiss)
• Fix a the Gmail Connector’s unit tests that were failing on Windows (h/t @sarah-russell12)

Scripts:

• Added a script to load Zoom data into VAN (h/t @shaunagm)
• Added a script to randomly sample people from a VAN saved list (h/t @pjsier)

Documentation:

• Update our Connector docs to include an Overview, Authentication information, and a Quickstart (h/t @rgriff23, @jburchard, @davidpablocohn)

v0.15.0 - New GitHub Connector and Lots of Documentation

Feature additions:

• New GitHub Connector - Download files, get information (h/t @pjsier)
• New Azure Blob Storage Connector - List, upload, and download blobs in Azure (h/t @pjsier)

Enhancements:

• Added the format_cells method to the GoogleSheets Connector for formatting the cells of a worksheet (h/t @jburchard)
• Support threads in the Slack Connector (h/t @elyse-weiss)
• Add events and signups to the ActionKit Connector (h/t @rgriff23)
• Added the map_and_coalesce_column function for normalizing your Tables when columns might be named different things (h/t @elyse-weiss)
• Support sending Slack messages using a webhook (h/t @schuyler1d)
• Create a standard template for sample scripts and update our existing scripts to be consistent (h/t @shaunagm)

Fixes:

• Fixes to the VAN Targets endpoints (h/t @shduttacheezit)
• Properly pass through S3 credentials when copying data into Redshift (h/t @jburchard)
• Lower the logging level to DEBUG for some messages (h/t @jburchard)
• Handle differences in data model for person data returned from MyVoters in the VAN Connector (h/t @jburchard)
• Better handling of duplicate column names in the Redshift and Postgres Connectors (h/t @jburchard)
• Allow specifying the delimiter in the Redshift Connector’s unload method (h/t @dannyboy15)

Documentation:

• Added the “How to Build a Connector” page to our documentation (h/t @shaungm, @eliotst)
• Multiple fixes to our “Useful Resources” and “Contributing” documentation (h/t @pjsier, @ehrenfoss, @shaunagm, @ibrand)
• Multiple updates to our Connector documentation, as we look to standardize documentation across all classes (h/t @rgriff23, @jburchard, @elyse-weiss)
• Update the “Quick Start” in the README.md so it doesn’t require credentials to run (h/t @eliotst)

v0.14.2 - Python 3.8 support

This release includes fixes to support installation and running of Parsons using Python 3.8.

v0.14.1 - Upgrade psycopg2 version

This release upgrades the version of the psycopg2-binary dependency to improve Parsons compatibility with Python 3.8.