What is Data Mapper?
Data Mapper is Azure Logic Apps' new visual data transformation tool, currently available as a Visual Studio Code extension, that can create and edit maps between source and ta...
Updated Nov 09, 2023
Version 4.0
Blog Post
3 MIN READ
Announcement: Azure Logic Apps' New Data Mapper for Visual Studio Code (Preview)
Thank you SanjivGupta for addressing my concern.
I already tried the solution you did mention and then only I put my concern to initiate this thread.
I did try populating the value as null in the properties pane but it reflects as is (i.e. null) in the code view as shown below,
I mean it did not change to $null as mentioned by you in your snap.....or am I missing any step here?
Then post save & XSLT generation, if I test the xslt using below two payloads,
I get below exception for both cases (even for happy path scenario, I mean "Surname": "Bankar" it fails),
500 - ActionFailed: An error occurred while transforming the given input with the provided map. Details: 'An empty sequence is not allowed as the second argument of dm:if_then_else()'.
[2023-12-05T14:50:39.088Z] Executing 'Functions.XsltNetFxLanguageWorkerFunction' (Reason='(null)', Id=f197cc18-1288-4015-b28d-b98639b039a5)
[2023-12-05T14:50:39.093Z] Type error at char 74 (in expression on line 19) of
[2023-12-05T14:50:39.093Z] XPTY0004 An empty sequence is not allowed as the second argument of dm:if_then_else()
[2023-12-05T14:50:39.094Z] invoked by xsl:for-each at #14
[2023-12-05T14:50:39.094Z] In template rule with match="/" on line 10 of
[2023-12-05T14:50:39.094Z] invoked by xsl:apply-templates at #6
[2023-12-05T14:50:39.094Z] In template rule with match="/" on line 3 of
[2023-12-05T14:50:39.095Z] An error occurred while transforming the given input with the provided map. Details: 'An empty sequence is not allowed as the second argument of dm:if_then_else()'.
[2023-12-05T14:50:39.096Z] Result: An error occurred while transforming the given input with the provided map. Details: 'An empty sequence is not allowed as the second argument of dm:if_then_else()'.
Exception: Microsoft.Azure.Workflows.BuiltIn.Xslt.Common.Exceptions.ErrorResponseMessageException: An error occurred while transforming the given input with the provided map. Details: 'An empty sequence is not allowed as the second argument of dm:if_then_else()'.
[2023-12-05T14:50:39.096Z] at Microsoft.Azure.Workflows.BuiltIn.Xslt.Common.Utilities.XsltTransform.TransformUsingSaxonica(XsltInput input, XsltMapContent mapContent) in C:\__w\1\s\src\netStandard\BuiltIn.Xslt.Common\Utilities\XsltTransform.cs:line 281
[2023-12-05T14:50:39.096Z] at Microsoft.Azure.Workflows.BuiltIn.Xslt.NetFx.Providers.XsltNetFxBuiltInOperationsProvider.<TransformUsingSaxonica>d__18.MoveNext() in C:\__w\1\s\src\functionWorkers\builtIn\BuiltIn.Xslt.NetFx\Providers\XsltNetFxBuiltInOperationsProvider.cs:line 315[2023-12-05T14:50:39.096Z] Executed 'Functions.XsltNetFxLanguageWorkerFunction' (Succeeded, Id=f197cc18-1288-4015-b28d-b98639b039a5, Duration=7ms)
Whereas as a wild guess, if I put $null explicitly in the properties pane then it does reflect as $null in code view but post re-run the test, the same error appears.
If I missed anything then do let me know.
wrt your inputs on UUID, I am still looking for documentations.
If you have any pointers on how to use custom functions and inline XSLT in Data Mapper then please do share.
Thanx,
-Swapnil