1. Andres Slachevsky
  2. PowerBuilder
  3. Friday, 4 November 2022 11:09 AM UTC

Hello All
i need to Export a Datawindow to a Json

the issue is that the the items have Upper and Lower case  like :

codigoDepartamentoReceptor or fechaHora

when i create the datawindow the name are always change to all lowercase

i did try to use the XML template but it have no effects

it is posible to do it in PB2017 R3?

 

this is an small example

{
"codigo": "7840058000019",
"cantidad": 5,
"unidadMedida": "77",
"descripcion": "Producto de Prueba UND IVA 10%",
"precioUnitario": 5500,
"importeItems": 27500,
"porcentajeDescuento": 0,
"importeDescItems": 0,
"totalDescuentoItems": 0,
"tasaImpuesto": "10",
"gravado10": 25000,
"iva10": 2500,
"gravado5": 0,
"iva5": 0,
"exento": 0,
"total": 27500
}

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 4 November 2022 14:21 PM UTC
  2. PowerBuilder
  3. # 1

Hi Jason;

  You would need to use the JSONGenerator object class for that functionality.

You could also do it using the DWO but then would need to perform a global replace of all the names to get the case corrected.

Note that the DWO only supports XML templates currently.

Regards ... Chris

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.