Parsons

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 https://github.com/move-coop/parsons/pull/618
* eudaimonius made their first contribution in https://github.com/move-coop/parsons/pull/618
* cmc333333 made their first contribution in https://github.com/move-coop/parsons/pull/627

**Full Changelog**: https://github.com/move-coop/parsons/compare/v0.18.0...v0.18.1

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 https://github.com/move-coop/parsons/pull/567
* elliotlrichardson made their first contribution in https://github.com/move-coop/parsons/pull/562
* kupad made their first contribution in https://github.com/move-coop/parsons/pull/561
* vignesh-ponraj made their first contribution in https://github.com/move-coop/parsons/pull/578
* nilatti made their first contribution in https://github.com/move-coop/parsons/pull/574
* cmdelrio made their first contribution in https://github.com/move-coop/parsons/pull/573
* Jason94 made their first contribution in https://github.com/move-coop/parsons/pull/563
* neverett made their first contribution in https://github.com/move-coop/parsons/pull/607

**Full Changelog**: https://github.com/move-coop/parsons/compare/v0.17.2...v0.18.0

**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)

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)

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)

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)