1,371 questions
0
votes
0
answers
144
views
Where do I find the redirect URL that UIPath needs when using UIPath connector in MuleSoft?
I am using the UIPath connector which is a certified connector so Mulesoft does not provide support for it or have documentation for. UIPath said I need to ask MuleSoft support the the redirect URL ...
- 1
2
votes
3
answers
232
views
Get excel file from CloudHub Mulesoft
My issue is I already deploy a project in cloudhub. The flow will transform a payload into excel format and the excel file will be in the path I set.
I understand the path for local and cloudhub is ...
- 27
1
vote
1
answer
257
views
Get XML payload size in MB
I need to check the size of incoming payload that is in the XML format in MB. And if size is over certain MB (example 50 MB) I need to route the flows using choice router. I have issues checking the ...
- 33
0
votes
1
answer
483
views
Consuming payload with multipart/mixed Content-Type in Mule 4
I have to send a multipart/mixed request to an external API and I've built a Mule 4 flow in which an endpoint is configured to receive multipart/mixed payload. The endpoint I created should accept a ...
- 435
1
vote
4
answers
8k
views
Convert to proper dateTime format - dataweave
I have a request coming as below format
{
"updatedTime": "Mon Mar 14 15:34:47 NZDT 2022"
}
The response should be converted to "yyyy-MM-dd'T'HH:mm:ss"
{
"...
- 1,503
1
vote
1
answer
536
views
Munit suit failed when trying to build using Maven in the command prompt (DynamicEvaluateProcessor)
I have a problem when build Mule application outside anypoint studio using mvn clean test in command prompt
when i execute the command I got the error:
Message : Error creating bean with ...
- 11
0
votes
1
answer
148
views
Mulesoft Dataweave: Flatten a JSON to create database records
I work with Mule 4, DataWeave 2.3.
I want to flatten a JSON object. Every key in the JSON should be in the key of the new record object. When the JSON has nested objects/arrays then the keys are ...
- 762
0
votes
2
answers
516
views
How to pass a path param / uri param from Mule 4 to SFDC via APEX call?
I am migrating an existing Mule 3 application to Mule 4
Mule 3 is making an APEX GET call and passing a path param / uri param as well as a query param
Here is the source code for Mule 3:
<sfdc:...
- 49
0
votes
0
answers
90
views
Dataweave to VM queue takes unexpectedly long time
We are pulling records from salesforce and at the max it could be 1 million. We are creating flatfile from the payload and pushing to the VM queue.
If the record size is small like 5K then pushing to ...
0
votes
1
answer
144
views
How to read Java object after anypoint MQ subscriber
I am publishing the simple java payload into the anypointMQ publisher.
Input payload to anypointMQ publisher
%dw 2.0
output application/java
---
{
key1 : "value1" ,
key2 : "value2"
...
- 37
0
votes
1
answer
288
views
How to continuously iterate in multiple arrays in mule dataweave?
The ask here is, when we use map function over an array, it iterated the # of times the total objects present, we use $$ for iteration count, now after each object iteration, the $$ gets reset to 0, ...
1
vote
1
answer
913
views
My mock is not returning the payload I want (mock response), it is returning the real payload
I´m developing a munit test but It is failing, because when it makes a call to another api, it is expecting a new Id, but for the test I cannot make several new Ids, as I understand this is a ...
- 11
0
votes
1
answer
149
views
How to avoid repeating headers while writing file in batch job?
I am querying salesforce object and creating a flatfile. Header are getting repeated while writing it to a file in the batch step.
<scheduler doc:name="Scheduler" doc:id="09f2a42a-...
0
votes
1
answer
596
views
define xml payload in transform message or set payload in mule 4
I need to define the below payload in transform message to send to different system but while adding in transform message or set payload component it's giving error.
Please let me know how i can ...
- 225
0
votes
1
answer
605
views
How to avoid error log while using on error continue in mule-4
I am polling on JMS queue using JMS consume component in mule-4. when there are no message in queue it is printing
error log. I want avoid the error log. can you some suggest how can we acheive this ...
- 226
1
vote
1
answer
554
views
How to generate a csv with a double pipe delimiter?
I want to generate a CSV output based on "||" as separator. I tried concatenation and other different approaches but I'm not able to achieve the desired output.
Input payload:
[
{
...
- 57
3
votes
6
answers
1k
views
MuleSoft Dataweave reduce
I try to get my head around the reduce function in Mulesoft Dataweave 2.0.
expected outcome:
{
"dev": "1",
"test": "2",
"uat": "3",
...
- 762
0
votes
1
answer
2k
views
Make HTTPS GET request using http connector in Mule with SSL certificates
I have .crt and privatekey.pem keys which can be used for making HTTPS GET API request.
We can't use these certificates directly in mulesoft for making https API requests.
As far I know it supports ...
- 212
-1
votes
1
answer
98
views
Mule 4 trying to initialise a spring based H2 datasource in Munit - getting ClassNotFoundException
I am trying to write a Munit in Mule 4 where in Munit I want to use a Spring based H2 datasource
So I have the following defined in my Munit class :
<munit:config name="munit-test-config.xml&...
0
votes
1
answer
815
views
How to convert JSON to BLOB using Dataweave?
I need to convert the incoming JSON Object to BLOB to insert it in the oracle DB?
How can I do this? I have tried with the below code but it is throwing Invalid Column Type
%dw 2.0
import * from dw::...
- 115
1
vote
1
answer
167
views
XML processing getting different in result in DataWeave playground and Vscode vs Anypoint Studio/Mule runtime
I am processing an XML document (which is HTML with text and elements nested).
Using the following script, Dataweave playground and VScode extension output the correct order of the text/elements:
%dw ...
-2
votes
1
answer
1k
views
Bearer Token on HTTP Request
I try to replace the token with a variable so that i dont need to hardcode the token but it seems I cant do it.
and this is the output from postman
`"You called the function '+' with these ...
- 27
3
votes
2
answers
670
views
Error(500) While Publishing the JSON Payload by Mule Anypoint MQ Publish component ( Mule 4)
Error Message while publishing a JSON payload with the Publish operation of the Anypoint MQ connector:
"Failed to publish message to destination 'ABC-queue': An error occurred while executing the ...
0
votes
1
answer
155
views
How can I segregate the csv file data and write it to different files?
My input is a csv file containing below data
ID,Name,ContactNo,CompName,Department
101,Angel,0000000000,XYZ Org,HR
102,Melinda,0000000000,XYZ Org,Accounts
103,Jack,0000000000,XYZ Org,HR
104,Ron,...
- 3
0
votes
2
answers
781
views
Mule 4 Object store and caching - need to store records from Db in cache and then use them from cache - is it possible?
This is a follow up question to an earlier one asked
So using Mule cache , can I refresh the underlying object store ( used by Mule cache ) so that periodically I can retrieve the data from database ...
- 49
0
votes
2
answers
82
views
Converting "2024-01-10T10:50:16.901-0500" timestamp to "2024-01-10T10:50:16.901Z" in DWL 2.0/Mule4
I have a variable in Mule4 defined as receiptDateTime which has the following value:
output application/json
---
vars.receiptDateTime
The current output format of the vars.receiptDateTime is "...
0
votes
3
answers
658
views
how to make an exception for dataweave 2.0 functions skipNullOn and isEmpty()?
I am trying to figure out how to resolve next issue: I have an array of objects which are pretty similar, but say one of the objects can have additional field. As a result of map function I need to ...
- 3
0
votes
2
answers
177
views
Combine Result of flatten Function
How can I combine the result of a flatten function in Dataweave? I have the following payload:
[
{
"a": "hello"
},
{
"b": "please"
},
{
&...
1
vote
0
answers
468
views
Mule 4 database connector taking more time to execute a stored procedure
I am trying to create a simple flow where i need to execute a procedure and return the data to a client application via mule. The flow is build in mule4 , but unfortunately the database connector(1....
- 139
0
votes
1
answer
101
views
Dataweave is not creating only one record instead of 4
I want to create 4 records per object from the payload shown below.
Each key has it own mapping which is an integer (ASC__c,CDF23__c,Option_Set__c,Statement_Message_ID__c) which is going to be the &...
3
votes
4
answers
6k
views
Getting error "Unsupported class file major version 61" trying to start Mule 4.4 in Windows
When double-clicking on mule.bat I get the following error message.
Error message:
Caught: BUG! exception in phase 'semantic analysis' in source unit 'C:\NihaMule\mule-ee-distribution-standalone-4.4.0\...
1
vote
0
answers
286
views
Anypoint Studio OJDBC (Oracle ODBC) Connector Issues
I'm very new to MuleSoft and so far I have used the standard Salesforce and NetSuite connectors to create simple flows.
I have been trying to configure the OJDBC driver to enable direct NetSuite ...
- 11
0
votes
1
answer
282
views
How to lookup for a value within multiple key values pairs
I have an array of objects which contains products ID and product name after they were created, but the array may contains the products that were not created successfully and it returns the original ...
- 1
0
votes
1
answer
597
views
Configuring Mule Microsoft Power BI connector using OAUTH
I'm trying to connect to Microsoft Power BI using the Mule Power BI connector but the connector configuration is very confusing with respect to OAuth. Has anyone successfully connected to Power BI ...
0
votes
1
answer
473
views
How to update an existing object having multiple key value pairs dynamically?
I have two Json structures.
Input 1 has the structure of the response that needs to be created :
{
"Chats": {
"customerContact": "",
"reply": &...
- 191
0
votes
1
answer
1k
views
How to fetch large number of records from Snowflake from Mule 4 API
I am new to Mulesoft and have a requirement to connect to Snowflake and fetch records do little bit of mapping and update them to another system.
The queries take person id, last modified date, date ...
- 77
0
votes
0
answers
3k
views
Mule 4 - OAuth authorization dance not yet performed for resourceOwnerId in Sharepoint Connector
I am using Sharepoint Connector in Mule 4 to get file content using OAuth 2.0.
Under Azure AD I registered a new app and perform the following steps:
Got my Client (Application) Id
Got my App Id URI
...
- 1,203
0
votes
1
answer
305
views
Mule 4 failsDeployment when set to true is not failing deployment
We are using Mule 4. I was trying to fail the deployment when the connection check fails on http connectors and mule api connectors. I read somewhere that this will not work work in mule 4 with <...
- 21
0
votes
0
answers
391
views
Unable to set the attribute userAccountControl to 512 on Active Directory using mule4 LDAP connector
I´m trying to replicate the creation of a new user using MuleSoft LDAP connector.
When I create a user manually on Active Directory, the attribute "userAccountControl" is set to the value ...
0
votes
1
answer
855
views
how to read all file names from S3 Bucket using Mule 4?
I have a requirement where I need to list down only file names from S3 Bucket.
I have tried a simple POC where I used "list Objects" connector of mule 4 and configured with my bucket and ...
- 930
0
votes
1
answer
2k
views
JSON Validator not validating the schema in Mule
I am have a following JSON schema which I am trying to validate using JSON Schema validator
JSON Schema:
{
"$schema": "http://json-schema.org/draft-07schema#",
"...
- 111
2
votes
2
answers
226
views
How to truncate DateTime to minutes in DW?
Looking for a way to truncate a timestamp DateTime value (e.g. result of now()) to minutes with preserving the time zone i.e. something like this:
From: |2023-10-04T10:48:07.975905Z|
To: |2023-10-...
- 2,911
2
votes
1
answer
1k
views
Mule 4 attributes.maskedRequestPath expected behaviour
The documentation says:
Path computed from masking the listenerPath and taking the difference. Note that this is only calculated when the null otherwise.
It seems this sentence is not complete so I ...
- 61
0
votes
1
answer
104
views
Mule 4 - Look for a value in json and derive corresponding jsons value
Here I need look for a value1 (color/size) in my json arrayObject and map to value2 (yellow/28 inch) of same json array object in mule 4 dataweave. Below is my json input
Kindly note ...
- 45
0
votes
1
answer
501
views
How to print a tag in mule 4 only if exists a value?
I have this code for print a json result, the problem is that I need only tags with data.
Example :
'dateOfBirth':
if(payload.ns0#Report_Data.ns0#Report_Entry.ns0#dateOfBirth != null)
(payload.ns0#...
- 13
0
votes
1
answer
157
views
Mule 4 Getting Database Connection in Java Code
In Mule 3, I can get the database connection using the following Java code snippet:
StaticDbConfigResolver staticDBConfig = org.mule.RequestContext.getEventContext().getMuleContext().getRegistry()....
0
votes
1
answer
853
views
How to convert JSON String to JSON in Mule 4?
I am trying to convert below json String to JSON using Dataweave.
"{\n \"request\": {\n \"req\": {\n \"trans\": null,\n \"search\": null,\n ...
0
votes
0
answers
164
views
resumed batch jobs get stuck
I have the problem that I cannot
resume stopped batch jobs with my custom connector.
After executing the resume(),
only the status changes to 'EXECUTING' and I get the console log that my batch job ...
- 1
0
votes
1
answer
485
views
Read XML with namespace in dataweave
I am trying to read an xml and put if else conditions on a certain tag. If data exists, I need to print true otherwise false. Below is the sample XML that I am trying to read:
<?xml version='1.0' ...
- 33
3
votes
2
answers
5k
views
How to assign value to a local variable in function in DataWeave
Hi i am getting an error saying Invalid input ' ', expected '}' for the do block. I am trying to create a concatenated String output
fun getStreetAddress(address1 ,address2) =
do {
var addr1 = ...
- 668