JSON Metadata Wizard

One Star

JSON Metadata Wizard

I'm trying to get this json file templated ->
http://aws.amazon.com/ec2/pricing/json/rhel-ri-heavy.json
However when I attempt to walk it through the wizard it gives me this error
"File is not found or the json format is incorrect"
Even though
1) I can't see anything wrong with it
2) I validated it against these two sites ->http://jsonformatter.curiousconcept.com/ & http://jsonlint.com/
Which both say it's valid.
I'm able to reproduce this in 5.3.1 and 5.4 rc1.
Thoughts?
Moderator

Re: JSON Metadata Wizard

Hi,
Could you please paste your json file into forum so that we can take a testing for you.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: JSON Metadata Wizard

The file is longer than the post allows... but here is a snipet.
I use curl to pull it down -> curl http://aws.amazon.com/ec2/pricing/json/rhel-ri-heavy.json >riec2pricing.json
{
"vers": 0.01,
"config": {
"currencies": ,
"valueColumns": ,
"regions":
},
{
"size": "med",
"valueColumns":
},
{
"size": "lg",
"valueColumns":
},
{
"size": "xl",
"valueColumns":
}
],
"type": "stdResI"
},
{
"sizes":
},
{
"size": "xxl",
"valueColumns":
}
],
"type": "secgenstdResI"
},
{
"sizes":
}
],
"type": "uResI"
},
{
"sizes":
},
{
"size": "xxl",
"valueColumns":
},
{
"size": "xxxxl",
"valueColumns":
}
],
"type": "hiMemResI"
},
{
"sizes":
},
{
"size": "xl",
"valueColumns":
}
],
"type": "hiCPUResI"
},
{
"sizes":
},
{
"size": "xxxxxxxxl",
"valueColumns":
}
],
"type": "clusterCompResI"
},
{
"sizes":
}
],
"type": "clusterHiMemResI"
},
{
"sizes":
}
],
"type": "clusterGPUResI"
},
{
"sizes":
}
],
"type": "hiIoResI"
},
{
"sizes":
}
],
"type": "hiStoreResI"
}
]
},
]
}
}
Moderator

Re: JSON Metadata Wizard

Hi,
Sorry for delay.
For the validation process, we are first to convert JSON to XML file and then parsing the XML file.
I have taken a testing for your case, but the issue still repro.
Could you please open a jira issue of DI project on Talend Bug Tracker, our developer will see if there is a workaround.
Note: Please set the issue type as "WorkItem".
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: JSON Metadata Wizard

Is it solved?
One Star

Re: JSON Metadata Wizard

Hi,
I have the same problem with parsing the ":" in the JSON object that i receive.
Example:
{
"dctermsSmiley Tongueublisher": {
"dcterms:identifier": "at.swql.sprint",
"dcterms:title": "Project Lyo"
}
}
The "dctermsSmiley Tongueublisher" for example won't be parsed correctly although it is found between double quotes, so if i changed the JSON to:
{
"dctermspublisher": {
"dctermsidentifier": "at.swql.sprint",
"dctermstitle": "Project Lyo"
}
}
Then it will work properly.