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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.