Chapter 4: Reading Complex Data
Working with basic variables is a good start, but the power of a logic app comes with its ability to read, parameterize, and work with different types of data formats at the same time. You may also need to pass several hundred messages at the same time through your logic app.
Take, for example, the use of a logic app to transfer contacts from one system to another. You may need to work in bulk and process several hundred at a time. This chapter looks at how you can easily add this degree of power to your logic app.
In this chapter, we're going to cover the following topics:
- Accessing and parsing a JSON array
- Parsing output from a SQL query output
- Using XPath to parse an XML array
By the end of this chapter, you will be able to do the following:
- Read a JSON message and manipulate it.
- Extract data from specific fields within a SQL output, or a JSON message.
- Use XPath to extract data from an XML message...
