Best regards, gentlemen.

If anyone can help me with this issue, I would appreciate it. I want to generate a json with JsonGenerator (I don't know if it is the correct tool), which contains an array of data, and I require guidance.

this is my code for the moment

JsonGenerator lnv_JsonGenerator
string ls_Json
Long ll_RootObject
Long ll_ChildObject

lnv_JsonGenerator = create JsonGenerator

// Create an object root item
ll_RootObject = lnv_JsonGenerator.CreateJsonObject()


dw_transaccion.settransobject(sqlca)
dw_transaccion.retrieve(idDocumento)

if dw_transaccion.rowcount() <> 1 then
Messagebox("Terrasoft - Mensaje","Error al generar Datos relativos a la transacción : Valor de registros " + string(dw_transaccion.rowcount()),stopsign!)
return 0
end if;

dw_transaccion.accepttext( )

numDocumentoldObligadoValue = dw_transaccion.object.ips_numdocumentoldobligado[1]
numFacturaValue = dw_transaccion.object.vfct_gestion_documentos_numfactura[1]

lnv_JsonGenerator.additemstring(ll_RootObject,numDocumentoldObligadoLabel,numDocumentoldObligadoValue)
lnv_JsonGenerator.additemstring(ll_RootObject,numFacturaLabel,numFacturaValue)
setnull(TipoNotaLabelValue)
lnv_JsonGenerator.additemnull(ll_RootObject, TipoNotaLabel)
setnull(numNotaValue)
lnv_JsonGenerator.additemnull(ll_RootObject,numNotaLabel)

ls_Json = lnv_JsonGenerator.GetJsonString()

destroy lnv_JsonGenerator

This generates that json, which is correct.

{
    "numDocumentoldObligado": "9002319816",
    "numFactura": "FVD243",
    "numNota": null,
    "TipoNota": null
}

What I need now is to be able to use a datawindow that contains the list of clients with their properties, and add that arrangement to the json, as follows:

{
	"numDocumentoldObligado": "9002319816",
    "numFactura": "FVD243",
    "numNota": null,
    "TipoNota": null,
    "clients": [
        {
            "birthDate": "2000-01-01 08:10",
            "codCountry": "170",
            "codSexo": "M",
            "codZonaTerritorialResidencia": "01",
            "consec": 1,
            "id": "52100200",
            "nameClient": "William Romero"
        },
        {
            "birthDate": "2000-01-01 08:10",
            "codCountry": "171",
            "codSexo": "F",
            "codZonaTerritorialResidencia": "01",
            "consec": 1,
            "id": "5545654",
            "nameClient": "Maria Romero"
        }
    ]

}

I bring the data from a data window, and I go through the data window with a for loop to obtain the customer data.

My question is how do I build that array and add the data to the json?

I appreciate your great help.