PC SOFT
DEPOT EN LIGNE
POUR WINDEVWEBDEV ET WINDEV MOBILE

How to convert: Json to xml and xml to hfsql and hfsql in a sql script?
Publié par Boller
dans la catégorie Outils
Nouveautés



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, copies d'écran
none
none
Avis des utilisateurs
(Pour noter la ressource, cliquez sur Ecrire un avis)
Boller
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
VOU ANALISAR O PROEJTO E CORRIGIR ELE OK BAPTISTE
Baptiste - BLV TECH
'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"
}
]
}
]
}
A PROPOS
EVALUATION :
00Aucune évaluation
TELECHARGEMENTS :
650
MISE À JOUR :
16 février 2018
VERSION :
Windev 22
CONCERNE :
WINDEV, WEBDEV, WINDEV Mobile
Version minimale : 1.0
TAILLE :
5,6 Mo