Parsons

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)

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

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

Feature additions:

* New PDI Connector - Get flags, questions, acquisition types, and more from the PDI API (h/t dannyboy15)

Enhancements:

* Add the VAN.get_target_export method for pulling down people for a target (h/t sduttacheezit)
* Add the SFTP.get_table method to pull down a CSV file from an SFTP server as a Parsons table (h/t jburchard)
* Add the Table.materialize_to_file method to apply pending transformations to a Table without having to load all of the data into memory (h/t eliotst)
* Refactor the GoogleSheets class to accept either the worksheet ID or name when operating on worksheets in a Google Sheet (h/t jburchard)
* Add a flag to the Redshift.upsert method to adjust column sizes on the target table if the data is too big (h/t SorenSpicknall)

Fixes:

* Fix the Phone2Action connector to be consistent with the data returned by the API (h/t eliotst)
* Documentation fixes (h/t joemcl)

Bump to version of `httplib2` from v0.12.0 to v0.18.0 to resolve a security flaw. For more information, see: https://github.com/httplib2/httplib2/blob/9bf300cdc372938f4237150d5b9b615879eb51a1/CHANGELOG#L7-L12

Bug fix:

* Add a missing Python package `__init__.py` file for the `parsons.action_network` package