Enterprise Integration with Azure Logic Apps: Integrate legacy systems with innovative solutions

Enterprise Integration with Azure Logic Apps
Foreword
Contributors
About the author
About the reviewers
Preface
	Who this book is for
	What this book covers
	To get the most out of this book
	Download the color images
	Conventions used
	Get in touch
	Share Your Thoughts
Section 1: Logic App Fundamentals
Chapter 1: Getting Started with Azure Logic Apps
	Introducing the new world
	We know the why, now for the how
	At your service
	It all leads to logic
	Introducing Azure
		Key Azure terms
	Getting started with Azure
		Setting up a Microsoft 365 Business Basic account
		Getting started with Azure
	Obtaining an MSDN account
	The Azure portal
		Resource groups
		The object home page
	Summary
Chapter 2: Environments and Resource Groups
	Technical requirements
	Separating the cloud
	Creating resource groups
		What is a resource group?
		Planning your resource groups
		Exercise – creating a resource group
	Moving resources
		Exercise – creating a copy in another resource group
	Summary
Chapter 3: Referencing Data within Actions
	Technical requirements
	Working with and accessing data
		Getting started with variables
	How to read JSON
		Exercise
		What is parsing?
	Logical versus physical field names
	Summary
Chapter 4: Reading Complex Data
	Technical requirements
	Accessing and parsing a JSON array
		Exercise – Parsing and cycling through an array
	Parsing output from a SQL query output
		SQL queries in action – Working with OData
	Using XPath to parse an XML array
		Using XPath to obtain your values
	Summary
Chapter 5: Manipulating Data
	Complex manipulations
		Language history
		Origins of DAX
	Performing basic mathematical operations
		Add
		Subtract
		Multiply
		Divide
		Remainder (Modulo)
	Combining text
		Referencing in a compose or set variable action
		Using the concat function
	Join actions for arrays
	String manipulation
		Creating a substring
		Counting the length of a string
		Index the position of a character in a string
	Summary
Section 2: Logic App Design
Chapter 6: Working with the Common Data Service
	Technical requirements
	The RESTful API
		Exercise – testing a web service
	Retrieving a record with CDS
		Pros and cons
	Retrieving a record using the Get record action
		Exercise
	Retrieving a series of records using List records and ForEach
		Exercise
	Updating a record and series of records with ForEach
		Exercise – updating a record in an existing environment
	How and when to use logical and physical field naming
	Summary
Chapter 7: Working with Azure Functions
	Technical requirements
	Understanding an Azure function
		Mind your language
		Serverless code
		Benefits of working with an Azure function
		Exercise – how to create an Azure function
	Sending data to an Azure Function from a logic app
	Retrieving data from an Azure Function
	Summary
Chapter 8: Scoping with Try/Catch Error Handling
	Technical requirements
	Creating a series of scope sections
	Manipulating and moving existing actions into a scope
		Exercise – Creating the GetemailCRM1 logic app
	Examining a Try scope's output for debugging data
	Triaging error data to ensure the logic is more robust
		Exercise – Handling scope result messages
	Summary
Chapter 9: Sharing Data with Other Logic Apps and APIs
	Technical requirements
	Using a logic app action to call a child logic app
	Using an HTTP call to trigger a further logic app
	Using a request/response pair to share data between logic apps
		Status codes
	Default tries on an action
	The impact of losing messages
	Trigger IDs
	Run IDs
	Summary
Chapter 10: Monitoring Logic Apps for Management Reporting
	Technical requirements
	Using the Log Analytics workspace
		Exercise – creating your Log Analytics workspace
		Exercise – connecting your subscription to enable Log Analytics
	Using the dashboard
	Walking through the wizard to create your first logic app
		Exercise – creating a random generator to simulate logic app states
	Creating a management report and navigating it to find an error
	Working with Azure PowerShell for bulk operations
		Exercise – enabling/disabling all logic apps in a resource group
	Summary
Section 3: Logic App Maintenance and Management
Chapter 11: Fine-Tuning Logic App Runs with Run After
	Technical requirements
	Logic app branches
	Using pass/fail branches and run after
	List records versus Get record
	Composing data in stages versus using expressions
	Summary
Chapter 12: Solving Connection Issues and Bad Gateways by Rerunning Logic Apps
	Technical requirements
	Creating and using SQL databases
		Exercise 1 – creating an Azure database
		Creating our first table – possible with Query Editor?
		Exercise 2 – creating the table using Visual Studio
	Connecting to a SQL database using an Azure connection profile
	Understanding SQL connection timeouts/bad gateway messages
		Connection wait timeout errors
		Bad gateways
	SQL connection web gateways
	File server connection gateways
	Summary
	Why subscribe?
Other Books You May Enjoy
	Packt is searching for authors like you
	Share Your Thoughts