Forum Discussion

peter's avatar
peter
New Contributor III
5 years ago

JSON Formating

Hi

I have a set of data from ServiceNow that use a different header for each record and I would like to flatten this data to a single level. But I am not sure how as each header is different. See the example below;

{
"RITMNumber": "RITM3993",
"number": "SCTASK8011",
  "RITM3993": {
  "requested_for": "Pal",
  "location": "Home"

},
{
“RITMNumber”: “RITM3791”,
“number”: “SCTASK7217”,
“RITM3791”: {
“requested_for”: “Bob”,
“location”: “Work”
}
I would like, i.e. lose the headers RITM3993, RITM3791,…

{
"RITMNumber": "RITM3993",
"number": "SCTASK8011",
"requested_for": "Pal",
"location": "Home"

},
{
“RITMNumber”: “RITM3791”,
“number”: “SCTASK7217”,
“requested_for”: “Bob”,
“location”: “Work”
}

Any help much appreciated.