You're reading from Enterprise Integration with Azure Logic Apps Integrate legacy systems with innovative solutions

Product type Paperback

Published in Dec 2021

Last Updated in Feb 2025

Publisher Packt

ISBN-13 9781801074728

Length 294 pages

Edition 1st Edition

Tools

Azure

Concepts

Cloud Computing

Author (1):

Matthew Bennett

View More author details

Table of Contents (17) Chapters

Preface

1. Section 1: Logic App Fundamentals

2. Chapter 1: Getting Started with Azure Logic Apps FREE CHAPTER

3. Chapter 2: Environments and Resource Groups

4. Chapter 3: Referencing Data within Actions

5. Chapter 4: Reading Complex Data

6. Chapter 5: Manipulating Data

7. Section 2: Logic App Design

8. Chapter 6: Working with the Common Data Service

9. Chapter 7: Working with Azure Functions

10. Chapter 8: Scoping with Try/Catch Error Handling

11. Chapter 9: Sharing Data with Other Logic Apps and APIs

12. Chapter 10: Monitoring Logic Apps for Management Reporting

13. Section 3: Logic App Maintenance and Management

14. Chapter 11: Fine-Tuning Logic App Runs with Run After

15. Chapter 12: Solving Connection Issues and Bad Gateways by Rerunning Logic Apps

16. Other Books You May Enjoy

Parsing output from a SQL query output

If you do not already have a static dataset or are concerned that the data may update regularly and so you will not be able to use an array, you can use a SQL query to query the current state of the data in your old system and use the result as your dataset.

We are now going to uncover a new programming language used when querying data. Also, again think over how we send messages from system to system using a REST API.

SQL queries in action – Working with OData

OData, or the Open Data Protocol, is a commonly accepted, globally used standard language that is used to build RESTful APIs without having to worry about the technical details of setting up the API. OData lets the user worry about what they want, not how to send the message. For this reason, it is commonly used on queries, but is also found in the creation and use of functions where procedures are reusable (as is the case here in this logic app).

OData is approved by...