Servidores Rest

[Neftali [Germán.Estévez]]

Empezado por Neeruu

Alguien ocupo este componente para convertir json en dataset?
Funciona? es recomendable? tienen alguna otra alternativa?

Yo miraría los que vienen con delphi. En especial el TRESTResponseDataSetAdapter.
Lo digo porque el RESTDebugger que viene con delphi, hace exactamente lo que tú estás pidiendo y lo hace con los componentes de delphi.

Si en el RESTDebugger ejecutas un GET que te devuelva datos con esta estructura:

[{"cif":"S7668730J","name":"ORACULACESL","creation_date":"16/06/1992","phonenumber":"937016021","faxnumber":"937016022","email":"[email protected]","municipality": "Reinoso","municipality_inecode":"09310","province":"Burgos","province_inecode":"09","address":"VíaF uente","address_number":"1","address_zipcode":"09710","cnae":"9900","activity":"Actividadesdeorganiz acionesyorganismosextraterritoriales"},{"cif":"F98923642","name":"OXYLEXSA","creation_date":"26/06/1964","phonenumber":"976978765","faxnumber":"976978766","email":"[email protected]","municip ality":"Paderne","municipality_inecode":"15064","province":"Coruña,A","province_inecode":"15","addre ss":"CallejónHorno","address_number":"34","address_zipcode":"15516","cnae":"8424","activity":"Ordenp úblicoyseguridad"}]

Que tiene la misma estructura que tú necesitas:

Código Delphi [-]
[
    {
        "cif": "S7668730J",
        "name": "ORACULACESL",
        "creation_date": "16/06/1992",
        "phonenumber": "937016021",
        "faxnumber": "937016022",
        "email": "[email protected]",
        "municipality": "Reinoso",
        "municipality_inecode": "09310",
        "province": "Burgos",
        "province_inecode": "09",
        "address": "VíaFuente",
        "address_number": "1",
        "address_zipcode": "09710",
        "cnae": "9900",
        "activity": "Actividadesdeorganizacionesyorganismosextraterritoriales"
    },
    {
        "cif": "F98923642",
        "name": "OXYLEXSA",
        "creation_date": "26/06/1964",
        "phonenumber": "976978765",
        "faxnumber": "976978766",
        "email": "[email protected]",
        "municipality": "Paderne",
        "municipality_inecode": "15064",
        "province": "Coruña,A",
        "province_inecode": "15",
        "address": "CallejónHorno",
        "address_number": "34",
        "address_zipcode": "15516",
        "cnae": "8424",
        "activity": "Ordenpúblicoyseguridad"
    }
]

En la pestaña BODY te devuelve el JSON, pero en la pestaña TABULAR DATA, te devuelve los datos en formato TDataset (DBGrid).
Revisa este artículo porque creo que explica lo que necesitas.