JSON formatting rules - help please

[iamgigglz]

Here's my current structure:

Spoiler: My Code

[CODE lang="json" title="My format"]{
"Showroom": {
"Address": "1 Car Lane",
"Owner": "Fred",
"Cars": [
{
"Make": "Ford",
"Model": "Figo"
},
{
"Make": "Renault",
"Model": "Duster"
}
]
}
}[/CODE]

This client I'm working for wants this:

Spoiler: Their Code

[CODE lang="json" title="Their format" highlight="7, 11"]{
"Showroom": {
"Address": "1 Car Lane",
"Owner": "Fred",
"Cars": [
{
"Car":{
"Make": "Ford",
"Model": "Figo"
},
"Car":{
"Make": "Renault",
"Model": "Duster"
}
}
]
}
}[/CODE]

Note lines 7 and 11. They want each element in the array of cars to have the "car" tag. Is that valid JSON formatting?

 

[vinodh]

The "car" tag is seen as a duplication when I run your code through a JSON validator.

 

[thePridge]

Here's my current structure:

Spoiler: My Code

[CODE lang="json" title="My format"]{
"Showroom": {
"Address": "1 Car Lane",
"Owner": "Fred",
"Cars": [
{
"Make": "Ford",
"Model": "Figo"
},
{
"Make": "Renault",
"Model": "Duster"
}
]
}
}[/CODE]

This client I'm working for wants this:

Spoiler: Their Code

[CODE lang="json" title="Their format" highlight="7, 11"]{
"Showroom": {
"Address": "1 Car Lane",
"Owner": "Fred",
"Cars": [
{
"Car":{
"Make": "Ford",
"Model": "Figo"
},
"Car":{
"Make": "Renault",
"Model": "Duster"
}
}
]
}
}[/CODE]

Note lines 7 and 11. They want each element in the array of cars to have the "car" tag. Is that valid JSON formatting?

According to The JSON Validator no. I belive it's valid in XML.
The JSON Validator is very useful

 

[mikewazar]

It just looks -wrong- to me.

 

[D4RK_S0LD13R]

Short answer, No. Duplicate key.
Validate: The JSON Validator

Best I can think of their "correct" JSON is:

{
  "Showroom": {
    "Address": "1 Car Lane",
    "Owner": "Fred",
    "Cars": [
      {
        "Car": {
          "Make": "Ford",
          "Model": "Figo"
        }
      },
      {
        "Car": {
          "Make": "Renault",
          "Model": "Duster"
        }
      }
    ]
  }
}

 

[iamgigglz]

Yeah, I FREAKING thought so! Thank you.
The client I'm working with is HUGE so I gave their devs more credit than was due apparently.

 

[PsyentisT]

Pointless to specify car within cars as nothing else should be in that set other than a cars.
Just more work for themselves, and confusing to work with.

If you want to loop through it you now have to specify:

for car in cars
car_make = car.car.make

instead of:

for car in cars
car_make = car.make

 

[Arclight101]

Did you resolve this issue? Hit me a PM as I have been working with this for quite a while and I might be able to help…

 

[iamgigglz]

Did you resolve this issue? Hit me a PM as I have been working with this for quite a while and I might be able to help…

Yup, resolved thanks.
The client’s devs eventually conceded that what they were asking for was just plain wrong.

 

[Mike_Cosmonaut]

It always amazes me how many devs out there do silly stuff like this :')

 

[thornthunder]

I often see this when they write their own fomratters and not use standard ones ... esp in the php world ... also happens when they throw stuff over GET for the first time in their careers trying to use their own piece of clever code, and can not understand why the space in a varname is falling over ....

 

[Reegz]

Late to the party and the question has already been answered. But adding a 2c comment on the fact that most devs these days couldn't code themselves out of the proverbial brown paper bag.

I've oftentimes thought that I was at fault rather than the big team of Devs only to find that I wasn't the one smoking my socks.

 

[Willan]

This!

Pointless to specify car within cars as nothing else should be in that set other than a cars.
Just more work for themselves, and confusing to work with.

If you want to loop through it you now have to specify:

for car in cars
car_make = car.car.make

instead of:

for car in cars
car_make = car.make

You want to un-abstract your dataset as much as possilbe so it is easier to maintain.