#Payload0 debatiendo

Thanks @Rohit Reddy for your response.​ .

But i am facing issue while implementing solution this into Dataweave.

Message        : Exception while executing: 

          td @(style:"text-align: center;"): $.status,

                            ^

Type mismatch for 'Value Selector' operator

   found :string, :name

 required :datetime, :name or

 required :localdatetime, :name or

 required :object, :name or

 required :time, :name or

 required :array, :name or

 required :date, :name or

 required :localtime, :name or

 required :period, :name.

Payload        : { "email": "abcb@hcl.com", "status" : "NO Id Avalible" }

Payload Type     : java.lang.String

Flow XML is: [Attached XML file]

<flow name="testerappFlow">

    <poll doc:name="Poll">

      <fixed-frequency-scheduler frequency="1" timeUnit="MINUTES"/>

      <set-payload value="{ "email": "abcb@hcl.com", "status" : "NO Id Avalible" }" doc:name="Set Payload"/>

    </poll>

    <set-variable variableName="payloadVar" value="#[]" doc:name="Variable"/>

    <expression-component doc:name="Expression"><![CDATA[flowVars.payloadVar.add(payload);]]></expression-component>

    <logger message="#flowVars ---- payload: #payload" level="INFO" doc:name="Logger"/>

    <dw:transform-message doc:name="Transform Message" metadata:id="8aad28c5-b6fd-456f-b409-870e8f92b1e5">

      <dw:input-variable doc:sample="sample_data\string_1.dwl" variableName="payloadVar"/>

      <dw:set-payload><![CDATA[%dw 1.0

%output application/xml

---

html :

  body :

    table @(border:1,cellpadding:1,

    cellspacing:1,style:"width:500px"):

      tbody : 

        tr : {

          td @(style:"text-align: center;"): "Email Id",

          td @(style:"text-align: center;"): "Update Status"

        } ++

        {(flowVars.payloadVar map {

          td @(style:"text-align: center;"): $.status,

          td @(style:"text-align: center;"): $.email

     }

        )}

        ]]></dw:set-payload>

    </dw:transform-message>

    <logger message="payload at End: #payload" level="INFO" doc:name="Logger"/>

  </flow>

@Jjj Rock​ 

I have achieved this without using any execute command using ISO date format as follows, ISO date format is working in mongo if we send in proper format as follows where "date_modified" is my field name in mongodb

Transform Payload for the mongo query:

{

 "\$expr": {

  "\$gte": [

   "\$date_modified",

   { "\$toDate": "2024-11-20T11:56:14.000+00:00" }

  ]

 }

}

sample flow which is working as follows :

<flow name="GetRecordsWithDate" doc:id="3a18e2ea-466b-4d30-ab26-dc56e1e8b910">

<scheduler doc:name="Scheduler" doc:id="aae27461-6164-46b0-8818-06a6dc41024c">

<scheduling-strategy>

<fixed-frequency timeUnit="HOURS" />

</scheduling-strategy>

</scheduler>

<ee:transform doc:name="Transform Message" doc:id="dc2bd055-977e-4133-ae6b-2b37d42cb242" >

<ee:message >

<ee:set-payload ><![CDATA[%dw 2.0

output application/json

---

{

"\$expr": { "\$gte": ["\$date_modified", { "\$toDate": '2024-11-20T11:56:14.000+00:00' } ] }

}]]></ee:set-payload>

</ee:message>

</ee:transform>

<mongo:find-documents doc:name="Find documents" doc:id="27734fbb-9669-4f33-bb92-96f26df51a3b" config-ref="MongoDB_Config" collectionName="collectionName" fields=",">

<mongo:query ><![CDATA[#payload]]></mongo:query>

</mongo:find-documents>

<!-- Use DataWeave to extract distinct IDs -->

<ee:transform doc:name="Transform Message" doc:id="2c99f8b6-1b2f-4ce9-b8b7-56086fbc28d5" >

<ee:message >

<ee:set-payload resource="transformations/distinct_avails_all_titles_alpha_rl_ids.dwl" />

</ee:message>

</ee:transform>

</flow>

Hi @Michael Orechoff​ . I have just run across a similar issue. I see this in the logs:

Failed to get procedure types with schema MULESOFTFA, package MS_BUSNS_TRAN_PKG and procedure DO_CREATE. Removing all catalog and schema filters.

Then get this error:

errorType: {

    identifier: "QUERY_EXECUTION",

    parentErrorType: {

      identifier: "ANY",

      parentErrorType: null,

      namespace: "MULE"

    },

    namespace: "DB"

  },

  childErrors: [],

  errorMessage: null,

  cause: {

    localizedMessage: "Invalid conversion requested",

    cause: {

      localizedMessage: "Invalid conversion requested",

      errorCode: 17132,

      cause: null,

      message: "Invalid conversion requested",

      SQLState: "99999",

Sounds similar to yours. Did Mulesoft give you any kind of timeframe?

Hi @Phani Kakuleti​ !

Do you know if it's possible to ask the source of the csv to escape the "," in the file they send you

Because if they can something like this:

It will simplify the required DWL to solve the issue:

And if that's not possible, then you need to process the csv as a string and perform the following operations:

%dw 2.0
output application/csv separator='|'
var replacedPayload = payload replace '","' with '"\,"'
var parsedPayload= read(replacedPayload, 'application/csv')
---
parsedPayload

Hope it helps!

Good luck!!

Juan Cruz Basso

Hi @Hichem Rtibi​ ,

Based on what I can understand from your code, you are walking through an array in the payload, using some information of each element to query the DB and to a transformation.

If you want as a result, an array with each transformed element, you need to create an auxiliary variable in the flow, and before finishing the for each append the result you are looking for.

Check this flow:

In the first processor you need to initialize the auxiliar variable as an empty array with []. Be aware, after doing the processing logic, you have to set the auxiliar variable again. I this sample I used the transform processor and append the result of my transformation to the array.

Hope it helps.

Good luck!

Juan Cruz Basso

Hi @prajwal M R​ !

You can re utilize the xslt you have already, but you need to be aware to provide all the libraries or replace them.

Here is a basic usage of it and I'm also attaching the updated xslt that worked for me:

<?xml version="1.0" encoding="UTF-8"?>
 
<mule xmlns:ee="http://www.mulesoft.org/schema/mule/ee/core" xmlns:xml-module="http://www.mulesoft.org/schema/mule/xml-module"
	xmlns:vm="http://www.mulesoft.org/schema/mule/vm"
	xmlns="http://www.mulesoft.org/schema/mule/core" xmlns:doc="http://www.mulesoft.org/schema/mule/documentation" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.mulesoft.org/schema/mule/core http://www.mulesoft.org/schema/mule/core/current/mule.xsd
http://www.mulesoft.org/schema/mule/vm http://www.mulesoft.org/schema/mule/vm/current/mule-vm.xsd
http://www.mulesoft.org/schema/mule/xml-module http://www.mulesoft.org/schema/mule/xml-module/current/mule-xml-module.xsd
http://www.mulesoft.org/schema/mule/ee/core http://www.mulesoft.org/schema/mule/ee/core/current/mule-ee.xsd">
	<flow name="simple-testFlow" doc:id="99235cf9-33ce-4aa9-8f8a-aeb5e9f4a935" >
		<scheduler doc:name="Scheduler" doc:id="0f62fff3-b06a-4d80-a469-b99351e4f161" >
			<scheduling-strategy >
				<fixed-frequency timeUnit="MINUTES"/>
			</scheduling-strategy>
		</scheduler>
		<ee:transform doc:name="Transform Message" doc:id="2a506544-cff4-463c-ae2a-171e47a85bba" >
			<ee:message >
				<ee:set-payload ><![CDATA[%dw 2.0
output application/xml
---
{
	root:
		{
			targetSample : 'TargetValue',
			senderSample : 'SenderValue'
		} 
}]]></ee:set-payload>
			</ee:message>
		</ee:transform>
		<xml-module:xslt-transform doc:name="Xslt transform" doc:id="f9fc4bf1-22f3-4be8-97ca-c32d856eb6fb">
		  <xml-module:xslt><![CDATA[${file::test.xslt}]]></xml-module:xslt>
		</xml-module:xslt-transform>
		<ee:transform doc:name="Transform Message" doc:id="594f3700-d013-417c-a781-5f5fa0c8ce75" >
			<ee:message >
				<ee:set-payload ><![CDATA[%dw 2.0
output application/xml
---
read(payload,'application/xml')]]></ee:set-payload>
			</ee:message>
		</ee:transform>
		<logger level="INFO" doc:name="Logger" doc:id="133d91b0-aa68-4553-b8d8-0880eff81feb" message="#payload"/>
	</flow>
</mule>

In this sample you will see that a scheduler is triggering the flow ( you can use any other) , and it's using from the XML module the xslt-transform processor . After the xslt is executed I added a transformation to get the xml otherwise, it's a plain string.

Hope it help!

Good luck!

Juan Cruz Basso

Hi @Sudha 1​ ,

Did you try closing the project and open it again? Or refreshing it? ( after adding the dependency )

Did you try running the code ? Check if you still have the error when running a MUnit or the code.

Hope it helps!

Good luck!

Juan Cruz Basso

Hi Tulasi,

It seems that the problem is not around the file name only.

This is not right :

   <sharepoint:file-content-stream>#payload</sharepoint:file-content-stream>

I think this one is correct:

	<sharepoint:file-add doc:name="File add" doc:id="4a0364bd-262c-4333-90f3-1151ab8bcd8f" config-ref="Sharepoint_Sharepoint_online" fileServerRelativeUrl="#['/Documents/' ++ vars.fileName]">
			<sharepoint:file-content-stream ><![CDATA[#payload]]></sharepoint:file-content-stream>
		</sharepoint:file-add>

Good luck!