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
}