Rest Request JSON File nested

[Sagestum]

Hello everyone,

I'm having an issue with a REST request that returns nested JSON data. I've been trying to split the data using a "Transformer", but it's not working.

Here's an example of the JSON data (with random data placeholders):

Details

{
"objects": {
"lnkhalloTotschuess::27559": {
"code": 0,
"message": "",
"class": "lnkhalloTotschuess",
"key": "27559",
"fields": {
"hallo_id": "2",
"hallo_name": "File1",
"tschuess_id": "100377",
"tschuess_name": "Dinge1",
"tschuess_org_code": "BBB",
"tschuess_id_finalclass_recall": "Bla1"
}
},
"lnkhalloTotschuess::24908": {
"code": 0,
"message": "",
"class": "lnkhalloTotschuess",
"key": "24908",
"fields": {
"hallo_id": "1",
"hallo_name": "File2",
"tschuess_id": "100387",
"tschuess_name": "Dinge2",
"tschuess_org_code": "AAA",
"tschuess_id_finalclass_recall": "Bla2"
}
}
},
"code": 0,
"message": "Found: 11569"
}

And here's the query I've been using with the transformer:

function transform(data) {
  const result = [];
  const objects = data.objects;
  for (const key in objects) {
    const fields = objects[key].fields;
    result.push({
      tschuess_name: fields.tschuess_name,
      tschuess_org_code: fields.tschuess_org_code,
    });
  }
  return { results: result };
}

Unfortunately, this isn't returning any data. Can anyone help me figure out what I'm doing wrong? Thanks in advance!

[ConorWebb96]

Hey @Sagestum,

The main issue here I believe is with your transformer. You don't need to wrap this in a function. Where you are returning results at the end also doesn't need to be done in this way, just return the results.

I've attached screenshots of the whole process from start to finish showing various tabs of the rest area with your rest data.

Fixed transformer

Response

Schema

Preview

Result

This should hopefully fix your issues!

[Sagestum]

Thanks, that helped a log :D

[vikinim]

hi ,
i have tried this code for transformer .
but error " request did not return any data "

my json external api response is -

{
"status": "success",
"data": {
"NSE_EQ:NHPC": {
"last_price": 78.93,
"instrument_token": "NSE_EQ|INE848E01016"
},
"NSE_EQ:ABREL": {
"last_price": 2816.1,
"instrument_token": "NSE_EQ|INE055A01016"
},
"NSE_EQ:1003ISFL28": {
"last_price": 985.85,
"instrument_token": "NSE_EQ|INE413U07269"
},
"NSE_EQ:GS220230C": {
"last_price": 0.0,
"instrument_token": "NSE_EQ|IN000230C028"
},
"NSE_EQ:364D071124": {
"last_price": 98.0,
"instrument_token": "NSE_EQ|IN002023Z349"
},
"NSE_EQ:RENUKA": {
"last_price": 41.43,
"instrument_token": "NSE_EQ|INE087H01022"
},
"NSE_EQ:SABEVENTS": {
"last_price": 16.25,
"instrument_token": "NSE_EQ|INE860T01019"
}
}
}
and i have used -

and error is .

raw data is fine . please guide.