Parsons

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)

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)