How parse this api response

Queries and Resources
1

hi how i can parse this response from api rest to a table in retool?

{
  "observacion": {
    "fecha_actualiza": null,
    "fechaproxima_llamada": null,
    "id": 42,
    "idclave_nombre": "AANANKHA 25-05-22-AZ",
    "motivo": "?",
    "observacion": "HABLE CN ROGELIO ESTA EN ORDEN, DICE QUE LA IVA A MANDAR A RET. HOY",
    "usuario": "YS"
  },
  "status": "success"
}

i tried {{ query2.data.observacion }} but shows this error:

Value given is empty

any tip? @ScottR @bradlymathews @Tess @victoria

thank you

2

You could do that but in the table surround it with [ and ]

Even though I used a transformer you may not need to...

Screenshot 2023-12-27 at 11.54.27 AM
Screenshot 2023-12-27 at 11.54.27 AM1593×808 98.7 KB

2 Likes
3

Works the same way through a jsQuery but as Scott said you likely just need to bracket [] the value in the data source.

[{{query2.data.observacion}}]

1 Like