How to convert: Json to xml and xml to hfsql and hfsql in a sql script? |
|
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 |
|
|
| (To evaluate this resource, click 'Write a review') |
|
| No review or comment? Be the first one! |
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 |
| VOU ANALISAR O PROEJTO E CORRIGIR ELE OK BAPTISTE |
| '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"
}
]
}
]
} |
| | |
| WINDEV, WEBDEV, WINDEV Mobile |
| | | | | |