How to do a XML to JSON mapping

omkar-vilas_a_kandekar — Tue, 30 Jan 2024 14:50:19 GMT

I am trying to post the User's bulk data into IAS system. limitations is that IAS system accepts data only in JSON format. I am trying to map the following XML to JSON in CPI message mapping. Following is my source structure.

<Employees> <Employee> <displayName>John Smith</displayName> <firstName>John</firstName> <lastName>Smith</lastName> <managerName>abc def</managerName> <managerEmail>abc@gmail.com</managerEmail> <managerSCIMID>f7acd9a7-03c5-4a94-a432-5ae5e0b3068b</managerSCIMID> <mobilePhone>+91 1234567890</mobilePhone> <email>john.smith@example.com</email> <SAMAccountName>john.smith@example.com</SAMAccountName> <userPrincipalName>johnsmith</userPrincipalName> </Employee> <Employee> <displayName>George Adams</displayName> <firstName>George</firstName> <lastName>Adams</lastName> <managerName>pqr uvw</managerName> <managerEmail>pqr@gmail.com</managerEmail> <managerSCIMID>3f5fe8f9-1e4a-4253-ae1e-b096272e7d2b</managerSCIMID> <mobilePhone>+91 2345678901</mobilePhone> <email>georgeadams@example.com</email> <SAMAccountName>georgeadams@example.com</SAMAccountName> <userPrincipalName>georgeadams</userPrincipalName> </Employee> <Employee> <displayName>Jessica Grey</displayName> <firstName>Jessica</firstName> <lastName>Grey</lastName> <managerName>pqr uvw</managerName> <managerEmail>pqr@gmail.com</managerEmail> <managerSCIMID>f7acd9a7-03c5-4a94-a432-5ae5e0b3068b</managerSCIMID> <mobilePhone>+91 3456789012</mobilePhone> <email>jessicagrey@example.com</email> <SAMAccountName>jessicagrey@example.com</SAMAccountName> <userPrincipalName>jessicagrey</userPrincipalName> </Employee> </Employees>

My target structure looks as:

{ "schemas": [ "urn:ietf:params:scim:api:messages:2.0:BulkRequest" ], "Operations": [ { "method": "POST", "bulkId": "4ecf320f-7bfe-4f8b-91dc-f8f52322d713", "path": "/Users", "data": { "schemas": [ "urn:ietf:params:scim:schemas:core:2.0:User", "urn:ietf:params:scim:schemas:extension:enterprise:2.0:User" ], "userName": "johnsmith", "name": { "familyName": "Smith", "givenName": "John" }, "displayName": "John Smith", "active": true, "emails": [ { "value": "john.smith@example.com", "primary": true, "type": "home" } ], "phoneNumbers": [ { "value": "333-333-3333", "primary": true, "type": "work" } ], "urn:ietf:params:scim:schemas:extension:enterprise:2.0:User": { "manager": { "value": "f7acd9a7-03c5-4a94-a432-5ae5e0b3068b" } } } }, { "method": "POST", "bulkId": "11020828-2bc8-45c4-876b-e32b6259fafc", "path": "/Users", "data": { "schemas": [ "urn:ietf:params:scim:schemas:core:2.0:User", "urn:ietf:params:scim:schemas:extension:enterprise:2.0:User" ], "userName": "georgeadams", "name": { "familyName": "Adams", "givenName": "George" }, "displayName": "George Adams", "active": true, "emails": [ { "value": "georgeadams@example.com", "primary": true, "type": "home" } ], "phoneNumbers": [ { "value": "444-444-4444", "primary": true, "type": "work" } ], "urn:ietf:params:scim:schemas:extension:enterprise:2.0:User": { "manager": { "value": "f7acd9a7-03c5-4a94-a432-5ae5e0b3068b" } } } }, { "method": "POST", "bulkId": "52b3e095-62c2-4baf-8c0f-106a555537ff", "path": "/Users", "data": { "schemas": [ "urn:ietf:params:scim:schemas:core:2.0:User", "urn:ietf:params:scim:schemas:extension:enterprise:2.0:User" ], "userName": "jessicagrey", "name": { "familyName": "Grey", "givenName": "Jessica" }, "displayName": "Jessica Grey", "active": true, "emails": [ { "value": "jessicagrey@example.com", "primary": true, "type": "home" } ], "phoneNumbers": [ { "value": "555-555-5555", "primary": true, "type": "work" } ], "urn:ietf:params:scim:schemas:extension:enterprise:2.0:User": { "manager": { "value": "f7acd9a7-03c5-4a94-a432-5ae5e0b3068b" } } } } ] }

I've tried the JSON mapping approach on the blog : blog for JSON mapping

After uploading JSON file in message mapping from business accelerator hub: Business Accelerator hub it is showing no data.

Because of the schemas fields I can not perform XML to XML mapping.

What should I do for XML to JSON conversion?

Re: How to do a XML to JSON mapping

MetehanSoylu1 — Fri, 11 Oct 2024 06:41:58 GMT

This is because your json schema is missing some elements, try this one;

Re: How to do a XML to JSON mapping

MetehanSoylu1 — Fri, 11 Oct 2024 06:42:47 GMT

{ "openapi": "3.0.0", "info": { "title": "Employee API", "version": "1.0.0" }, "paths": { "/employees": { "get": { "summary": "Get list of employees", "responses": { "200": { "description": "A list of employees", "content": { "application/json": { "schema": { "$ref": "#/components/schemas/Employees" } } } } } } } }, "components": { "schemas": { "Employees": { "type": "object", "properties": { "Employee": { "type": "array", "items": { "type": "object", "properties": { "displayName": { "type": "string" }, "firstName": { "type": "string" }, "lastName": { "type": "string" }, "managerName": { "type": "string" }, "managerEmail": { "type": "string", "format": "email" }, "managerSCIMID": { "type": "string", "format": "uuid" }, "mobilePhone": { "type": "string" }, "email": { "type": "string", "format": "email" }, "SAMAccountName": { "type": "string" }, "userPrincipalName": { "type": "string" } } } } } } } } }

Question Re: How to do a XML to JSON mapping in Technology Q&A

How to do a XML to JSON mapping

Re: How to do a XML to JSON mapping

Re: How to do a XML to JSON mapping