Posts

Dataweave 2.0 update function

Image
  Update the user data below. Usernames should be all lower case and the street should be   "Fiskargatan" (example from dataweave tutorial from mulesoft) Input payload { "username": "WASP", "name": "Lisbeth", "surname": "Salander", "location": { "address": { "street": "Lundagatan", "number": 9 }, "city": "Stockholm", "country": "Sweden" } } Dataweave Transformation %dw 2.0 import * from dw :: util :: Values output json --- payload update "username" with lower($) update [ "location" , "address" , field( "street" )] with "Fiskargatan" output { "username" : "wasp" , "name" : "Lisbeth" , "surname" : "Salander" , "location" : { "address&
Post a Comment
Read more

Dataweave 2.0 - Pluck

Image
 Pluck is useful converting HashMap/Object into array of Objects.  pluck  iterates over an object and returns an array of keys, values, or indices from the object.
Post a Comment
Read more

Dataweave 2.0(2.7) - typeOf

Image
 How to determine if the variable or payload type is String, Array, Number , Boolean or Object  using typeOf Object: String Number: Boolean: Array:
Post a Comment
Read more

Mule4 - Resolving Database Date and DateTime Type Error while Inserting.

Let's see how to resolve error while inserting database date and datatime errors in Mule4 while inserting data into database. Column Declared as Date in database for the table example as follows: TRANDATE DATE DEFAULT '1970-01-01' NOT NULL, Dataweave : ( assuming the incoming  billing_date is coming as DateTime( example: "2024-02-06T11:02:05.237Z") and converting to Date in String format "yyyy-MM-dd" %dw 2.0 output application/json --- "billing_date": $.billing_date as DateTime {format: "yyyy-MM-dd'T'HH:mm:ss.SSSX"} as String {format : "yyyy-MM-dd"} , to convert RAML datetime type DB date time %dw 2.0 output application/json --- "date_updated" : $.date_updated as DateTime {         format : "yyyy-MM-dd'T'HH:mm:ss.SSSX"     } as DateTime {         format : "yyyy-MM-dd HH:mm:ss"     } error while executing :  "reason": "DB:QUERY_EXECUTION", "message&q
Post a Comment
Read more

error-handler-plugin - Mulesoft Catalyst

 How to publish error-hanlder-plugin from mulesoft catalyst github to anypoint exchange. this artical focus on resolving the following errors while building "error-handler-plugin" . 1." A required class was missing while executing org.mule.tools.maven:mule-maven-plugin:3.5.4:process-sources: org/eclipse/aether/connector/basic/BasicRepositoryConnectorFactory " ( this is due to wrong maven verson, see the mulesoft help article in pre-requisite section) 2.  https://repository.mulesoft.org/nexus-ee/content/repositories/releases-ee/ ): Not authorized , ReasonPhrase:Unauthorized. ( this issue is due to wrong or no credentials configured related to mulesoft enterprise nexus repo credentials ). 3.  ERROR] Failed to execute goal org.mule.runtime.plugins:mule-extensions-maven-plugin:1.4.1:extension-model (default-extension-model) on project api-error-handler: Execution default-extension-model of goal org.mule.runtime.plugins:mule-extensions-maven-plugin:1.4.1:extension-model
Post a Comment
Read more

Salesforce Certified Mulesoft Developer-Level1

Image
  I have passed my Salesforce Certified Mulesoft Developer -Level1 in Jul 2022, here is my scores and certificate.
Post a Comment
Read more

Salesforce Certified MuleSoft Platform Architect - Level1 - Reference Notes

Image
 I have passed my "Salesforce Certified Mulesoft Platform Architect - Level1" on 4th Dec 2022 and would like to share the reference study notes with Mulesoft community. Here is my certificate My Score in the exam My study reference material Topic/chapter wise. Once Reference links are completed, strongly recommend taking free practice exam from mulesoft @  https://training.mulesoft.com/certification/architect-platform-level1/practice-exam practice this exam until you get all correct answers and why they are correct by referring to mulesoft documentation and based on your experience. Please leave a comment if you want me to add any references that would help or links that are broken. Explaining application network basics  https://blogs.mulesoft.com/learn-apis/api-led-connectivity/what-is-api-led-connectivity/ https://www.mulesoft.com/resources/api/what-is-full-lifecycle-api-management . https://docs.mulesoft.com/monitoring/ https://www.infomentum.com/mulesoft-plain-language
Post a Comment
Read more