Managing APIs’ XML responses

XML uses tags to define elements within a document, similar to HTML. However, unlike HTML, XML allows for the creation of custom tags, which means that it can be used to represent a wide variety of data types.

For users who are not technologically advanced, dealing with API responses in XML can be frustrating.

Understanding the tree structure within an XML file and identifying its components requires some additional knowledge, something that not everyone is willing to acquire.

In this recipe, we are going to provide you with a way to eliminate that frustration and obtain optimal performance by parsing the responses of an API in XML.

Getting ready

We created a test set that you can download from here: https://github.com/PacktPublishing/Alteryx-Designer-Cookbook. In this example, we’ll be connecting to a public API that provides data about clinical trials. The API is free and does not require us to register, but it does require...