1,371 questions
0
votes
1
answer
89
views
I want to update column A of input csv file based on condition of column B. How we can achieve this in dataweave?
"Id","Name","Salary","Location","Date"
123,"Ganesh",10000,"Pune","02/22/2020"
234,"Sanket",20000,"Mumbai&...
0
votes
2
answers
101
views
DataWeave - Add additional item after iteration used for list
I'm trying to create the following XML:
<ns10:Payload>
<ns6:MeterReadings>
<ns6:MeterReading>
<ns6:Readings>
<ns6:reportedDateTime>2024-06-...
- 3
0
votes
0
answers
90
views
Mule 4.5 throwing ORA-01000: maximum open cursors exceeded
I am using Mule 4.5 running against an Oracle db instance Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
The mule code that I am running is driven by a scheduler and runs once ...
1
vote
1
answer
591
views
How to extract key and value pairs and store them in Object Store V2 Mule 2.0
I have a requirement to iterate the below input payload and store all the EMPNAME as key and EMPID as value in Object store.
{
"application": "salesforce",
"payload&...
- 77
0
votes
1
answer
1k
views
How to handle Too Many Requests (429) error in Mule 4 Process API
I am new to Mulesoft and need help in resolving the Too Many Requests (429) error thrown when I call my Mule System API /Layer from Mule Process API.
My Mule Process API has below mentioned (...
- 77
0
votes
1
answer
432
views
How to sum the values of child objects in an array with DataWeave
Below is the input. There is a parent child-relationship with objects. The "Key" key specifies that.
For e.g. 109-200C-001 is the child of 109-200C. There will be n number of objects with ...
- 119
-4
votes
1
answer
290
views
Removing special character in Mule 4
I'm passing oayload as "item" : "Indoor" and the trying to get the output as "scenario" : "Indoor" but instead in the in the output I below output:
"...
0
votes
1
answer
3k
views
Couldn't find configuration property value for key ${mule.env} error
I am new to Mulesoft and setting up my first Mulesoft project in Anypoint studio and seeing this error - Couldn't find configuration property value for key ${mule.env}
Can some one help me how to fix ...
- 43
0
votes
1
answer
70
views
Getting error while sending Email subject with expression
I am getting error while sending email with customized subject with expression :
and getting below error :
while writing Java at
3| {"DataGenerated" : (now()) as String { format: "dd ...
- 1,226
0
votes
2
answers
493
views
How can we check the format of the date coming in Payload using Dataweave
We have a requirement where the source is a file and it has a date field that can contain different date format. For example MM/dd/yyyy or MM/dd/yy or MM-dd-yyyy or MM-dd-yy. This date field we want ...
- 111
1
vote
1
answer
3k
views
MuleSoft always returns back a 500 internal server error response from target API to source API even though another error occurred in the Target API
I am getting different errors in both APIs even though the error returned from the Target API should match the error showed in the logs of the Source API.
Let's say there are 2 APIs. One of them (...
- 13
1
vote
4
answers
239
views
conditional logic for dataweave code in mule 4
I need help on dataweave code. My requirement is to add the status field in the response based on the below criteria.
var manditory_field="D6V_Cod,D6V,DYR_Cod,DYR"
If any of the ...
- 225
0
votes
0
answers
95
views
Mule 4 custom policy performance improvement
I recently developed a Mule 4 custom policy which intercepts an incoming request, makes an api call using the req body and from the response received, it appends a header with the response value. The ...
- 410
0
votes
1
answer
113
views
How to verify that all elements of a list comply with some conditions
I have this input payload to a Mule 4 application:
{
"P_CUST_ACCOUNTS": [
{
"ACCOUNT_NUMBER": 62972,
"ADDR_CHG_FLAG": "N"
},
{
&...
- 13
0
votes
2
answers
268
views
How to dynamically convert an list of strings into key value pair using dataweave 2.0
I have a below input where I have key "Actual_Amount" which is a list of strings. I want to convert this key into multiple keys based on the no of values in the string.
Input:
[
{
&...
- 129
0
votes
0
answers
439
views
Mule4: Get job state bulk api v2 operator not able to find the job ID from salesforce
I am using Mulesoft to do a bulk query from salesforce object.
In the below code I am trying to extract the jobId from the output of "Create query job bulk api v2" operator. The job ID is ...
- 87
2
votes
2
answers
4k
views
Mule Maven Plugin 3.8.0 not working as expected
When I am using mule-maven-plugin version 3.5.4 I am able to successfully build and run a project in anypoint studio but for the same project when I update the mule-maven-plugin version to 3.8.0 , it ...
- 2,427
0
votes
0
answers
345
views
Mule Runtime 4.5 error with import in Munit
I am trying to develop a mule application with Mule runtime 4.5
It works fine in Anypoint studio , but whenever I try and build and deploy using Pipeline it fails with the error :
2024-04-05T01:42:26....
0
votes
1
answer
134
views
Mule 4 SAX parse exception during custom policy deployment
After uploading the implementation for my custom policy, I am seeing two errors in logs when it attempts to deploy, here is the first error:
ERROR 2024-06-17 18:53:05,449 [agw-policy-set-deployment.01]...
- 3
1
vote
1
answer
369
views
MuleSoft-Dataweave convert variable (" output application/json") to string error
I need to convert the variable (output "application/json") to string
in mulesoft's dataweave
it works with
jsonpayload: write(vars.originalPayload, "application/json")
but ...
- 577
0
votes
1
answer
72
views
Mule 3 vs Mule 4 - is payload immutable?
We are migrating a Mule 3 api to Mule 4 and am observing some behaviour which am not able to make sense of in Mule 3 .....
We have an incoming payload from an HTTP endpoint
{
empId: 10,
empAge: ...
0
votes
1
answer
184
views
Unable to resolve value for the parameter in Consume node
In my flow i set variable operation as :payload.operation then in Consume node i want to get it's value
Variable value is set corectly
I also include xml of my flow:
<?xml version="1.0" ...
- 25
0
votes
0
answers
336
views
Could not resolve dependencies for project : mule-policy:1.0.0
I am developing a MuleSoft custom policy and have created a new policy using the Maven archetype command as follows:
mvn archetype:generate -Parchetype-repository \
-DarchetypeGroupId=org.mule.tools \
...
- 410
0
votes
1
answer
806
views
Mule 4 anypoint studio in Debug Mode - can I change the payload value or a variable value
This may not really be a code question , but many times when running Mule in debug mode in Anypoint studio ( Mule 4.3 , Anypoint Studio 7.15.0 ) , is there a way where while in Debug mode I can update ...
0
votes
1
answer
1k
views
How to convert string to array and object in mule 4
I have a requirement where I need to convert a String to array or object if present in payload or else return the value as string or boolean.
Input
{
"Id": {
"EmpId": 1
...
- 1
0
votes
2
answers
977
views
Mule 4 Database Insert into Oracle Table with Date field issues
Am using Mule 4 ( runtime 4.3 ) running in anypoint studio ( 7.15.0 )
Am trying to do a simple database insert ( Database is Oracle )
Here is the relevant code for insert :
<db:insert doc:name=&...
2
votes
1
answer
199
views
How to Access Source Code or Definitions of Inbuilt Functions in Mule 4 DataWeave?
I've primarily relied on custom modules and functions I've created for specific needs. However, I've also been utilizing a number of inbuilt functions provided by Mule in DataWeave, such as the upper ...
- 930
0
votes
1
answer
179
views
If a SOAP Fault error occurs in Mule, in which variable is '<soap:Header>' stored?
I am using Mule Runtime Engine 4.4.0.
Consume a Web Service to run the SOAP API.
I am not sure which variable the 'soap:Header' information is stored in when an SOAP fault occurs.
The <soap:Body>...
- 3
0
votes
1
answer
903
views
now() - current time issue for mule app deployed on Any point platform
I have a question about the current time issue in our Mule App, which is deployed on any point platform.
When using 'now()' in mule app, it consistently returns a time that is one hour different as ...
- 577
0
votes
1
answer
2k
views
How to read xml file set the content as Transform Message 's payload in Mulesoft (Dataweave)
I need to read the content of XML file and set it as payload via Transform Message Component
I did it as below, but got Error as below
Dataweave Script
%dw 2.0
output application/xml
---
Mule::p('file:...
- 577
0
votes
1
answer
112
views
To handle null check when using max() in Mule 4 DW 2.0
I am trying to get the latest end date from the below payload using max() which is working fine but there are chances that the endDate might be empty or elements itself might not be present in the ...
- 77
2
votes
2
answers
845
views
raw is not working incase of retrieving the value form a variable in dataweave 2 mule
I'm just trying to convert the numeric values to strings without losing their decimal values, including zeros.
This can be done using the raw operator in DataWeave 2.0. In below I converted a 123.0 ...
- 570
0
votes
1
answer
2k
views
convert dateTime to salesforce required dateTime format in mule 4
For the dateTime "2022-11-29T19:12:21Z" getting INVALID_TYPE_ON_FIELD_IN_RECORD error from salesforce. So need to convert it in correct format that Salesforce accept.
Input: "2022-11-...
- 225
0
votes
2
answers
51
views
Can we enable code coverage while the api is running NOT while running Munits
while this is not a question about any specific code , am wondering if there is a way that we can enable code coverage after the api is deployed and QA team is testing functionality
The way we get ...
0
votes
0
answers
101
views
can not able to get authorize code from webex service
I am building API to get the authorize code from webex.
I've a experience API (http://localhost:8081/captures/query) from where I am invoking system API ( http://localhost:8081/authorize) and from ...
- 225
0
votes
1
answer
422
views
common java jar import into mule project
I'm trying to import a common-math Java jar into my mule project and just do basic functionality check of the java jar.
As per this blog https://mulesy.com/external-jar-class-in-dataweave/
I have ...
- 45
1
vote
2
answers
223
views
Dataweave filter condition is not working for less than equal to a string
I have this payload and dataweave code, but in the below dataweave Less than is working but not equal to? Can someone please help..how to handle equals also?
Payload:
[{
"Id": "...
- 11
0
votes
3
answers
232
views
How to compare two dates with only month and year in mule
My scenario is to check if the Month and year (in date value) is less than the current month and year (in current date value).
The condition I need to implement is this
if source-month&year < ...
- 111
1
vote
0
answers
234
views
How can I effectively manage SFTP Private key files in MuleSoft applications
I'm working on setting up a connection to an SFTP server using a private key file and a username for authentication in my Mule application. Currently, I've managed to make it work by storing the key ...
0
votes
1
answer
313
views
Get flow name from subflow
For the intended use of a library, I need to log the calling flow name from the called subflow that is who handles the logging. Is it possible to retrieve the name of a calling flow from a subflow?
I ...
0
votes
1
answer
64
views
In array of objects with similar division, check the new record and previous record and aggregate the response in dataweave
Input:
[
{
"employeeId": 100,
"firstName": "John",
"lastName": "Chen",
"division": "2024-DOA09-1111",
"...
- 19
-2
votes
1
answer
318
views
how to replicate Failed parsing field: content org.mule.runtime.core.api.expression.ExpressionRuntimeException?
I have an API that is using GET method to get status of an order ./status/orderId/123456
123456 is a path parameter that we need to pass.
Sometimes in mule log I am seeing below error, but not sure ...
0
votes
1
answer
518
views
Database connectivity issue in Mule4.2.0
We are facing a MySQL database connectivity issue in Mulesoft, the mule has two types of database transactions. one is to the mule’s server( Self ) database and another one is to the remote server ...
- 3
0
votes
1
answer
373
views
Mule 4 with Anypoint MQ -Do messages go to DLQ automatically when redelivery attempts are exhausted?
Using Anypoint MQ with Mule Runtime 4.4
Have a subscriber which will consume messages from a normal queue .
This queue has a DLQ configured .
Max Redelivery count = 2
Acknowledgement mode = Auto
Here ...
0
votes
2
answers
110
views
Convert a single column values into multiple rows using dataweave
I receive a JSON payload where two columns contains array of values. We want to split the the array column into multiple rows.
Sample Input:
[
{
"firstName": "John",
...
- 111
-1
votes
1
answer
249
views
Dataweave Transformation- How can I reduce a payload array when condition is met
I have this JSON payload:
[
{
"Id": "6812",
"status": "Available",
"expirationDate": "2024-04-30T13:00:00.000-07:00&...
- 1
0
votes
2
answers
534
views
How to create pipe delimited csv file in multipart form data in dataweave
Facing difficulty to create pipe delimited csv file in multipart form data in dataweave
I am trying to send a csv file with pipe("|") separated value to an api as multipart form data. But ...
0
votes
1
answer
155
views
Generating an Array based on a total Count and split Number
I am trying to generate an array like below using dataweave with two dynamic input i.e totalCount=1000 and splitNumber=100 in mule . I am able to do the same in Java script but not sure how to achieve ...
0
votes
1
answer
292
views
count unique object key in mule 4 dataweave
My requirement to count the unique Error message and it's count dynamically. Below I've added the input payload and the expected output. Please help to provide data weave for that.
Input:
[
{
...
- 225
0
votes
2
answers
602
views
Trying to print only the numbers/Id's in the object using dataweave, can someone take a look?
Input:
[
{
"name": "TOOL: 5237"
},
{
"name": "DMP: 213213 RENTAL"
},
{
"name": "SMG: 23434-A"
}
]
This is my Input ,...
- 1