pcsoft.us.windevCopyright 2026, PC SOFT14 Jun 2018 23:31:00 Z14 Jun 2018 07:32:00 ZHello forum members, I have a disagreement with Thme JSON. Maybe someone can help me. I do not receive any data with the following code sJson is string ="{ "stichwort": "Street Food Festival", "beginn": 1529154000, "ende": 1529186100, "zeitraum_bemerk": "", "veranstaltung_id": 4650768, "dienstnummer": "16", "bemerkung": "An dieser Veranstaltung wird auch Bühnenprogramm stattfinden.\ \ ", "eort": { "freitext": "Bonnerstraße. in Lechenich", "objekt": "Bonnerstraße. in Lechenich", "gemeinde": null, "land": null, "strasse": null, "hausnummer": null }, "ansprech_name": "Philipp Uhle", "ansprech_telnummer": "", "hiorg_prim_orgid": 11581, "hiorg_alle_orgid": [ { "orgid": 11581, "bezeichnung": "ASB Erft/Düren e.V." } ], "einsatzmittel_imeinsatz": [ { "bezeichnung": "KTW2", "anzahl_geplant": "1", "mattypkunde": "Kraftfahrzeuge", "mattyphiorg": "Kraftfahrzeuge", "beschreibung": "", "fugcode": "Sama/BRL/KTW2", "koord_wache_lat": "", "koord_wache_lon": "", "hiorg_mat_inst_id": 1505058, "hiorg_mat_id": 540000, "hiorg_org_id": "11581" }, { "bezeichnung": "KTW3", "anzahl_geplant": "1", "mattypkunde": "Kraftfahrzeuge", "mattyphiorg": "Kraftfahrzeuge", "beschreibung": "Dempfer li/re erneuert, Bremsleitung erneuert, Motordischtung erneuert.", "fugcode": "Sama/BRL/KTW3", "koord_wache_lat": "", "koord_wache_lon": "", "hiorg_mat_inst_id": 1505060, "hiorg_mat_id": 540002, "hiorg_org_id": "11581" }, { "bezeichnung": "ELW 1-1", "anzahl_geplant": "1", "mattypkunde": "Kraftfahrzeuge", "mattyphiorg": "Kraftfahrzeuge", "beschreibung": "", "fugcode": "Sama/BRL/ELW1", "koord_wache_lat": "", "koord_wache_lon": "", "hiorg_mat_inst_id": 1505064, "hiorg_mat_id": 540006, "hiorg_org_id": "11581" } ], "einsatzkraefte_imeinsatz": { "22480379": { "nachname": "Helfer 1", "vorname": "Patric", "beschraenk": "", "fw_qual": "", "med_qual": "Rettungssanitäter", "fuehr_qual": "Gruppenführer/in", "bes_ausbild": "", "tel_mobil": "", "melder_nr": "", "bemerk_einteilung": "", "start": "", "ende": "", "hiorg_epos_id": 1227177, "hiorg_ek_id": 230697, "hiorg_org_id": 11581 }, "22921194": { "nachname": "Helfer 2", "vorname": "Rolf", "beschraenk": "", "fw_qual": "", "med_qual": "Sanitätshelfer", "fuehr_qual": "Gruppenführer/in", "bes_ausbild": "", "tel_mobil": "", "melder_nr": "", "bemerk_einteilung": "", "start": "", "ende": "", "hiorg_epos_id": 1227180, "hiorg_ek_id": 228253, "hiorg_org_id": 11581 }, "25086025": { "nachname": "Helfer 3", "vorname": "Philipp", "beschraenk": "", "fw_qual": "", "med_qual": "Rettungssanitäter", "fuehr_qual": "Zugführer/in", "bes_ausbild": "", "tel_mobil": "", "melder_nr": "Ja Swissphone", "bemerk_einteilung": "", "start": "", "ende": "", "hiorg_epos_id": 1227183, "hiorg_ek_id": 61110, "hiorg_org_id": 11581 }, "25681203": { "nachname": "Helfer 4", "vorname": "Ruben", "beschraenk": "", "fw_qual": "", "med_qual": "Erste Hilfe", "fuehr_qual": "Anwärter/in", "bes_ausbild": "", "tel_mobil": "", "melder_nr": "", "bemerk_einteilung": "", "start": "", "ende": "", "hiorg_epos_id": 1227180, "hiorg_ek_id": 716114, "hiorg_org_id": 11581 }, "25875321": { "nachname": "Helfer 5", "vorname": "Fabian", "beschraenk": "", "fw_qual": "", "med_qual": "Rettungshelfer", "fuehr_qual": "Gruppenführer/in", "bes_ausbild": "", "tel_mobil": "", "melder_nr": "", "bemerk_einteilung": "", "start": "", "ende": "", "hiorg_epos_id": 1227177, "hiorg_ek_id": 61178, "hiorg_org_id": 11581 }, "25894950": { "nachname": "Helfer 6", "vorname": "Lisa", "beschraenk": "U18", "fw_qual": "", "med_qual": "Erste Hilfe", "fuehr_qual": "Anwärter/in", "bes_ausbild": "", "tel_mobil": "", "melder_nr": "", "bemerk_einteilung": "", "start": "", "ende": "", "hiorg_epos_id": 1227180, "hiorg_ek_id": 716117, "hiorg_org_id": 11581 }, "26047430": { "nachname": "Helfer 7", "vorname": "Kim Erich", "beschraenk": "", "fw_qual": "", "med_qual": "Rettungshelfer", "fuehr_qual": "Anwärter/in", "bes_ausbild": "", "tel_mobil": "", "melder_nr": "", "bemerk_einteilung": "", "start": "", "ende": "", "hiorg_epos_id": 1227177, "hiorg_ek_id": 269419, "hiorg_org_id": 11581 }, "26069867": { "nachname": "Helfer 8", "vorname": "Stefan", "beschraenk": "", "fw_qual": "", "med_qual": "Santätsdienst", "fuehr_qual": "Leiter Rettungshunde", "bes_ausbild": "", "tel_mobil": "", "melder_nr": "Ja Swissphone", "bemerk_einteilung": "", "start": "", "ende": "", "hiorg_epos_id": 1227183, "hiorg_ek_id": 61040, "hiorg_org_id": 11581 } }, "einsatzpositionen": [ { "hiorg_epos_id": 1227177, "bezeichnung": "SAMA BRL KTW3" }, { "hiorg_epos_id": 1227180, "bezeichnung": "SAMA BRL KTW2" }, { "hiorg_epos_id": 1227183, "bezeichnung": "SAMA BRL ELW 1-1" } ], "status": "OK", "apiversion": "2.0", "timestamp": 1528953042 }" vJson is Variant = JSONToVariant(sJson) FOR n = 1 _TO_ vJson.einsatzkraefte_imeinsatz..Occurrence TableAddLine (TABLE_Personal, vJson.einsatzkraefte_imeinsatz [n] .nachname) END what am I doing wrong? Best regards and thank you in advance Stefan30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65834-wd22-json-data/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65834-wd22-json-data-65839/read.awp14 Jun 2018 23:31:00 ZHi Stefan, What Fabrice wrote but don't need another variant vJson is Variant = JSONToVariant(sJSON) FOR EACH ek OF vJson.…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65834-wd22-json-data-65839/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65834-wd22-json-data-65839/read.awp[WD22] Json Dataguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65834-wd22-json-data-65840/read.awp14 Jun 2018 14:09:00 ZHi Fabrice, Many thanks. Sometimes you do not see the forest for the trees. Regards Stefanhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65834-wd22-json-data-65840/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65834-wd22-json-data-65840/read.awp[WD22] Json Dataguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65834-wd22-json-data-65838/read.awp14 Jun 2018 13:18:00 ZHi Stefan You are forgetting a level... Inside "einsatzkraefte_imeinsatz", you have several sublevels ("22480379", "22921194…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65834-wd22-json-data-65838/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65834-wd22-json-data-65838/read.awp[WD22] Json Data