AnsweredAssumed Answered

Splitting JSON Messsage of type Absolute Array ?

Question asked by abdur.hameedshaikh202829 on Aug 31, 2018
Latest reply on Aug 31, 2018 by abdur.hameedshaikh202829

I have JSON Message which looks as below.


[{"schemas":["urn:ietf:params:scim:schemas:core:2.0:User","urn:scim:schemas:extension:GlobalAttributes:2.0:User","urn:scim:schemas:extension:ClientAttributes:2.0:User"],"userName":"abc@xyz.com","name":{"familyName":"yyy","givenName":"zzz"},"photos":[{"value":""}],"active":true,"locale":"EN_US","urn:scim:schemas:extension:GlobalAttributes:2.0:User":{"partnerCustomProperties":{"5aaf898de4b01d6d8ad21022":["Available"],"5aaf898be4b01d6d8ad20edd":["Ads Admin","Ads Basic","Ads Manage",],"5aaf8980e4b01d6d8ad2067e":["All Users"],"spr_user_availability_status":["Available"],"5ab8a1f2e4b089e24ff64d88":["Testing Ground"],"5ae9ae8be4b0fd8e036a3f1d":["Testing Ground"],"5aaf898be4b01d6d8ad20ef7":[" - Admin"]},"passwordLoginDisabled":false},"urn:scim:schemas:extension:ClientAttributes:2.0:User":[{"clientId":1000004931,"userType":"PRTADMN","phoneNumbers":[{}],"businessCategory":"CORPORATE"}],"id":"1000064318","meta":{"resourceType":"User","createdTime":"2018-07-11 14:14:47.0","lastModified":"2018-07-13 14:01:35.0"}},{"schemas":["urn:ietf:params:scim:schemas:core:2.0:User","urn:scim:schemas:extension:GlobalAttributes:2.0:User","urn:scim:schemas:extension:ClientAttributes:2.0:User"],"userName":"pqr@stu.com","name":{"familyName":"xxx","givenName":"xx"},"photos":[{"value":""}],"active":true,"locale":"EN_US","urn:scim:schemas:extension:GlobalAttributes:2.0:User":{"partnerCustomProperties":{"5ae9ae8ee4b0fd8e036a3f87":["EU","AP"],"5aaf898de4b01d6d8ad21022":["Available"],"5aaf898be4b01d6d8ad20edd":["All Permissions","Support Tab","System Admin"],"5aaf8980e4b01d6d8ad2067e":["All Users"],"spr_user_availability_status":["Available"],"5ab8a1f2e4b089e24ff64d88":["Testing Ground"],"5aaf8986e4b01d6d8ad20c16":["PMI"],"5ae9ae8be4b0fd8e036a3f1d":["Testing Ground"],"5aaf898be4b01d6d8ad20ef7":[" - Admin"," - Admin"]},"passwordLoginDisabled":false},"urn:scim:schemas:extension:ClientAttributes:2.0:User":[{"clientId":1000004931,"userType":"PRTADMN","phoneNumbers":[{}],"businessCategory":"CORPORATE"}],"id":"1000064570","meta":{"resourceType":"User","createdTime":"2018-08-07 12:11:24.0","lastModified":"2018-08-23 15:09:33.0"}}]

 

Basically it contains user information. As you can see it is starting with Array containing multiple users when imported in Boomi it is creating root element as Array (Absolute). My requirement is to split each user and put in cache so that I can do lookup by username in my subprocess.

I tried using Data Process Split option with many combination and does not work.

I also tried to map to different XML or FlatFile structure and then map but no success it takes always first user.

 

Any idea ?

Outcomes