Python and RESTful API

There was a requirement to add customers to an existing Square POS instance and minimize the duplication of data.

This script utilizes the Square Python package to check customers in an Excel spreadsheet supplied by the ticketing department. It will search Square by e-mail address and if it is found, then the applicable fields are updated. If no match is found then the spreadsheet is updated indicating that the record will be manually uploaded. As Square has the potential to throttle creating new customer records it was decided to not automate the creation of new customers through their API.

This script was created using Python 3.11 and Jupyter Notebooks in VS Code.