merge 3 json with condition

Question

I have 3 inputs a = [{"SalesforceId":"02i2C000002PRMpQAO", "ExternalId":"10000502"}, {"SalesforceId":"02i2C000002PRMqQAO", "ExternalId":"10000501"}] , b = [ { "Result": { "errors": "", "id": "02i2C000002PRMpQAO", "success": "true", "created": "true" } }, { "Result": { "errors": "", "id": "02i2C000002PRMqQAO", "success": "true", "created": "false" } } ] , c = [{ "name": "GMC", "subscriptionId": "10000501", } ,{ "name": "BUIC", "subscriptionId": "10000502", }] where c.subscriptionId = a.ExternalId and b.id = a.SalesforceId required output -

output -

 output -
 [
   {
     "success": "true",
     "created": "true"
     "JSON": {
     "name": "BUIC",
     "subscriptionId": "10000502",
     }
   },
   {
     "success": "true",
     "created": "false"
     "JSON": {
     "name": "GMC",
     "subscriptionId": "10000501",
     }
   }
 ]

How do I achieve this in dataweave or mule in general ?

Answer 1

I got the result by using function for 3rd json - %dw 1.0 %output application/json %function grab(subscriptionId){ (c[?($.subscriptionId == subscriptionId)]) }
%var a = [{"SalesforceId":"02i2C000002PRMpQAO", "ExternalId":"10000502"}, {"SalesforceId":"02i2C000002PRMqQAO", "ExternalId":"10000501"}]

 %var b = [
 {
     "Result": {
       "errors": "",
       "id": "02i2C000002PRMpQAO",
       "success": "true",
       "created": "true"
     }
   },
   {
     "Result": {
       "errors": "",
       "id": "02i2C000002PRMqQAO",
       "success": "true",
       "created": "false"
     }
   }
 ]
 
 %var c = [{
     "name": "GMC",
     "subscriptionId": "10000501"
     },
 {
     "name": "BUIC",
     "subscriptionId": "10000502"
     }]
 
 ---
 b map ((payload1 , indexOfPayload1) -> {
 success: payload1.Result.success,
 created : payload1.Result.created,
 (a filter ($.SalesforceId == payload1.Result.id)  map ((variable2 , indexOfVariable2) -> {
 ExternalId: variable2.ExternalId,
 JSON : grab(variable2.ExternalId)
 }))
 })

Answer 2

Sep 07, 2018 at 03:04 PM, soumyajit22 answered with:

@ You can achieve this using groupBy function

 %dw 1.0
 %output application/json
 %var a = [{"SalesforceId":"02i2C000002PRMpQAO", "ExternalId":"10000502"}, {"SalesforceId":"02i2C000002PRMqQAO", "ExternalId":"10000501"}] groupBy $.ExternalId
 %var b = [ { "Result": { "errors": "", "id": "02i2C000002PRMpQAO", "success": "true", "created": "true" } }, { "Result": { "errors": "", "id": "02i2C000002PRMqQAO", "success": "true", "created": "false" } } ] groupBy $.Result.id
 %var c = [{ "name": "GMC", "subscriptionId": "10000501" } ,{ "name": "BUIC", "subscriptionId": "10000502" }]
 ---
 c map {
 
     success : b[a[$.subscriptionId].SalesforceId[0]].Result.success[0],
     created : b[a[$.subscriptionId].SalesforceId[0]].Result.created[0],
     "JSON": {
      "name": $.name,
      "subscriptionId": $.subscriptionId
      }
 }

Thanks

Add comment

10 |1200 characters needed characters left characters exceeded

Answer 3

Sep 07, 2018 at 03:19 PM, vijaykumar63 answered with:

@soumyajit22 thanks for your reply , but I was getting some null values

 [
   {
     "success": null,
     "created": null,
     "JSON": {
       "name": "GMC",
       "subscriptionId": "10000501"
     }
   },
   {
     "success": null,
     "created": null,
     "JSON": {
       "name": "BUIC",
       "subscriptionId": "10000502"
     }
   }
 ]

Add comment

10 |1200 characters needed characters left characters exceeded

Answer 4

Sep 07, 2018 at 03:26 PM, soumyajit22 answered with:

@vijaykumar63 Strange. It is working for me. See the screenshot below

alt text

screen-shot-2018-09-07-at-112541-am.png (177.6 kB)

Add comment

10 |1200 characters needed characters left characters exceeded

Answer 5

Sep 07, 2018 at 03:46 PM, vijaykumar63 answered with:

@soumyajit22 ok, may be issue from my end. Thanks for your answer, appreciate it

Add comment

10 |1200 characters needed characters left characters exceeded

merge 3 json with condition

5 Replies

Your answer

Like this question?

Who's following the question

Related Questions