Parsons

New Features

- Enable `__len__` dunder method for parsons Table by austinweisgrau in 830
- Add NGPVAN bulk apply suppressions function by codygordon crayolakat and sjwmoveon in 823
- Catch File Extensions in S3 Prefix IanRFerguson in 809
- Add Redash methods by crayolakat in 802
- MoveOn Shopify / AK changes by codygordon in 801

Automated Testing

- Use black formatting in addition to flake8 by austinweisgrau in 796

Bug Fixes

- Remove hardcoded version number from conf.py and correct repo link in setup.py by SorenSpicknail in 811
- Dependency cascade added to Redshift upsert by elyse-weiss in 833 (see also 819 & 832)
- chore(Geocoder)L Add more informative error handling to geocode 729 by talevy42 in 810
- Fix invalid setup.py syntax by crayolakat in 831
- Merge main into major-release by Jason94 in 814
- Fix Salesforce query output by sjwmoveon in 829
- Specify version of slackclient in setup.py by crayolakat in 825
- Pass use_env_token to to_s3_csv by codygordon in 822
- Add Default Parameter Flexibility IanRFerguson 807
- Standardize S3 Prefix Conventions IanRFerguson 803

Documentation

- Delete docs for non-existing arg in MySql by Jason94 in 813

New Contributors

- austinweisgrau made their first contribution by adding Black formatting in 796
- codygordon made their first contribution with updates to Shopify and ActionKit connectors in 801
- IanRFerguson made their first contribution by standardizing S3 Prefix Conventions in 803
- talevy42 made their first contribution by adding more informative error handling to geocode in 810

Welcome and thank you to Austin, Cody, Ian and Tal! 🎉🎉🎉

New Connectors
* feat: scytl connector by agreenspan24 in https://github.com/move-coop/parsons/pull/737
* Donorbox connector by shaunagm in https://github.com/move-coop/parsons/pull/773
New Features
* Add use_env_token option to S3 object by sjwmoveon in https://github.com/move-coop/parsons/pull/745
* Updates to ActionKit, Braintree, and S3 connectors by crayolakat in https://github.com/move-coop/parsons/pull/754
* Add get_aliases() function to Google Admin connector by crayolakat in https://github.com/move-coop/parsons/pull/769
* merge contacts and test by mkwoods927 in https://github.com/move-coop/parsons/pull/776
* Add printed list functionality to VAN connector by sharinef1 in https://github.com/move-coop/parsons/pull/778
* Updates to ActionKit, S3, and NGPVan by crayolakat in https://github.com/move-coop/parsons/pull/775
* Opt out phones in EA use case and sample script by mkwoods927 in https://github.com/move-coop/parsons/pull/670
Automated Testing
* Unit tests for 685 by alxmrs in https://github.com/move-coop/parsons/pull/746
* Update cache keys for CircleCI configuration by SorenSpicknall in https://github.com/move-coop/parsons/pull/752
* Update CircleCI Docs key fingerprint by neverett in https://github.com/move-coop/parsons/pull/785
Bug Fixes
* Fix assert_matching_tables by crayolakat in https://github.com/move-coop/parsons/pull/759
* Scytl fix browser headers and requests lib w mock by agreenspan24 in https://github.com/move-coop/parsons/pull/762
* GitHub Connector Fix by SorenSpicknall in https://github.com/move-coop/parsons/pull/767
* NGPVAN: Saved List Overwrite Bug Fix by jburchard in https://github.com/move-coop/parsons/pull/770
* Upgrade dependencies by crayolakat in https://github.com/move-coop/parsons/pull/779
* Change release version to 1.0 by Jason94 in https://github.com/move-coop/parsons/pull/793
* Fix 780 and 781 - Google Sheets documentation by ethyoo in https://github.com/move-coop/parsons/pull/786
Documentation
* Typo fixes for ETL best practices guide. by alxmrs in https://github.com/move-coop/parsons/pull/747
* Fix 707 - Parsing of code blocks for Mobilize America documentation by ethyoo in https://github.com/move-coop/parsons/pull/749
* Simple docs for the SMTP connector by AndrewRook in https://github.com/move-coop/parsons/pull/735
* Update Code of Conduct contact email by shaunagm in https://github.com/move-coop/parsons/pull/756
* Update requirements.txt for joblib security vulnerability by SorenSpicknall in https://github.com/move-coop/parsons/pull/764
* Add docker image references, logo, scytl connector in sidebar by shaunagm in https://github.com/move-coop/parsons/pull/782

New Contributors
* alxmrs made their first contribution in https://github.com/move-coop/parsons/pull/747
* ethyoo made their first contribution in https://github.com/move-coop/parsons/pull/749
* agreenspan24 made their first contribution in https://github.com/move-coop/parsons/pull/737
* sharinef1 made their first contribution in https://github.com/move-coop/parsons/pull/778

**Full Changelog**: https://github.com/move-coop/parsons/compare/v0.21.0...v1.0.0

New Connectors
* TargetSmart SmartMatch connector by benstroud in https://github.com/move-coop/parsons/pull/674

Enhancements
* More flexible importing in parsons/__init__.py by cmc333333 in https://github.com/move-coop/parsons/pull/702
* Sendmail connector is now an abstract base class by AndrewRook in https://github.com/move-coop/parsons/pull/717
* Convert None to "" in convert_columns_to_str by Jason94 in https://github.com/move-coop/parsons/pull/728
* Add upsert_person method to ActionNetwork by shaunagm in https://github.com/move-coop/parsons/pull/734
* Allow Subfolders for Temp S3 Bucket in Redshift Operations by SorenSpicknall in https://github.com/move-coop/parsons/pull/738
* Always use UTF-8 encoding writing to S3 via the Redshift connector by Jason94 in https://github.com/move-coop/parsons/pull/732

Fixes/Improvements
* Remove leading and trailing whitespace from table and schema name in Redshift utility method table_exists_with_connection() by neverett in https://github.com/move-coop/parsons/pull/715
* Fix Redshift column alteration bug by SorenSpicknall in https://github.com/move-coop/parsons/pull/709
* Fix small bug with postal addresses in Action Network add_person method by shaunagm in https://github.com/move-coop/parsons/pull/716
* Bugfix for Redshift upsert alter_varchar_columns cascade issue by SorenSpicknall in https://github.com/move-coop/parsons/pull/720
* Fixes for Sendmail tests linting by SorenSpicknall in https://github.com/move-coop/parsons/pull/721
* Don't auto-grab AWS session token if it's not passed in by sjwmoveon in https://github.com/move-coop/parsons/pull/740
* Update Mobilize connector by Jason94 in https://github.com/move-coop/parsons/pull/733
* Update psycopg2-binary from 2.8.5 to 2.9.3 by shaunagm in https://github.com/move-coop/parsons/pull/731

Documentation
* Update version number for 0.21.0 release by SorenSpicknall in https://github.com/move-coop/parsons/pull/743

New Contributors
* benstroud made their first contribution in https://github.com/move-coop/parsons/pull/674
* sjwmoveon made their first contribution in https://github.com/move-coop/parsons/pull/740

**Full Changelog**: https://github.com/move-coop/parsons/compare/v0.20.0...v0.21.0

New Connectors
* Auth0 connector by crayolakat in https://github.com/move-coop/parsons/pull/693

Enhancements
* Add phone to NGP VAN apply canvass result by bzupnick in https://github.com/move-coop/parsons/pull/705
* Add tests for SendMail notification connector by AndrewRook in https://github.com/move-coop/parsons/pull/703
* Re-name Phone2Action to Capitol Canary by bzupnick in https://github.com/move-coop/parsons/pull/687
* Update simple-salesforce version by shaunagm in https://github.com/move-coop/parsons/pull/682
* Update auth info for Google Sheets by shaunagm in https://github.com/move-coop/parsons/pull/677
* Update parakimo to latest by bzupnick in https://github.com/move-coop/parsons/pull/688
* Bump pyjwt from 2.0.1 to 2.4.0 by dependabot in https://github.com/move-coop/parsons/pull/692
* Filter expand_fields before stringifying in VAN get_person calls by shaunagm in https://github.com/move-coop/parsons/pull/700


Fixes/Improvements
* Updated Mobilize connector URI, fix display of errors, fix auth issue by shaunagm in https://github.com/move-coop/parsons/pull/708
* Fix error in VAN Target Export method by cmc333333 in https://github.com/move-coop/parsons/pull/704
* Fix Sendmail pep8 Compliance by SorenSpicknall in https://github.com/move-coop/parsons/pull/711
* Update docker image version referenced in testing by SorenSpicknall in https://github.com/move-coop/parsons/pull/712
* Fix BigQuery NoneType Mapping Bug by scmora in https://github.com/move-coop/parsons/pull/695
* Add missing check to distinguish between path string and json string in Google connector utility by shaunagm in https://github.com/move-coop/parsons/pull/701
* Fix issue templates by shaunagm in https://github.com/move-coop/parsons/pull/697
* Small fixes for VAN get_code and apply_code methods by jburchard in https://github.com/move-coop/parsons/pull/696

Documentation
* Update docs to account for wheels by cmc333333 in https://github.com/move-coop/parsons/pull/698
* Add materialization methods to docs by AndrewRook in https://github.com/move-coop/parsons/pull/694
* Add 'Intro to ETL' training guide by shaunagm in https://github.com/move-coop/parsons/pull/680

New Contributors
* AndrewRook made their first contribution in https://github.com/move-coop/parsons/pull/694
* scmora made their first contribution in https://github.com/move-coop/parsons/pull/695

**Full Changelog**: https://github.com/move-coop/parsons/compare/v0.19.0...v0.20.0

New Connectors
* Google Admin connector by crayolakat in https://github.com/move-coop/parsons/pull/644

Enhancements
* Add filtering to Action Network connector by joe-irving in https://github.com/move-coop/parsons/pull/641
* Support for minimal installs / modular dependencies by cmc333333 in https://github.com/move-coop/parsons/pull/632
* VAN: Activist Code Apply - Omit Contact History by jburchard in https://github.com/move-coop/parsons/pull/663
* Support Python 3.9 and 3.10; drop 3.6 by cmc333333 in https://github.com/move-coop/parsons/pull/664

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

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

New Contributors
* Tomiiwa made their first contribution in https://github.com/move-coop/parsons/pull/646
* 0saurabh0 made their first contribution in https://github.com/move-coop/parsons/pull/647
* joe-irving made their first contribution in https://github.com/move-coop/parsons/pull/641
* salice made their first contribution in https://github.com/move-coop/parsons/pull/654

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

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