How to convert: Json to xml and xml to hfsql and hfsql in a sql script? - Online repository

ONLINE REPOSITORY
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | | Sign in | English

How to convert: Json to xml and xml to hfsql and hfsql in a sql script?

Published by Boller

in the category Tools

Description

How to convert: Json to xml and xml to hfsql and hfsql in a sql script?

This example lets you convert a Json into an Xml and an Xml into an HFSQL and an HFSQL into an SQL Script

Convert Json to Variant
Read data from a variable of type Variant
Working with Members
Read Membership Registration
Analyze Repeated Tags
Review Empty Tags
Working with arrays
Convert Json to Xml
Convert Xml to HFSQL
Create an HFSQL File
Import Hfsql and Export to SQL Script

---

Como converter: Json para xml e xml para hfsql e hfsql em um script sql ?

Esse exemplo permite converter um Json em Xml e um Xml em um HFSQL e um HFSQL em um Script SQL

Converter Json to Variant
Ler dados de uma variável do tipo Variant
Trabalhar com Members
Ler registro de Members
Analisar Tags repetidas
Analisar Tags vazias
Trabalhar com arrays
Converter Json to Xml
Converter Xml to HFSQL
Criar um Arquivo HFSQL
Importar Hfsql e Exportar para Script SQL

https://forum.PC SOFT.fr/fr-FR/PC SOFT.br.WINDEV/2862-como-converter-json-para-xml-xml-para-hfsql-2863/read.awp

Illustrations, screen shots

User reviews

Write a review

Report abuse

(To evaluate this resource, click 'Write a review')

No review or comment? Be the first one!

Boller

February 06, 2020

use o debug

PersonXml is Variant = JSONToVariant(edt_retorno1)

TotalItens is int = PersonXml.meta.total

x is int = 0
LOOP(TotalItens)
x++
edt_retorno1 += "Medico ID:" + PersonXml.data[x].attributes.medicos_id +CR
edt_retorno1 += "Medico:" + PersonXml.data[x].attributes.nome_medico +CR
edt_retorno1 += "Prescricao ID:" + PersonXml.data[x].attributes.prescricao_editada_id +CR
edt_retorno1 += "Endereco:" + PersonXml.data[x].attributes.endereco_medico +CR
edt_retorno1 += "Cidade:" + PersonXml.data[1].attributes.cidade_medico +CR
edt_retorno1 += "Medico ID:" + PersonXml.data[x].attributes.medicos_id +CR
END

Boller

February 06, 2020

VOU ANALISAR O PROEJTO E CORRIGIR ELE OK BAPTISTE

Baptiste - BLV TECH

May 28, 2018

'Convert Json to Xml' not working for array JSON :

Exemple :
{
"from":"2018-00-05T12:00:00.000",
"abnormal_results":
[
{
"patient":
{
"id":53,
"last_name":"MONTGOMERY BURNS",
"first_name":"Charles",
"birth_name":"0",
"gender":"1",
"birth_date":"1951-00-05",
"cns":"123456"
},
"analysis":
[
{
"dossier":"920703",
"dossier_external_id":"0",
"name":"TCMH (Hb\/GR)",
"value":33.7,
"unit":"pg",
"limit_min":"0",
"limit_max":"0",
"limit_text":"0",
"date":"2017-00-09"
},
{
"dossier":"920703",
"dossier_external_id":"0",
"name":"H\u00e9maties (GR)",
"value":4.45,
"unit":"\/pl",
"limit_min":"0",
"limit_max":"0",
"limit_text":"0",
"date":"2017-00-09"
},
{
"dossier":"920703",
"dossier_external_id":"0",
"name":"VGM (Ht\/GR)",
"value":101.3,
"unit":"fl",
"limit_min":"0",
"limit_max":"0",
"limit_text":"0",
"date":"2017-00-09"
}
]
}
]
}

ABOUT

RATING: