PC SOFT
ONLINE REPOSITORY
FOR WINDEVWEBDEV AND WINDEV MOBILE

Home |  | Sign in | English US
How to convert: Json to xml and xml to hfsql and hfsql in a sql script?
Published by BOLLER
in the category Tools
New features



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
none
none
User reviews
(To evaluate this resource, click 'Write a review')
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"
}
]
}
]
}
ABOUT
RATING:
00No rating
DOWNLOADS:
346
UPDATED:
February 16, 2018
VERSION:
Windev 22
CONCERNS:
WINDEV, WEBDEV, WINDEV Mobile
Minimum version: 1.0
SIZE:
5.6 MB