š§© Use Index + Direct Access to pull data across loops in Data Mapper
When working with repeating structures in Logic Apps Data Mapper, you may run into situations where two sibling loops exist under the same parent. What if you need to access data from one loop while youāre inside the other? This is where the Direct Access function, used in combination with Index, can save the day. š§Ŗ Scenario In this pattern, weāre focusing on the schema nodes shown below: šø Source & Destination Schemas (with loops highlighted) In the source schema: Under the parent node VehicleTrips, we have two sibling arrays: Vehicle ā contains VehicleRegistration Trips ā contains trip-specific values like VehicleID, Distance, and Duration In the destination schema: We're mapping into the repeating node Looping/Trips/Trip It expects each tripās data along with a flattened VehicleRegistration value that combines both: The current tripās VehicleID The corresponding vehicleās VehicleRegistration The challenge? These two pieces of data live in two separate sibling arrays. š§° Try it yourself š Download the sample files from GitHub Place them into the following folders in your Logic Apps Standard project: Artifacts ā Source, destination and dependency schemas (.xsd) Map Definitions ā .lml map file Maps ā The .xslt file generated when you save the map Then right-click the .lml file and select āOpen with Data Mapperā in VS Code. š ļø Step-by-step Breakdown ā Step 1: Set up the loop over Trips Start by mapping the repeating Trips array from the source to the destination's Trip node. Within the loop, we map: Distance Duration These are passed through To String functions before mapping, as the destination schema expects them as string values. As you map the child nodes, you will notice a loop automatically added on parent nodes (Trips->Trip) šø Mapping Distance and Duration nodes (context: weāre inside Trips loop) š Step 2: Use Index and Direct Access to bring in sibling loop values Now we want to map the VehicleRegistration node at the destination by combining two values: VehicleID (from the current trip) VehicleRegistration (from the corresponding vehicle) ā”ļø Note: Before we add the Index function, delete the auto-generated loop from Trips to Trip To fetch the matching VehicleRegistration: Use the Index function to capture the current position within the Trips loop šø Index setup for loop tracking Use the Direct Access function to retrieve VehicleRegistration from the Vehicle array. š Direct Access input breakdown The Direct Access function takes three inputs: Index ā from the Index function, tells which item to access Scope ā set to Vehicle, the array you're pulling from Target Node ā VehicleRegistration, the value you want This setup means: āFrom the Vehicle array, get the VehicleRegistration at the same index as the current trip.ā šø Direct Access setup š§ Step 3: Concatenate and map the result Use the Concat function to combine: VehicleID (from Trips) VehicleRegistration (from Vehicle, via Direct Access) Map the result to VehicleRegistration in the destination. šø Concat result to VehicleRegistration ā”ļø Note: Before testing, delete the auto-generated loop from Vehicle to Trip šø Final map connections view ā Step 4: Test the output Once your map is saved, open the Test panel and paste a sample payload. You should see each Trip in the output contain: The original Distance and Duration values (as strings) A VehicleRegistration field combining the correct VehicleID and VehicleRegistration from the sibling array šø Sample Trip showing the combined nodes š¬ Feedback or ideas? Have feedback or want to share a mapping challenge? Open an issue on GitHubTransform Your Integration Strategy with Azure Integration Services
Still on Microsoft BizTalk Server or other legacy integration solutions? If you're relying on BizTalk or other legacy systems, you're already feeling the pain: rising costs, performance bottlenecks, and limited scalability. These outdated systems are holding you back, but the good news? The time to modernize is NOW and weāve got the event that will show you how. Join us at "Unleash AI Innovation with a Modern Integration Platform and an API-First Strategy", where industry leaders like Visa, LyondellBasell, and Metcash share how they reimagined their integration landscape with Azure. This is your blueprint for moving beyond the limitations of legacy systems and unlocking innovation with a cloud-native, AI-ready approach. By attending, youāll gain exclusive insights into how leading organizations have turned integration challenges into competitive advantages, positioning themselves for future growth with Azure. Real Stories, Real Impact Visa: Revolutionizing Operations with Azure Logic Apps Visaās journey from BizTalk to Azure Logic Apps isnāt just a story of modernizationāitās a game-changer. By automating complex workflows and managing over 100 HR systems, Visa reduced manual intervention and slashed infrastructure costs by 95%. With Azure, Visa is now set to scale operations and leverage AI for continued growth. Discover the details of how Visa is preparing for tomorrowās challenges today. LyondellBasell: Scaling Beyond BizTalk LyondellBasell, a global leader in chemicals, broke free from BizTalkās limitations. Azure Integration Services empowered them with hybrid connectivity and real-time visibility, enabling them to streamline workflows and boost developer efficiency by 50%. Learn how they unlocked faster decision-making and stronger business outcomes. Brisbane City Council: From Legacy to API-First Agility Brisbane City Council, Australiaās largest local government, faced limitations with legacy integration solution. With Azure, they cut data processing times from 1 hour to under 5 minutes. The shift to an API-first approach future-proofed their strategy. Find out how this local government innovated without disruption. Metcash: Peak Retail Performance, Zero Downtime After moving to Azure Integration Services, Metcash, an Australian wholesaler, processed 8.65 million API calls in 48 hours during a major retail event without a single minute of downtime. With Azure, they achieved unrivaled resilience and scalability, all while slashing costs. See how Metcashās transformation can serve as your blueprint for success. What Youāll Learn: How to cut costs and modernize your integration landscape Ways to scale with cloud-native solutions and AI-driven automation Strategies to secure every API with enterprise-grade governance Real-world migration paths from BizTalk and other platforms Choose Your Region and Register Now US/Canada: Reserve your seat today! Day 1: Tuesday, 29 April 2025 | 9:00 AM ā 12:30 PM PDT Day 2: Wednesday, 30 April 2025 | 9:00 AM ā 12:30 PM PDT Australia/New Zealand: Reserve Your Seat Today! Day 1: Wednesday, 30 April 2025 | 9:00 AM ā 12:30 PM AEDT Day 2: Thursday, 1 May 2025 | 9:00 AM ā 12:30 PM AEDT Europe: Reserve Your Seat Today! Day 1: Tuesday, 29 April 2025 | 9:00am ā 12:30pm BST Day 2: Wednesday, 30 April 2025 | 9:00am ā 12:30pm BSTFive reasons to join us on April 29āMay 1 at our upcoming event on APIs and Integration
AI is reshaping the way businesses operate from streamlining processes through intelligent automation to enabling real-time, data-driven decisions. But to fully unlock its potential, you need a strong, connected foundation; one that brings together your data, applications, and AI services across environments. Thatās exactly what youāll explore at our upcoming two-day virtual event Unleash AI Innovation with a Modern Integration Platform and an API-First Strategy. š April 29ā30 (Americas/Europe) | April 30āMay 1 (ANZ) š„ļø Free, virtual, and streamed live across multiple time zones Whether you're modernizing from BizTalk, building an intelligent automation strategy, or scaling and securing AI-powered APIs, this event will equip you with practical insights, expert guidance, and real customer strategies to help you move forward with confidence. Here are the top five reasons to attend: 1. Be inspired by enterprise success stories Learn how organizations like Visa, Transcard, Heineken, Moneris, DocuSign, LyondellBasell, Metcash, Brisbane City Council, and CareFirst BlueCross BlueShield are using Azure Integration Services and Azure API Management to build scalable, future-ready strategies. 2. Hear from top industry analysts Get strategic insight from IDCās Shari Lava and Forresterās Andrew Nadler alongside Microsoft product leaders on where integration and APIs are headed and how to prepare your business for whatās next. 3. Modernize your integration platform Still using BizTalk or another legacy system? Discover how others are migrating to Azure, simplifying operations, reducing technical debt, and unlocking new agility for AI-powered transformation. 4. Embed AI into your workflows See how Azure Logic Apps help you bring AI into your business processes using Azure OpenAI, Document Intelligence, and Azure AI Search. Youāll walk away with real use cases you can apply immediately. 5. Scale and secure your AI-powered APIs Your APIs are the front door for AI. Learn how Azure API Management helps you manage and secure them supporting zero-trust security and fast, consistent developer experiences. Join us to shape whatās next! This is your opportunity to learn from peers, partners, and experts who are redefining what's possible with integration, APIs, and AI. Whether you're an architect, developer, IT pro, or business technologistāthereās something here for you. US/Canada: Reserve your seat today! Day 1: Tuesday, 29 April 2025 | 9:00 AM ā 12:30 PM PDT Day 2: Wednesday, 30 April 2025 | 9:00 AM ā 12:30 PM PDT Australia/New Zealand: Reserve Your Seat Today! Day 1: Wednesday, 30 April 2025 | 9:00 AM ā 12:30 PM AEDT Day 2: Thursday, 1 May 2025 | 9:00 AM ā 12:30 PM AEDT Europe: Reserve Your Seat Today! Day 1: Tuesday, 29 April 2025 | 9:00am ā 12:30pm BST Day 2: Wednesday, 30 April 2025 | 9:00am ā 12:30pm BSTQ1ā2025: Azure Integration Services Quarterly Highlights and Insights
From reinventing hybrid integration to unlocking AI-powered productivity and simplifying API management across ecosystems, the first quarter of 2025 was all about making integration smarter, faster, and more accessible for everyone. Whether you're a developer modernizing legacy workflows, an IT pro securing mission-critical APIs, or a business technologist building intelligent automations, Azure Integration Services and Azure API Management are moving at the speed of innovation. Hereās what stood out this quarter and how these updates can help accelerate your next move. Product Announcements Weāve been hard at work delivering powerful new capabilities across Azure Logic Apps and Azure API Management designed to help you move faster, modernize smarter, and innovate with confidence. Hereās whatās new: Azure Logic Apps Hybrid Deployment Model [Public Preview Refresh] The public preview of the Logic Apps hybrid deployment model has been refreshed, allowing you to run Logic Apps on your own infrastructure, whether thatās on-premises, at the edge, or across multi-cloud environments. New highlights include: .NET Framework custom code support on Linux containers ā Bring over BizTalk-style transformations without a rewrite. SAP built-in connector now supported on Linux containers ā Run SAP workflows anywhere you deploy Hybrid Logic Apps. New Rabbit MQ built-in connector ā Seamlessly connect to on-premises message brokers for hybrid queueing scenarios. Read the full update. Data Mapper in Azure Logic Apps (Standard) [Public Preview Refresh] The updated Data Mapper in Logic Apps (Standard) is now even more powerful, bringing forward critical BizTalk-era capabilities with a modern UX: Run enterprise-grade XSLT logic from reusable templates Extract values from complex XML using XPath Build and reuse custom XML functions within your maps Dive into the details. Azure API Center Continues to Evolve Azure API Center continues to evolve as the single source of truth for your organizationās APIs. Two key updates now in public preview: Managed API Center Portal ā A turnkey developer portal to explore, customize, and govern APIs with Microsoft Entra integration. Set up instructions for the API Center portal. ļøAmazon API Gateway integration ā Automatically import and keep APIs in sync from AWS into API Center. No manual updates. No drift. Learn about the integration. Developer tooling: A better Azure API Management experience in VS Code Weāve released a new version of the Azure API Management VS Code extension, focused on making it easier to draft, debug, and explain API policies fueled by GitHub Copilot and AI enhancements. Itās all about helping developers move faster and smarter. Learn more. Your AI and modernization playbooks for Logic Apps Bring AI into your workflows with the Logic Apps AI Playbook Ready to infuse intelligence into your apps, bots, or business processes? Our AI Playbook for Azure Logic Apps gives you a practical guide to building smarter workflows fast. Whether you're starting from scratch or scaling existing automations, youāll find step-by-step examples to accelerate your journey: Build conversational apps using Azure OpenAI and Azure AI Search Automate document intelligence with built-in connectors to Azure AI Document Intelligence Power real-time retrieval with RAG (Retrieval-Augmented Generation) patterns Create intelligent agents using Semantic Kernel and Logic Apps orchestration Explore AI scenarios and examples. Still running mainframe workloads? We've got a playbook for that too. Modernizing mission-critical systems doesnāt have to mean starting over. With our Mainframe and Midrange Modernization Playbook, Logic Apps helps you replatform legacy workloads with less risk and more flexibility. Discover how to connect to existing systems, orchestrate modern services, and unlock agility without rewriting everything. Explore the mainframe modernization guide. Partnership Announcements Azure API Management comes with a powerful, fully integrated developer portal built to help teams publish APIs, onboard developers, and manage access with enterprise-grade scalability and security. For many organizations, this out-of-the-box portal offers exactly what they need. But some businesses need more advanced branding, tailored onboarding journeys, or completely bespoke developer experience. Thatās why weāre partnering with Pronovix and ApiBoost, two industry leaders in custom API portals. These partnerships give customers even more flexibility to extend and personalize their API programs. Customer Success Stories TelefĆ“nica Brasil is transforming call center operations for 115M+ users using Azure OpenAI and Azure API Management. With AI-driven insights and secure API access for 33,000 employees, theyāve cut average handling time by 9% and accelerated innovation. Read the story. Intermountain Health has saved thousands of hours by integrating Azure API Management, OpenAI, and Arize AI into their cloud AI infrastructure. Responsible AI deployment meets real-time observability for better patient outcomes. Learn more. Delta Dental of California unified its integration architecture across APIs, messaging, and app delivery using Azure API Management, App Gateway, Redis, and moreāstreamlining operations and unlocking agility. Explore the case study. NTT Communications uses Azure Logic Apps to automate threat response as part of its Microsoft Sentinel-powered security stack, enabling faster correlation of security signals across systems. Read the story. Whatās coming up: Events you wonāt want to miss Unleash AI Innovation with a Modern Integration Platform and an API-First Strategy Join us for a dynamic two-day virtual event April 29-30 where weāll explore how Azure Integration Services and Azure API Management are powering intelligent, connected experiences. Hear directly from Azure product leaders, industry analysts, and enterprise customers as they share how theyāre using Azure to scale AI-driven innovation, modernize integrations, and build API-first strategies that unlock new business value. This global event is designed to fit your schedule, with live sessions tailored for key regions: US/Canada: Reserve your seat today! Day 1: Tuesday, 29 April 2025 | 9:00 AM ā 12:30 PM PDT Day 2: Wednesday, 30 April 2025 | 9:00 AM ā 12:30 PM PDT Australia/New Zealand: Reserve Your Seat Today! Day 1: Wednesday, 30 April 2025 | 9:00 AM ā 12:30 PM AEDT Day 2: Thursday, 1 May 2025 | 9:00 AM ā 12:30 PM AEDT Europe: Reserve Your Seat Today! Day 1: Tuesday, 29 April 2025 | 9:00am ā 12:30pm BST Day 2: Wednesday, 30 April 2025 | 9:00am ā 12:30pm BST Microsoft Build 2025 Whether you're joining us in Seattle or tuning in online, Microsoft Build is your front-row seat to the future of technology. Taking place May 19ā22, this yearās conference will showcase groundbreaking innovations across cloud, AI, developer tools, and of course APIs and integration. Session catalog is live. Stay Connected! Q1 2025 set the stage for even bolder moves in the integration space. With hybrid flexibility, next-gen mapping, cross-cloud API management, and AI in every layer, Azure Integration Services and Azure API Management are ready to power whatās next. Stay tuned and subscribe to the Azure Tech Community blog.Summing it up: Aggregating repeating nodes in Logic Apps Data Mapper š§®
Logic Apps Data Mapper makes it easy to define visual, code-free transformations across structured JSON data. One pattern that's both powerful and clean: using built-in collection functions to compute summary values from arrays. This post walks through an end-to-end example: calculating a total from a list of items using just two functions ā `Multiply` and `Sum`. š§¾ Scenario: Line Item Totals + Order Summary Youāre working with a list of order items. For each item, you want to: Compute Total = Quantity Ć Price Then, compute the overall OrderTotal by summing all the individual totals š„ Input { "orders" : [ { "Quantity" : 10, "Price" : 100 }, { "Quantity" : 20, "Price" : 200 }, { "Quantity" : 30, "Price" : 300 } ] } š¤ Output { "orders" : [ { "Quantity" : 10, "Price" : 100, "Total" : 1000 }, { "Quantity" : 20, "Price" : 200, "Total" : 4000 }, { "Quantity" : 30, "Price" : 300, "Total" : 9000 } ], "Summary": { "OrderTotal": 14000 } } š§ Step-by-step walkthrough šļø 1. Load schemas in Data Mapper Start in the Azure Data Mapper interface and load: Source schema: contains the orders array with Quantity and Price Target schema: includes a repeating orders node and a Summary ā OrderTotal field šø Docked schemas in the mapper š 2. Recognize the repeating node The orders array shows a š icon on <ArrayItem>, marking it as a repeating node. šø Repeating node detection š” When you connect child fields like Quantity or Price, the mapper auto-applies a loop for you. No manual loop configuration needed. ā 3. Multiply Quantity Ć Price (per item) Drag in a Multiply function and connect: Input 1: Quantity Input 2: Price Now connect the output of Multiply directly to the Total node under Orders node in the destination. This runs once per order item and produces individual totals: [1000, 4000, 9000] šø Multiply setup ā 4. Aggregate All Totals Using Sum Use the same Multiply function output and pass it into a Sum function. This will combine all the individual totals into one value. Drag and connect: Input 1: multiply(Quantity, Price) Input 2: <ArrayItem> Connect the output of Sum to the destination node Summary ā OrderTotal 1000 + 4000 + 9000 = 14000 šø Sum function ā 5. Test the Output Run a test with your sample input by clicking on the Open test panel. Copy/paste the sample data and hit Test. The result should look like this: { "orders": [ { "Quantity": 10, "Price": 100, "Total": 1000 }, { "Quantity": 20, "Price": 200, "Total": 4000 }, { "Quantity": 30, "Price": 300, "Total": 9000 } ], "Summary": { "OrderTotal": 14000 } } š§ Why this pattern works š Repeating to repeating: Youāre calculating Total per order š Repeating to non-repeating: Youāre aggregating with Sum into a single node š§© No expressions needed ā itās all declarative This structure is perfect for invoices, order summaries, or reporting payloads where both detail and summary values are needed. š What's coming Weāre working on official docs to cover: All functions including collection (Join, Direct Access, Filter, etc.) that work on repeating nodes Behavior of functions inside loops Real-world examples like this one š¬ What should we cover next? Weāre always looking to surface patterns that matter most to how you build. If thereās a transformation technique, edge case, or integration scenario youād like to see explored next ā drop a comment below and let us know. Weāre listening. š§” Special thanks to Dave Phelps for collaborating on this scenario and helping shape the walkthrough.Logic Apps Aviators Newsletter - April 2025
In this issue: Ace Aviator of the Month News from our product group Community Playbook News from our community Ace Aviator of the Month Aprilās Ace Aviator: Massimo Crippa What's your role and title? What are your responsibilities? I am a Lead Architect at Codit, providing technical leadership and translating strategic technology objectives into actionable plans. My role focuses on ensuring alignment across teams while enforcing technical methodologies and standards. In addition to supporting pre-sales efforts, I remain hands-on by providing strategic customers with expertise in architecture, governance, and cloud best practices. Can you give us some insights into your day-to-day activities and what a typical day in your role looks like? My day-to-day activities are a mix of customer-facing work and internal optimization: A day could start with a sync with the quality team to assess our technical performance, evaluate the effectiveness of the provided framework, and identify areas for improvement. It might continue with discussions with our Cloud Solution Architects about customer scenarios, challenging architectural decisions to ensure robustness and alignment with best practices. Additionally, I meet with customers to understand their needs, provide guidance, and contribute to development workāI like to stay hands-on. Finally, I keep an eye on technology advancements, understanding how they fit into the companyās big picture, tracking key learnings, and ensuring proper adoption while preventing misuse. What motivates and inspires you to be an active member of the Aviators/Microsoft community? I'm passionate about cloud technology, how it fuels innovation and reshapes the way we do business.Yes, I love technology, but people are at the heart of everything. I am inspired by the incredible individuals I have met and those I will meet on this journey. The opportunity to contribute, learn, and collaborate with industry experts is truly inspiring and keeps me motivated to stay engaged in the community. Looking back, what advice do you wish you had been given earlier that you'd now share with those looking to get into STEM/technology? I started my career in technology at a time when knowledge was far less accessible than it is today. There were fewer online resources, tutorials, and training materials, making self-learning more challenging. Because of this, my best advice is to develop a strong reading habitābooks have always been, and still are, one of the best ways to truly dive deep into technology. Even today, while online courses and documentation provide great starting points, technical books remain unmatched when it comes to exploring concepts in depth and understanding the "why" behind the technology. What has helped you grow professionally? One key factor is the variety of projects and customers I have worked with, which has exposed me to different challenges and perspectives. However, the most impactful factor has been the mentors I have met throughout my professional journey. Having great leaders who lead by example is essential. Learning from them, applying those lessons in practice, and going the extra mile in your own way makes all the difference. If you had a magic wand that could create a feature in Logic Apps, what would it be and why? A fully containerized Logic Apps experience, encompassing the workflow engine, connectors, and monitoring. I envision a LEGO-like modular approach, where I can pick ready-to-use container images and run only what I need, whether in the cloud or at the edge, with minimal overhead. This composable integration model would provide maximum control, flexibility, scalability, and portability for enterprise integrations. News from our product group Logic Apps Live Mar 2025 Missed Logic Apps Live in March? You can watch it here. We had a very special session, directly from Microsoft Campus in Redmon, with four of our MVPs, which were attending the MVP Summit 2025. Together, weāve discussed the impact of community on our careers and how the AI wave impacts the integration space. Lotās of great insights from Cameron Mckay, Mick Badran, Mattias Lƶgdberg and Sebastian Meyer! Unleash AI Innovation with a Modern Integration Platform and an API-First Strategy Weāre excited to announce the "Unleash AI Innovation with a Modern Integration Platform and an API-First Strategy" event. Over two action-packed days, you'll gain valuable insights from Azure leaders, industry analysts, and enterprise customers about how Azure Integration Services and Azure API Management are driving efficiency, agility, and fueling business growth in the AI-powered era. Aggregating repeating nodes in Logic Apps Data Mapper This post walks through an end-to-end example of a powerful transformation pattern in Logic Apps Data Maps: using built-in collection functions to compute summary values from arrays, taking advantage of the Sum and Multiply functions. Public Preview Refresh: More Power to Data Mapper in Azure Logic Apps Weāre back with a Public Preview refresh for the Data Mapper in Azure Logic Apps (Standard) ā bringing forward some long-standing capabilities that are now fully supported in the new UX. With this update, several existing capabilities from the legacy Data Mapper are now available in the new preview version ā so you can bring your advanced scenarios forward with confidence. Reliable B2B Tracking using Premium SKU Integration Account We are introducing Reliable B2B Tracking in Logic Apps Standard using a Premium SKU Integration Account. This new feature ensures that all B2B transactions are reliably tracked and ingested into an Azure Data Explorer (ADX) cluster, providing a lossless tracking mechanism with powerful querying and visualization capabilities. Azure Logic Apps Hybrid Deployment Model - Public Preview Refresh We are thrilled to announce the latest public refresh of the Azure Logic Apps Hybrid Deployment Model, introducing .NET Framework custom code support on Linux containers, support for running the SAP built-in connector on Linux containers, and a Rabbit MQ built-in connector for on-premises queue scenarios. Using SMB storage with Hybrid Logic Apps Logic apps standard uses azure storage account to store artifact files such as host.json, connection.js etc,. With Hybrid environment in picture, access of azure storage account always cannot be guarenteed. And in any scenario, we can never assume that access internet will be available so assuming access to azure will be a long shot. To tackle this problem, in hybrid logic apps, we are using the SMB protocol to store artifact files. Scaling mechanism in hybrid deployment model for Azure Logic Apps Standard Hybrid Logic Apps offer a unique blend of on-premises and cloud capabilities, making them a versatile solution for various integration scenarios. This blog will explore the scaling mechanism in hybrid deployment models, focusing on the role of the KEDA operator and its integration with other components. Sending Messages to Confluent Cloud topic using Logic App In this blog post, we will explore how to use Azure Logic Apps to send messages to Kafka Confluent topic. Although currently there is no out-of-box Kafka Confluent connector in logic app, we found that Kafka Confluent provides REST API Confluent Cloud API Reference Documentation, allowing us to use the HTTP action in workflow to call the Kafka Confluent API which produce record to topic. Access [Logic Apps / App Services] Site Files with FTPS using Logic Apps You may need to access storage files for your site, whether it is a Logic App Standard, Function App, or App Service. Depending on your ASP SKU, these files can be accessed using FTP/FTPS. Some customers encounter difficulties when attempting to connect using Implicit/Explicit FTPS. This post aims to simplify this process by utilizing a Logic App to list files, retrieve file content, and update files. Boosting The Developer Experience with Azure API Management: VS Code Extension v1.1.0 Introducing the new version of the Azure API Management VS Code extension. This update brings several exciting enhancements, including tighter integration with GitHub Copilot to assist in explaining and drafting policies, as well as improved IntelliSense functionality. Deploy Logic App Standard with Application Routing Feature Based on Terraform and Azure Pipeline This article shared a mature plan to deploy logic app standard then set the application routing features automatically. It's based on Terraform template and Azure DevOps Pipeline. Logic Apps Aviators Community Playbook We are excited to announce the latest articles from the Logic Apps Aviators Community Playbook. Interested in contributing? We have made it easy for you to get involved. Simply fill out our call for content sign-up link with the required details and wait for our team to review your proposal. And we will contact you with more details on how to contribute. Streamline deployment for Azure Integration Services with Azure Verified Modules for Bicep Author: Viktor Hogberg Azure Verified Modules is a single Microsoft standard that gives you a unified experience to streamline deployment for Bicep modules and publish them in the public Azure Bicep Registry in GitHub. These modules speed up your experience when working with deployments - no more guessing, copying and pasting, or unclear dependencies between resources. Learn how to use those modules to deploy Azure Integration Services efficiently! News from our community Properly securing Logic App Standard with Easy Auth Post by Calle Andersson In this post, Calle shows you how to configure authentication with only the minimal settings required to lock things down. This makes automation possible since it doesn't require high privileged permissions to be given to a pipeline. Integration Love Story with Massimo Crippa Video by Ahmed Bayoumy In the latest episode of Integration Love Story, we meet Massimo Crippa ā an Italian living in France, working in Belgium, and deeply involved in Microsoft's integration platforms. With a background ranging from COM+ and SSIS to today's API Management and Logic Apps Hybrid, Massimo shares insights from a long and educational career. Logic App Standard workflow default page can be changed Post by Sandro Pereira In Azure Logic Apps (Standard), you can change the default page that loads when you open a workflow in the Azure Portal! Azure has introduced a Set as default page option in the Azure Portal for Logic App Standard workflows. This allows you to customize which tab (like Run History or Designer) opens by default when you enter a workflow. Enhancing Operational Visibility: Leveraging Azure Workbooks series Post by Simon Clendon This is blog post series that describes how to use the power of Log Analytics Workbooks to display tracking data that can be filtered, sorted, and even exported to Excel. The post will also show how related records can be listed in grids based on a selection in another grid, taking the Logic Apps tracking data that is sent to Log Analytics when diagnostics are captured to the next level. Logic App Standard: Trigger History Error ā InvalidClientTrackingId Post by Sandro Pereira In this article, Sandro Pereira addresses the issue of InvalidClientTrackingId errors in Azure Logic Apps when customizing the Custom tracking ID property of workflow triggers. Logic Apps in VS Code fail to save if the Designer canāt resolve your API ID Post by Luis Rigueira Learn how to ensure your app settings are correctly configured when building Logic Apps (Standard) in VS Code, especially when using the Designer with API Management, to prevent save issues and streamline your development process.š Public Preview Refresh: More Power to Data Mapper in Azure Logic Apps
Weāre back with a Public Preview refresh for the Data Mapper in Azure Logic Apps (Standard) ā bringing forward some long-standing capabilities that are now fully supported in the new UX. In our initial announcement, we introduced a redesigned experience focused on usability, error handling, and improved mapping for complex schemas. As we continue evolving the tool, weāre working to bring feature parity with the classic experience, while layering in modern enhancements along the way. With this update, several existing capabilities from the legacy Data Mapper are now available in the new preview version ā so you can bring your advanced scenarios forward with confidence. š ļø Run XSLT Inside Your Data Map The ability to apply XSLT has long been a powerful feature in Logic Apps, and weāre excited to bring Run XSLT support into the new UX. You can now invoke reusable transformation logic from your map, including: Enterprise-grade XSLT Predefined templates or logic from your BizTalk workflows How to try it out: Create a new data map. Right-click on the MapDefintions or Maps folder and click Create new data map Store the XSLT file under Artifacts -> DataMapper/Extension -> InlineXslt. Open the data map and search for Run XSLT in the functions panel. Select the function and simply select the function you want to run from the dropdown Connect to desired destination node. In my case, the function simply adds a "Placeholder" value for the Name node at destination, alongside an "EmployeeType" node. Note that you do not need to connect any source node to the XSLT function given this is custom XSLT logic that will be applied directly at destination node. Upon testing the map, right value is generated in the destination schema š Execute XPath to Extract Targeted Values Execute XPath is now supported in the new experience, giving you control to extract specific values from nested XML structures. This function is particularly useful for: Accessing attributes and nested elements Applying logic based on the structure or content of incoming data How to try it out: Search for Execute XPath in the functions panel. Select the function and add the expression you want to extract Map it to destination node. Here is what the map will look like: The test payload correctly creates multiple Address nodes at destination based on the Address node at source. š§© Use Custom XML Functions Custom XML functions allow you to define and reuse logic across your map. This helps reduce duplication and supports schema-specific transformations. Now that support is available in the new UX, you can: Wrap complex logic into manageable components Handle schema-specific edge cases with ease How to try it out: Add the .xml function file under Artifacts -> DataMapper/Extension -> Functions Open the data map and under Utility category of functions, select the new function. In our case, the xml function is called Age Connect function input to Date_of_Birth node at source and output to Age node at destination. The map will look something like this Test the map and notice that the age is calculated correctly at the destination node š Dark Mode Support in VS Code The new UX now respects Dark Mode in VS Code, giving you a visually cohesive and low-contrast authoring experience ā perfect for long mapping sessions. No extra steps needed ā Dark Mode works automatically based on your VS Code theme settings. āļø How to Enable the New Experience If you havenāt yet tried the new UX: Open your Logic Apps (Standard) project in VS Code Go to Logic Apps (Standard) extension ā Settings ā Data Mapper Select Version ~2 Youāll find detailed walkthroughs in the initial preview announcement blog. š¬ Weād Love Your Feedback Weāre continuously evolving the Data Mapper, and your feedback is key to getting it right ā especially as we bring more advanced transformation scenarios into the new experience. š Submit your feedback here š Found an issue or have a specific feature request? Let us know on GitHub Issues Thanks again for being part of the journey ā more updates coming soon! šAnnouncing: Unleash AI Innovation with a Modern Integration Platform and an API-First Strategy
As AI technologies continue to evolve, they offer businesses a unique opportunity to modernize operations, accelerate innovation, and unlock new growth potential. To stay ahead of the curve, organizations need a comprehensive integration and API strategy that seamlessly connects data, applications, and AI across their entire ecosystem. Weāre excited to announce the "Unleash AI Innovation with a Modern Integration Platform and an API-First Strategy" event. Over two action-packed days, you'll gain valuable insights from Azure leaders, industry analysts, and enterprise customers about how Azure Integration Services and Azure API Management are driving efficiency, agility, and fueling business growth in the AI-powered era. Why Attend? From security to development, customer success stories to expert analyst insights, this event will highlight why APIs and integration are critical for success now and in the future. Get exclusive industry insights: Gain expert perspectives from IDCās Shari Lava, Azure product leaders, and Forrester consultant Andrew Nadler on the latest trends shaping enterprise integration and API strategies. Learn from real-world customer stories: Hear firsthand from organizations like DocuSign, Visa, LyondellBasell, Metcash, Khoj, Brisbane City Council, Moneris, Heineken, Transcard, and CareFirst BlueCross BlueShield on how they are transforming operations with Azure Integration Services and Azure API Management. Accelerate your AI and integration strategy: Learn how Azure Logic Apps make AI-driven automation more accessible than ever, and how Azure API Management empowers businesses to securely scale AI-powered APIs. Event Highlights Day 1: Drive Business Growth with a Modern Integration Platform In todayās competitive landscape, businesses must seamlessly connect data, applications, and AI. On Day 1, you'll explore how Azure Integration Services help organizations break down data silos, unlock real-time insights, and optimize operations. Learn how connected data streams enable smarter, faster decision-making, while AI-powered workflows reduce complexity and drive operational efficiency. Weāll also explore how businesses are modernizing legacy systems by migrating from BizTalk and other on-premises integration solutions to Azure Integration Services, providing greater scalability, agility, and business continuity. Day 2: Power AI and Enterprise Innovation with an API-First Strategy On Day 2, you'll dive deep into how APIs are the backbone of modern digital ecosystems. APIs enable businesses to scale faster, enhance developer experiences, and create new revenue streams. Learn how Azure API Management helps you secure, manage, and monetize APIs while accelerating AI adoption. Youāll also discover best practices for securing and governing APIs across distributed environments, ensuring that your AI-powered ecosystem remains secure, scalable, and compliant. Streamed Live Across Multiple Time Zones Join us no matter where you are! Weāre streaming live across multiple time zones, so you can participate at a time that works best for you. US/Canada: Reserve your seat today! Day 1: Tuesday, 29 April 2025 | 9:00 AM ā 12:30 PM PDT Day 2: Wednesday, 30 April 2025 | 9:00 AM ā 12:30 PM PDT Australia/New Zealand: Reserve Your Seat Today! Day 1: Wednesday, 30 April 2025 | 9:00 AM ā 12:30 PM AEDT Day 2: Thursday, 1 May 2025 | 9:00 AM ā 12:30 PM AEDT Europe: Reserve Your Seat Today! Day 1: Tuesday, 29 April 2025 | 9:00am ā 12:30pm BST Day 2: Wednesday, 30 April 2025 | 9:00am ā 12:30pm BST Ready to Future-Proof Your Integration and API Strategy? Donāt miss this exclusive opportunity to learn from industry experts, Azure leaders, and top enterprises. Discover how to future-proof your integration and API strategy to drive AI-powered growth and business success.
