Web scraping a website can seem like a daunting task. However, the usage of Alteryx can help smoothen the process. The challenge DSNY1 was given was to take data from https://data.police.uk/docs/method/crime-street/ and meet the requirements that were listed here https://www.thedataschool.co.uk/andy-kriebel/ds32-ny1-day-1 . The first part was understanding the API and parsing it out for a useful format. Crosstab is needed to make it useful for me. Looking at the API you will understand what part can be changed to customize it. One of the requirements was to be able to type in a postal code. The original data does not have a postal code but does have longitude and latitude. I used another API from postalcodes.io to generate the longitude and latitude associated with the postal code. After that, I used that to replace the value in the URL from https://data.police.uk/docs/method/crime-street/. Additionally, I have a text input for the date. Further down the workflow, I have it do a filter action by the text input. It was a fun challenge and interesting to learn all that in one day. We are so prime to learn on the spot and pick up new skills and techniques.