[Progress Communities] [Progress OpenEdge ABL] Forum Post: READ-JSON

[Giancarlo Alberto Somma]

Hi to all, i need some hep, json model parse with abl code. i read kb Article 000040659 but, i can't know how to pars more komplex structures. i need a sample 4gl code ? Here is my json file. many thanks. G. { "version": "3.1.0", "sync-datetime": "2019-10-31 15:07:12", "message": "", "error": false, "customers": [ { "id_customer": "26518", "id_ow": "97", "nr_customer": "C101", "company": "Cliente 2", "name": "Franco", "surname": "Nero", "adresse": "", "cap": "", "location": "", "tel1": "", "tel2": "", "fax": "", "email": "", "web": "", "registration_date": "2019-10-15", "genre": "", "resp1": "", "resp2": "", "cp": "", "adresse2": "", "note": "", "types": "customer,vendor", "customer_discount": "0.0", "cust_country": "206", "cust_iva_num": "", "cust_fiscal_code": "", "cust_lang": "it", "cust_exempt_iva": "0", "cust_currency": "CHF", "cust_title": "Spettabile", "cust_status": "active", "cust_uid": "1", "cust_level": "0", "tel_home1": "", "tel_home2": "", "fax2": "", "note2": "", "cust_care_of": "", "cust_mdate": "2019-10-15 17:08:15", "cust_title_letter": null, "cust_title_edu": "", "vendor_discount": "0.0", "cust_deletable": "0", "cust_invoiced": "66", "cust_cinvoiced": "0", "cust_receipted": "0", "cust_sync_id": "0", "cust_ext_code": "", "plist_service_invoice": "0", "plist_service_receipt": "0", "plist_product_invoice": "0", "plist_product_receipt": "0", "id_cfcu": "26518", "id_cs": "26518", "ship_enabled": "0", "ship_company": "", "ship_name": "", "ship_surname": "", "ship_adresse": "", "ship_cap": "", "ship_location": "", "ship_tel1": "", "ship_genre": "male", "ship_cp": "", "ship_adresse2": "", "ship_id_cust": "0", "ship_cust_country": "0", "ship_cust_care_of": "", "cust_name": "Cliente 2NeroFranco", "sum_total_w_iva": "66" }, { "id_customer": "26517", "id_ow": "97", "nr_customer": "C100", "company": "Cliente 1", "name": "Paolo", "surname": "Rossi", "adresse": "", "cap": "", "location": "", "tel1": "", "tel2": "", "fax": "", "email": "", "web": "", "registration_date": "2019-10-15", "genre": "", "resp1": "", "resp2": "", "cp": "", "adresse2": "", "note": "", "types": "customer", "customer_discount": "0.0", "cust_country": "206", "cust_iva_num": "", "cust_fiscal_code": "", "cust_lang": "it", "cust_exempt_iva": "0", "cust_currency": "CHF", "cust_title": "Spettabile", "cust_status": "active", "cust_uid": "1", "cust_level": "0", "tel_home1": "", "tel_home2": "", "fax2": "", "note2": "", "cust_care_of": "", "cust_mdate": "2019-10-15 17:08:04", "cust_title_letter": null, "cust_title_edu": "", "vendor_discount": "0.0", "cust_deletable": "0", "cust_invoiced": "30.02000000000001", "cust_cinvoiced": "0", "cust_receipted": "0", "cust_sync_id": "0", "cust_ext_code": "", "plist_service_invoice": "0", "plist_service_receipt": "0", "plist_product_invoice": "0", "plist_product_receipt": "0", "id_cfcu": "26517", "id_cs": "26517", "ship_enabled": "0", "ship_company": "", "ship_name": "", "ship_surname": "", "ship_adresse": "", "ship_cap": "", "ship_location": "", "ship_tel1": "", "ship_genre": "male", "ship_cp": "", "ship_adresse2": "", "ship_id_cust": "0", "ship_cust_country": "0", "ship_cust_care_of": "", "cust_name": "Cliente 1RossiPaolo", "sum_total_w_iva": "30.02000000000001" } ], "customers_deleted": [ { "action": "delete", "id": "26519" } ], "products": [ { "id_pr": "16055", "id_ow": "97", "code": "1001", "cdate": "2019-10-15", "mdate": "2019-10-31 09:11:16", "id_fo": "0", "id_pd": "0", "name": "Articolo 2", "description": "", "price_buy": "2", "price_sell": "18.57", "iva_perc": "7.7", "weight": "0", "deleted": "0", "code_manu": "", "barcode_internal": "2100000010011", "barcode_manu": "", "notify_stock_min": "0", "notify_qt_min": "-1", "price_catalog": "0", "code2": "", "iva_perc_buy": "7.7", "unit_measure": "", "pr_uid": "1", "qt_per_pack": "1", "qt_min_order": "1", "pr_status": "active", "pr_desc_lang": "0", "qt_unit_sell": "1", "pr_unit_content": "1.000", "pr_pz_in_pack": "1", "price_sell_gross": "20", "pr_exp_date": null, "pr_exp_notify_days": "0", "pr_type": "product", "pr_type_data": "", "pr_stock_mdate": "2019-10-15 17:45:52", "pr_category1": "0", "pr_category2": "0", "pr_category3": "0", "pr_category4": "0", "pr_rate_skip": "0", "pr_raw_materials": "0", "pr_sync_id": "0", "pr_friendly_name": "", "id_cfpr": "16055", "id_plpr": "16055", "whs_id_pr": "16055", "whs_pr_deleted": "0", "whs_stock0": "0", "whs_entries0": "0", "whs_last_used0": null, "whs_last_sale0": null, "whs_last_purch0": null, "whs_stock121": "0", "whs_entries121": "0", "whs_status121": "active", "whs_last_used121": null, "whs_last_sale121": null, "whs_last_purch121": null, "whs_stock_current": "0", "whs_last_used_current": null, "whs_last_sale_current": null, "whs_last_purch_current": null, "pr_ca_code1": null, "pr_ca_name1": null, "pr_ca_code2": null, "pr_ca_name2": null, "pr_ca_code3": null, "pr_ca_name3": null, "pr_ca_code4": null, "pr_ca_name4": null, "vendor_company": null, "vendor_name": null, "vendor_surname": null, "manufacturer_company": null, "manufacturer_name": null, "manufacturer_surname": null }, { "id_pr": "16054", "id_ow": "97", "code": "1000", "cdate": "2019-10-15", "mdate": "2019-10-28 18:15:37", "id_fo": "0", "id_pd": "0", "name": "Articolo 1", "description": "", "price_buy": "1", "price_sell": "9.29", "iva_perc": "7.7", "weight": "0", "deleted": "0", "code_manu": "", "barcode_internal": "1234567890128", "barcode_manu": "", "notify_stock_min": "0", "notify_qt_min": "-1", "price_catalog": "0", "code2": "", "iva_perc_buy": "7.7", "unit_measure": "", "pr_uid": "1", "qt_per_pack": "1", "qt_min_order": "1", "pr_status": "active", "pr_desc_lang": "0", "qt_unit_sell": "1", "pr_unit_content": "1.000", "pr_pz_in_pack": "1", "price_sell_gross": "10", "pr_exp_date": null, "pr_exp_notify_days": "0", "pr_type": "product", "pr_type_data": "", "pr_stock_mdate": "2019-10-30 18:00:59", "pr_category1": "0", "pr_category2": "0", "pr_category3": "0", "pr_category4": "0", "pr_rate_skip": "0", "pr_raw_materials": "0", "pr_sync_id": "0", "pr_friendly_name": "", "id_cfpr": "16054", "id_plpr": "16054", "whs_id_pr": "16054", "whs_pr_deleted": "0", "whs_stock0": "0", "whs_entries0": "3", "whs_last_used0": "2019-10-29 17:13:13", "whs_last_sale0": "2019-10-29 17:13:13", "whs_last_purch0": null, "whs_stock121": "-3", "whs_entries121": "3", "whs_status121": "active", "whs_last_used121": "2019-10-29 17:13:13", "whs_last_sale121": "2019-10-29 17:13:13", "whs_last_purch121": null, "whs_stock_current": "0", "whs_last_used_current": "2019-10-29 17:13:13", "whs_last_sale_current": "2019-10-29 17:13:13", "whs_last_purch_current": null, "pr_ca_code1": null, "pr_ca_name1": null, "pr_ca_code2": null, "pr_ca_name2": null, "pr_ca_code3": null, "pr_ca_name3": null, "pr_ca_code4": null, "pr_ca_name4": null, "vendor_company": null, "vendor_name": null, "vendor_surname": null, "manufacturer_company": null, "manufacturer_name": null, "manufacturer_surname": null }, { "id_pr": "16055", "id_ow": "97", "code": "1001", "cdate": "2019-10-15", "mdate": "2019-10-31 09:11:16", "id_fo": "0", "id_pd": "0", "name": "Articolo 2 altro codice", "description": "", "price_buy": "2", "price_sell": "26.93", "iva_perc": "7.7", "weight": "0", "deleted": "0", "code_manu": "", "barcode_internal": "454645", "barcode_manu": "", "notify_stock_min": "0", "notify_qt_min": "-1", "price_catalog": "0", "code2": "", "iva_perc_buy": "7.7", "unit_measure": "", "pr_uid": "1", "qt_per_pack": "1", "qt_min_order": "1", "pr_status": "active", "pr_desc_lang": "0", "qt_unit_sell": "2", "pr_unit_content": "1.000", "pr_pz_in_pack": "1", "price_sell_gross": "29", "pr_exp_date": null, "pr_exp_notify_days": "0", "pr_type": "product", "pr_type_data": "", "pr_stock_mdate": "2019-10-15 17:45:52", "pr_category1": "0", "pr_category2": "0", "pr_category3": "0", "pr_category4": "0", "pr_rate_skip": "0", "pr_raw_materials": "0", "pr_sync_id": "0", "pr_friendly_name": "", "id_code": "7224", "code_id_pr": "16055", "code_uid": "1", "code_cdate": "2019-10-30", "code_barcode": "454645", "code_name": "Articolo 2 altro codice", "code_qt_per_pack": "1", "code_price_buy": "2", "code_enabled": "1", "code_qt_min_order": "1", "code_qt_unit_sell": "2", "code_price_sell": "26.93", "code_pz_in_pack": "1", "code_sync_id": "0", "code_price_sell_gross": "29", "whs_id_pr": "16055", "whs_pr_deleted": "0", "whs_stock0": "0", "whs_entries0": "0", "whs_last_used0": null, "whs_last_sale0": null, "whs_last_purch0": null, "whs_stock121": "0", "whs_entries121": "0", "whs_status121": "active", "whs_last_used121": null, "whs_last_sale121": null, "whs_last_purch121": null, "whs_stock_current": "0", "whs_last_used_current": null, "whs_last_sale_current": null, "whs_last_purch_current": null, "vendor_company": null, "vendor_name": null, "vendor_surname": null, "manufacturer_company": null, "manufacturer_name": null, "manufacturer_surname": null } ], "products_deleted": [ { "action": "delete", "id": "16056" } ], "products_codes_deleted": [ { "action": "delete", "id": "7225" } ], "services": [ { "id_se": "170", "id_ow": "97", "code": "101", "cdate": "2019-10-15", "mdate": "2019-10-15 17:58:01", "duration": "1", "name": "Servizio 2", "description": "", "price": "27.86", "deleted": "0", "price_buy": "3", "exp_value": "1", "exp_type": "month", "duration_type": "year", "iva_perc_sell": "7.7", "iva_perc_buy": "7.7", "se_currency": "CHF", "se_barcode": "101", "unit_measure": "", "se_desc_lang": "0", "se_status": "active", "price_gross": "30", "se_category1": "0", "se_category2": "0", "se_category3": "0", "se_category4": "0", "id_cfse": "170", "se_ca_code1": null, "se_ca_name1": null, "se_ca_code2": null, "se_ca_name2": null, "se_ca_code3": null, "se_ca_name3": null, "se_ca_code4": null, "se_ca_name4": null }, { "id_se": "169", "id_ow": "97", "code": "100", "cdate": "2019-10-15", "mdate": "2019-10-15 17:57:20", "duration": "1", "name": "Servizio 1", "description": "", "price": "27.86", "deleted": "0", "price_buy": "3", "exp_value": "1", "exp_type": "month", "duration_type": "year", "iva_perc_sell": "7.7", "iva_perc_buy": "7.7", "se_currency": "CHF", "se_barcode": "100", "unit_measure": "", "se_desc_lang": "0", "se_status": "active", "price_gross": "30", "se_category1": "0", "se_category2": "0", "se_category3": "0", "se_category4": "0", "id_cfse": "169", "se_ca_code1": null, "se_ca_name1": null, "se_ca_code2": null, "se_ca_name2": null, "se_ca_code3": null, "se_ca_name3": null, "se_ca_code4": null, "se_ca_name4": null } ], "services_deleted": [ { "action": "delete", "id": "171" } ], "invoices": [ { "id_customer": "26517", "id_ow": "97", "nr_customer": "C100", "company": "Cliente 1", "name": "Paolo", "surname": "Rossi", "adresse": "", "cap": "", "location": "", "tel1": "", "tel2": "", "fax": "", "email": "", "web": "", "registration_date": "2019-10-15", "genre": "", "resp1": "", "resp2": "", "cp": "", "adresse2": "", "note": "", "types": "customer", "customer_discount": "0.0", "cust_country": "206", "cust_iva_num": "", "cust_fiscal_code": "", "cust_lang": "it", "cust_exempt_iva": "0", "cust_currency": "CHF", "cust_title": "Spettabile", "cust_status": "active", "cust_uid": "1", "cust_level": "0", "tel_home1": "", "tel_home2": "", "fax2": "", "note2": "", "cust_care_of": "", "cust_mdate": "2019-10-15 17:08:04", "cust_title_letter": null, "cust_title_edu": "", "vendor_discount": "0.0", "cust_deletable": "0", "cust_invoiced": "30.02000000000001", "cust_cinvoiced": "0", "cust_receipted": "0", "cust_sync_id": "0", "cust_ext_code": "", "plist_service_invoice": "0", "plist_service_receipt": "0", "plist_product_invoice": "0", "plist_product_receipt": "0", "id_invoice": "12855", "num_invoice": "F190003", "date_invoice": "2019-10-30", "date_expiration": "2019-11-29", "ns_ref": "", "vs_ref": "", "rate": "0", "id_bank": "28", "is_iva": "1", "currency": "CHF", "id_es": "0", "invoice_type": "invoice", "total_no_iva": "0.00", "iva_total": "0.00", "payment_total": "0.00", "payment_discount": "0.00", "cancelled": "0", "id_pro": "0", "inv_title": "", "inv_header": "", "inv_note": "", "inv_footer": "", "inv_uid": "1", "inv_total_buy": "0", "total_reduce": "0", "doc_wiva": "1", "total_advance": "0", "inv_ptpl": "0", "inv_pvbr_ref": "123456000000000010001285500", "doc_rows_round5": "0", "inv_main_currency": "CHF", "inv_exch_rate": "1", "inv_total_main_currency": "0", "inv_total": "0.00", "cust_name": "Cliente 1RossiPaolo", "inv_solde": "0.00", "id_cfinv": "12855", "cf_acct_code_customer": "", "cf_acct_status": "ready", "bank_name": "Sage Bank", "action": "create", "acct_code": "", "rows": [ { "id_invoice_details": "24391", "id_invoice": "12855", "description": "", "total": "0.00000", "qt": "1.00000", "id_pr": "0", "ordering": "1", "id_se": "0", "discount": "0", "iva_row": "7.7", "unit_me": "", "options": "{\"row_pos\":\"\"}", "total_buy": "0", "discount2": "0", "qt_pack": "0", "r_total_real_net": "0.00000", "r_total_real_gross": "0.00000", "inv_restore_info": "", "pr_code": null, "pr_name": null, "pr_barcode": null, "pr_pz_in_pack": null, "id_ps": null, "id_wh": null, "stock_id_code": null, "stock_date": null, "stock_qt_here": null, "whs_id_pr": null, "whs_pr_deleted": null, "whs_stock0": null, "whs_entries0": null, "whs_last_used0": null, "whs_last_sale0": null, "whs_last_purch0": null, "whs_stock121": null, "whs_entries121": null, "whs_status121": null, "whs_last_used121": null, "whs_last_sale121": null, "whs_last_purch121": null, "wh_code": null, "wh_name": null, "se_code": null, "se_name": null, "se_barcode": null, "id_cfinvd": "24391", "cf_acct_sale": "", "qt_accounting": 1, "total_row": 0, "acct_code": "" } ] } ], "invoices_deleted": [ { "action": "delete", "id": "12854" } ], "debug": "", "login": true }

Continue reading...