Questions tagged [mule4]

Version 4 of Mule, a lightweight enterprise service bus (ESB) and integration framework provided by MuleSoft

Mule is a lightweight enterprise service bus (ESB) and integration framework provided by MuleSoft. According to the documentation, Version 4 aims at simplifying the expression language and reducing management complexity. This way, it shall be possible to deliver applications faster than in earlier versions of the product.

1166 questions
-1
votes
1 answer

Error Publishing Mule JSON Logger to Anypoint Exchange

I am trying to publish the Mule JSON Logger to my Anypoint Exchange based from the following repo - https://github.com/mulesoft-consulting/json-logger When the execute the deploy-to-exchange.sh script with the ORG ID provided I keep getting Java…
Andy
  • 51
  • 1
  • 8
-1
votes
1 answer

How to extract attributes from an XML using DataWeave

I have a XML like this below and i want to extract the attributes (example: externalid) of it using DataWeave. "
-1
votes
1 answer

Mule 4 - DataWeave - SQL ResultSet to JSON

I'm having trouble converting my SQL ResultSet to JSON format. I'm using a stored procedure flow to bring in the data then I'm using a transform message to convert the output to JSON. SQL Result: resultSet1=[{ProductID=1154526, Qty=-3.0,…
-1
votes
2 answers

Querying data from multiple tables in MuleSoft

I have 3 tables in a database (Records, Works and People) that I need to query and return as JSON. The data looks something like: ID | Record | Work | People _____________________________ 1 | Rec 1 | Work 1 | Mr A 1 | Rec 1 | Work 1 | Mrs A 1 …
DevTC
  • 1
  • 3
-1
votes
1 answer

Mule 4 : Convert nested JSON and load into database (flatten)

I need to convert below nested JSON into flatten and load into database. Nested JSON into Flatten JSON Input: { "Report_Entry": [ { "ContractNumber": "1111111", "Company": "ABCD INC." "Contract_Lines_group": [ { …
Mahari
  • 3
  • 4
-1
votes
2 answers

how to convert a JSON object into a JSON array in Mule 4

Input: { "abc": "xyz", "pqr": "def" } Expected Output: [ { "abc": "xyz", "pqr": "def" } ] Expecting the output mentioned.
soumya
  • 3
  • 2
-1
votes
1 answer

Getting invalid column type while inserting data in to database

I am using database connector to insert data in database in Mule-4 the insert query statement looks like this. I have tested multiple times. below is the sql query using for inserting data INSERT INTO TABLE ( GUID, …
kushma gonna
  • 236
  • 3
  • 19
-1
votes
1 answer

How to archive multiple files in sftp directory and move those files to an other directory?

I have an sftp folder where 200 files will be dropped on daily basis. I need to archive these files and move them to another sftp folder in 1 shot instead of moving 1 file at time. Basically, I want to archive/move the files into a separate folder…
james11
  • 55
  • 6
-1
votes
1 answer

Mule4 Dataweave transformation

I need to transform the below JSON Input :- { "type": "donut", "weight-unit": "lb", "price-unit": "$/lb", "price": 10.75, "batters": { "batter": [ { "id": "10011", "type":…
-1
votes
2 answers

Date conversion in Mule

I am getting the date as below 2022-10-25 11:00:00 which I need to convert to 2022-10-25T11:00:00 Please let me know the appropriate data weave to achieve the above output.
subhash
  • 19
  • 11
-1
votes
1 answer

How to convert array value as number in muleSoft

I am new to Mule and I want to convert below JSON array value type as number when itemType is downloadSpeed. Input { "itemType": "DD-Offer", "id": "DD-1", "items": [ { "itemType": "downloadSpeed", …
Krish
  • 4,166
  • 11
  • 58
  • 110
-1
votes
1 answer

Dataweave dynamic change values

how can be this done if I have string like this. "Processing of job {$jobName} started ${yyyy-MM-dd}" To get "Processing of job test-job started 2022-10-11" Thanks!
Root
  • 1
-1
votes
1 answer

How to get a desired output using groupBy in dataweave?

I'm looking for an output similar to this one below where i want to groupBy costomer and orderid. Input: [ { "item": 621, "orderid": "ON22", "qty": 45.0, "customer": "610", "date": "1988-08-13" }, { "item": 63, "orderid": "ON2234", "qty":…
james11
  • 55
  • 6
-1
votes
1 answer

How to Update Document by id In MongoDB with Mule 4

I am using mule's MongoDB connector to update a document. The element that I am trying to update in this document is a object as shown below, its part of the full document i need just update two field by id. { "_id" : { "$oid":…
-1
votes
1 answer

Transform string to Date

Please I try to convert string to Date in anyoint studio but I get this error in Avanced rest client "Cannot coerce String (22/03/2012) to Date, caused by: Text '22/03/2012' could not be parsed at index 2. please can I some one help me . Thanks…