Auslesen einer
Json-Datei mit Adressdaten
Json-Datei:
{
"quality": "CERTIFIED",
"expires": "20141118T110056+0100",
"address": [
{
"id": "034ce086-c9bb-49df-9ed1-1b674e6d5717",
"type": "DOMICILE",
"addresse": {
"title": "MISTER",
"firstName": "Hans",
"lastName": "Muster"
},
"geographicalInfo": {
"house": {
"street": "Musterstrasse",
"houseNumber": "1",
"houseKey": "76439798"
},
"zip": {
"zip": "6000",
"city": "Luzern"
}
}
},
{
"id": "034ce086-c9bb-49df-9ed1-1b674e6d5717",
"type": "DOMICILE",
"addresse": {
"title": "COMPANY",
"firstName": "",
"lastName": "Opacc Software AG"
},
"geographicalInfo": {
"house": {
"street": "Industriestrasse",
"houseNumber": "13",
"houseKey": "123456789"
},
"zip": {
"zip": "6010",
"city": "Kriens"
}
}
}
]
}
Request für das Kopieren und Ausführen in der OpaccOXAS
LiveDocumentation:
Common.JsonQuery
SourceFile=mytest.json
Rows=/root/address
Column=Title,addressee/title
Column=FirstName,addresse/firstName
Column=LastName,addresse/lastName
Column=Street,geographicalInfo/house/street
Column=HouseNumber,geographicalInfo/house/houseNumber
Column=Zip,geographicalInfo/zip/zip
Column=City,geographicalInfo/zip/city
Abfrage mit
Resultat:
