Blog Post

Azure Integration Services Blog
2 MIN READ

Upcoming Data Mapper improvements

shahparth's avatar
shahparth
Icon for Microsoft rankMicrosoft
May 17, 2024

This past November, we announced the general availability of our Data Mapper, a tool for developers to perform data transformation tasks inside of Azure Logic Apps. Through customer engagements, we have gathered valuable feedback and are ready to share some enhancement plans to address this feedback. These updates streamline data mapping tasks, rendering your workflow more intuitive and efficient. Let’s explore the new features and discuss how these changes can improve your data mapping experience.

 

If you are interested in joining our Private Preview early this summer to provide feedback on these new capabilities, please fill out the form in the feedback section. Your opinions help shape future updates.

 

Improvements

  1. Create data map

    Upload a new schema or select an existing one. The source schema, previously floating, now docks on the opposite side of the destination schema, enhancing visibility.

  2. Map a property to another property

    Use drag-and-drop to assign source properties to destinations.

  3. Understand a property type

    Hover over a property to discover its data type.

  4. Add a function then map to properties

  5. Function chaining

    Address more complex requirements by chaining functions together. Collapse the functions together to save valuable real estate.

  6. Rename functions and add notes
    To reduce complexity, we now allow function renaming for clarity and the option to add notes. This prevents confusion and makes editing and reviewing more straightforward.

  7. Reorder source properties
    Add static values and reorder properties to refine output at destination

  8. Expand/collapse hierarchy
    Support for complex schemas includes starting with nested properties in a collapsed state and expand as required to access deeper properties.

  9. Adjust width of side panel
    Modify a side panel’s width to address scaling for deep schema trees.

  10. Search within a schema
    Search functionality to discover specific elements  
  11. Favorite function
    Pin frequently used functions for quick access.
  12. View underlying code 
    Open the YAML file in read-only mode to read the code that powers the mapping process.
  13. Test map
    Select an existing source payload matching your schema type and check whether the mapper yields desired output.
  14. Understand if there has been an error
    Easily detect and address errors during mapping

Conditional mapping and looping improvements to follow in next part soon. 

Feedback

Please use this questionnaire to provide detailed feedback or file a feature request using the Data mapper tag on our GitHub Issues.

Updated May 20, 2024
Version 11.0
  • GoutamenduHait's avatar
    GoutamenduHait
    Copper Contributor

    Is it possible to implement a lookup during mapping? We have scenarios where we need to perform lookups using an external API, Azure Storage table, or Azure SQL in some cases.

  • ShaneBlake's avatar
    ShaneBlake
    Copper Contributor

    GoutamenduHait as you have the data as input into the Map action, could you not do the lookup in an action before the Map and pass it in as part of the inputs to the Map as part of the flow the Map occurs in? Saves a specific lookup function being created within the Map. 

  • This looks really promising! :stareyes: I hope the mapping tool will have the possibility to create, edit and test custom functions as well within the GUI.

  • FernandoPires71's avatar
    FernandoPires71
    Copper Contributor

    Looks really prommising,  hope we can add custom code from external assemblies and also inline c# functions.