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 |
| | | | | |