AnsweredAssumed Answered

JSON split

Question asked by i.dudnik091901 on Sep 28, 2017
Latest reply on Feb 26, 2018 by sgurram.ct847009

Hello! I have a problem with splitting json document. My json file looks like that: 

{
"objects": {
"Name1": {
"tariffs": [
{
"id_tariff": 22021,
}
],
"firstname": "Andrew",
"lastname": "Smith",
"agency": {
"id": 1,
},
"phones": [
],
"user_rights": [
],
"town": {
"id": 4,
"title": "Moscow",
},
"is_full_registration": true,
"photo": null
},

"Name2": {
"tariffs": [
{
"id_tariff": 22021,
}
],
"firstname": "John",
"lastname": "Galt",
"agency": {
"id": 1,
},
"phones": [
],
"user_rights": [
],
"town": {
"id": 4,
"title": "Moscow",
},
"is_full_registration": true,
"photo": null
}
},
"total": 2,
"more": false
}

 

Object "objects" contains  objects Name1, Name2 and so, which have different names, but absolutely the same structure. The number of such objects and their name is not known in advance. 

I need to split this document by objects Name1, Name2, but my json profile contains only Name1, Name2 objects. What to do if appears new, for example, Name3 objects? How can I change the profile so that it does not depend on the name of the objects?

Import profile look like this:

Outcomes