search

wso2 / micro-integrator

The cloud-native configuration driven runtime that helps developers implement composite microservices.
https://wso2.com/integration/
Apache License 2.0
202 stars 218 forks source link

[Bug]: When I was configuring dataservice, MI returned a data parsing error #3384

Open xieyingliang opened 3 months ago

xieyingliang commented 3 months ago

Description

I got a json parsing error when I used dataservice 1719763129134

Steps to Reproduce

The following result is displayed after the sql is executed : 1719763932248 {"msg": "查询成功!", "all_count": 11, "data_list": [{"id": 651, "state": 4, "paid_at": "2024-06-28T14:51:34", "version": 4, "disabled": false, "store_id": 49, "create_at": "2024-06-28T14:51:34.456358", "record_id": 2677, "update_at": "2024-06-28T14:51:34.752726", "channel_id": 132, "company_id": 4698, "created_at": "2024-06-28T14:51:34.734721", "deleted_at": null, "store_name": "男男女女", "updated_at": "2024-06-28T14:51:34.908032", "member_guid": null, "member_name": "散客", "operater_id": 10005, "order_items": null, "before_state": 3, "business_day": "2024-06-28", "change_money": "0", "channel_name": "POS", "member_phone": null, "order_number": "X2406281451330001", "order_source": "1", "origin_price": "1", "create_at_end": null, "device_number": "490A8776-CFDB-4E5B", "operater_name": "邓旭东", "receive_price": "1", "discount_price": "0", "operater_phone": "17628105831", "order_payments": null, "create_at_start": null, "holder_store_id": 394, "order_discounts": null, "business_day_end": null, "external_shopcar": {"goodsList": [{"rn": 1, "tag": 12586, "costs": "0.00", "spu_id": null, "barcode": "4367578698091", "picture": {"id": 118, "url": "https://m-oss.holderzone.cn/imgprx/107,fit/fsgen/2370b004d9a27be25ced6c16e1ad2611"}, "category": [{"id": 18162, "name": "全部1"}], "goods_id": 15457, "plu_code": null, "quantity": "0", "spu_code": "46980000015", "sspgc_id": 109618, "tag_name": "标签2", "is_upsell": true, "combo_type": 41, "goods_unit": 80, "category_id": 18162, "upsell_time": null, "category_name": "全部1", "selling_price": "1.00", "goods_property": null, "combo_type_name": "单品", "goods_sale_name": "111最新", "goods_unit_name": "KG", "valuation_method": 10254, "goods_custom_code": "0000000003", "number_in_shopcar": "1", "goods_specification": null, "goods_uuid_in_shopcar": "908d4656-3bff-448c-b6e7-b990d43216ec", "store_sales_program_id": 353, "discount_total_price_item": "0", "total_price_in_shopcaritem": "1.00", "store_sales_program_goods_id": 106245, "origin_total_price_in_shopcaritem": "1.00"}], "receivalePrice": "1.00", "systemNotCount": "0.00", "discountTotalPrice": "0.00", "originalTotalPrice": "1.00", "shopcarTotalNumber": "1", "receivables_accuracy": 0}, "item_total_price": "1.00", "shopping_guide_id": null, "business_day_start": null, "external_discounts": [{"id": 1, "name": "整单让价", "type": 1, "values": [{"discount_id": "fb7f9219-ce2a-4e63-95ed-2b9cbcdf7cbf", "discount_price": null}]}], "sales_return_items": null, "store_team_info_id": 4823, "total_origin_price": "1", "shopping_guide_name": null}, {"id": 650, "state": 4, "paid_at": "2024-06-28T14:46:33", "version": 4, "disabled": false, "store_id": 49, "create_at": "2024-06-28T14:46:33.556453", "record_id": 2676, "update_at": "2024-06-28T14:46:33.931003", "channel_id": 132, "company_id": 4698, "created_at": "2024-06-28T14:46:33.78528", "deleted_at": null, "store_name": "男男女女", "updated_at": "2024-06-28T14:46:34.080843", "member_guid": null, "member_name": "散客", "operater_id": 10005, "order_items": null, "before_state": 3, "business_day": "2024-06-28", "change_money": "0", "channel_name": "POS", "member_phone": null, "order_number": "X2406281446320001", "order_source": "1", "origin_price": "1", "create_at_end": null, "device_number": "00f3caad", "operater_name": "邓旭东", "receive_price": "1", "discount_price": "0", "operater_phone": "17628105831", "order_payments": null, "create_at_start": null, "holder_store_id": 394, "order_discounts": null, "business_day_end": null, "external_shopcar": {"goodsList": [{"rn": 1, "tag": 12586, "costs": "0.00", "spu_id": null, "barcode": "4367578698091", "picture": {"id": 118, "url": "https://m-oss.holderzone.cn/imgprx/107,fit/fsgen/2370b004d9a27be25ced6c16e1ad2611"}, "category": [{"id": 18162, "name": "全部1"}], "goods_id": 15457, "plu_code": null, "quantity": "0", "spu_code": "46980000015", "sspgc_id": 109618, "tag_name": "标签2", "is_upsell": true, "combo_type": 41, "goods_unit": 80, "category_id": 18162, "upsell_time": null, "category_name": "全部1", "selling_price": "1.00", "goods_property": null, "combo_type_name": "单品", "goods_sale_name": "111最新", "goods_unit_name": "KG", "valuation_method": 10254, "goods_custom_code": "0000000003", "number_in_shopcar": "1", "goods_specification": null, "goods_uuid_in_shopcar": "0f8e3bc1-7701-4656-ac0d-ff3f1c9fd120", "store_sales_program_id": 353, "discount_total_price_item": "0", "total_price_in_shopcaritem": "1.00", "store_sales_program_goods_id": 106245, "origin_total_price_in_shopcaritem": "1.00"}], "receivalePrice": "1.00", "systemNotCount": "0.00", "discountTotalPrice": "0.00", "originalTotalPrice": "1.00", "shopcarTotalNumber": "1", "receivables_accuracy": 0}, "item_total_price": "1.00", "shopping_guide_id": null, "business_day_start": null, "external_discounts": [{"id": 1, "name": "整单让价", "type": 1, "values": [{"discount_id": "d79c44f2-4760-4611-8a7f-2a9ac3fc6683", "discount_price": null}]}], "sales_return_items": null, "store_team_info_id": 4823, "total_origin_price": "1", "shopping_guide_name": null}, {"id": 649, "state": 4, "paid_at": "2024-06-28T14:45:50", "version": 4, "disabled": false, "store_id": 49, "create_at": "2024-06-28T14:45:49.869733", "record_id": 2675, "update_at": "2024-06-28T14:45:50.462512", "channel_id": 132, "company_id": 4698, "created_at": "2024-06-28T14:45:50.230929", "deleted_at": null, "store_name": "男男女女", "updated_at": "2024-06-28T14:45:50.614619", "member_guid": null, "member_name": "散客", "operater_id": 5619, "order_items": null, "before_state": 3, "business_day": "2024-06-28", "change_money": "0", "channel_name": "POS", "member_phone": null, "order_number": "X2406281445390001", "order_source": "1", "origin_price": "1", "create_at_end": null, "device_number": "243a52b16d861f00", "operater_name": "舒谦谦", "receive_price": "1", "discount_price": "-1", "operater_phone": "13540178616", "order_payments": null, "create_at_start": null, "holder_store_id": 394, "order_discounts": null, "business_day_end": null, "external_shopcar": {"goodsList": [{"rn": 1, "tag": 12586, "costs": "0.00", "spu_id": null, "barcode": "4367578698091", "picture": {"id": 118, "url": "https://m-oss.holderzone.cn/imgprx/107,fit/fsgen/2370b004d9a27be25ced6c16e1ad2611"}, "category": [{"id": 18162, "name": "全部1"}], "goods_id": 15457, "plu_code": null, "quantity": "0", "spu_code": "46980000015", "sspgc_id": 109618, "tag_name": "标签2", "is_upsell": true, "combo_type": 41, "goods_unit": 80, "category_id": 18162, "upsell_time": null, "category_name": "全部1", "selling_price": "1.00", "goods_property": null, "combo_type_name": "单品", "goods_sale_name": "111最新", "goods_unit_name": "KG", "valuation_method": 10254, "goods_custom_code": "0000000003", "number_in_shopcar": "1", "goods_specification": null, "goods_uuid_in_shopcar": "5e387f70-67e8-40c8-8658-f97a446d3514", "store_sales_program_id": 353, "discount_total_price_item": "0", "total_price_in_shopcaritem": "1.00", "store_sales_program_goods_id": 106245, "origin_total_price_in_shopcaritem": "1.00"}, {"rn": 1, "tag": 12586, "costs": "9.90", "spu_id": null, "barcode": null, "picture": {"id": 121, "url": "https://m-oss.holderzone.cn/imgprx/107,fit/fsgen/a7e2c81c0d52ebb158db81a7f01b70c7"}, "category": [{"id": 18162, "name": "全部1"}], "goods_id": 15357, "plu_code": null, "quantity": "0", "spu_code": "46980000002", "sspgc_id": 109617, "tag_name": "标签2", "is_upsell": true, "combo_type": 41, "goods_unit": 80, "category_id": 18162, "upsell_time": null, "category_name": "全部1", "selling_price": "1.00", "goods_property": null, "combo_type_name": "单品", "goods_sale_name": "开发商品2", "goods_unit_name": "KG", "valuation_method": 10256, "goods_custom_code": "0000000001", "number_in_shopcar": "1.000", "goods_specification": null, "goods_uuid_in_shopcar": "b1cdfceb-e6d5-4681-818f-fe18a8cb719c", "store_sales_program_id": 353, "discount_total_price_item": "0", "total_price_in_shopcaritem": "1.00", "store_sales_program_goods_id": 106244, "origin_total_price_in_shopcaritem": "1.00"}], "receivalePrice": "2.00", "systemNotCount": "0.00", "discountTotalPrice": "0.00", "originalTotalPrice": "2.00", "shopcarTotalNumber": "2", "receivables_accuracy": 0}, "item_total_price": "2.00", "shopping_guide_id": null, "business_day_start": null, "external_discounts": [{"id": 1, "name": "整单让价", "type": 1, "values": [{"discount_id": "b43c4887-5f65-4812-b8d4-af794434d0ba", "discount_price": "-1.00"}]}], "sales_return_items": null, "store_team_info_id": 4823, "total_origin_price": "2", "shopping_guide_name": null}, {"id": 642, "state": 4, "paid_at": "2024-06-28T14:32:45", "version": 4, "disabled": false, "store_id": 49, "create_at": "2024-06-28T14:32:44.840787", "record_id": 2668, "update_at": "2024-06-28T14:32:45.074737", "channel_id": 132, "company_id": 4698, "created_at": "2024-06-28T14:32:45.265596", "deleted_at": null, "store_name": "男男女女", "updated_at": "2024-06-28T14:32:45.421719", "member_guid": null, "member_name": "散客", "operater_id": 286, "order_items": null, "before_state": 3, "business_day": "2024-06-28", "change_money": "0", "channel_name": "POS", "member_phone": null, "order_number": "X2406281432420001", "order_source": "1", "origin_price": "1", "create_at_end": null, "device_number": "005c19bc", "operater_name": "李亚军", "receive_price": "1", "discount_price": "0", "operater_phone": "18758489432", "order_payments": null, "create_at_start": null, "holder_store_id": 394, "order_discounts": null, "business_day_end": null, "external_shopcar": {"goodsList": [{"rn": 1, "tag": 12586, "costs": "2.00", "spu_id": null, "barcode": "2341211111111", "picture": {"id": 120, "url": "https://m-oss.holderzone.cn/imgprx/107,fit/fsgen/1bbaea5d86d84bae6ce45bc0093d4956"}, "category": [{"id": 18162, "name": "全部1"}], "goods_id": 15355, "plu_code": "2222", "quantity": "0", "spu_code": "46980000003", "sspgc_id": 109619, "tag_name": "标签2", "is_upsell": true, "combo_type": 41, "goods_unit": 80, "category_id": 18162, "upsell_time": null, "category_name": "全部1", "selling_price": "1.00", "goods_property": null, "combo_type_name": "单品", "goods_sale_name": "开发商品3", "goods_unit_name": "KG", "valuation_method": 10256, "goods_custom_code": "23197", "number_in_shopcar": "1.000", "goods_specification": null, "goods_uuid_in_shopcar": "e45d49de-058f-4194-af35-0e4669d8cdc9", "store_sales_program_id": 353, "discount_total_price_item": "0", "total_price_in_shopcaritem": "1.00", "store_sales_program_goods_id": 106246, "origin_total_price_in_shopcaritem": "1.00"}], "receivalePrice": "1.00", "systemNotCount": "0.00", "discountTotalPrice": "0.00", "originalTotalPrice": "1.00", "shopcarTotalNumber": "1", "receivables_accuracy": 0}, "item_total_price": "1.00", "shopping_guide_id": null, "business_day_start": null, "external_discounts": [{"id": 1, "name": "整单让价", "type": 1, "values": [{"discount_id": "5e855273-9f0b-4e11-accf-95398a9b2f36", "discount_price": null}]}], "sales_return_items": null, "store_team_info_id": 4823, "total_origin_price": "1", "shopping_guide_name": null}, {"id": 640, "state": 8, "paid_at": "2024-06-28T14:24:46", "version": 5, "disabled": false, "store_id": 49, "create_at": "2024-06-28T14:24:45.744775", "record_id": 2649, "update_at": "2024-06-28T14:24:53.434474", "channel_id": 132, "company_id": 4698, "created_at": "2024-06-28T14:24:47.890032", "deleted_at": null, "store_name": "男男女女", "updated_at": "2024-06-28T14:44:27.997693", "member_guid": null, "member_name": "散客", "operater_id": 9786, "order_items": null, "before_state": 4, "business_day": "2024-06-28", "change_money": "0", "channel_name": "POS", "member_phone": null, "order_number": "X2406281424440001", "order_source": "1", "origin_price": "1", "create_at_end": null, "device_number": "00a41905", "operater_name": "刘雨轩", "receive_price": "1", "discount_price": "0", "operater_phone": "15102824476", "order_payments": null, "create_at_start": null, "holder_store_id": 394, "order_discounts": null, "business_day_end": null, "external_shopcar": {"goodsList": [{"rn": 1, "tag": 12586, "costs": "0.00", "spu_id": null, "barcode": "4367578698091", "picture": {"id": 118, "url": "https://m-oss.holderzone.cn/imgprx/107,fit/fsgen/2370b004d9a27be25ced6c16e1ad2611"}, "category": [{"id": 18162, "name": "全部1"}], "goods_id": 15457, "plu_code": null, "quantity": "0", "spu_code": "46980000015", "sspgc_id": 109618, "tag_name": "标签2", "is_upsell": true, "combo_type": 41, "goods_unit": 80, "category_id": 18162, "upsell_time": null, "category_name": "全部1", "selling_price": "1.00", "goods_property": null, "combo_type_name": "单品", "goods_sale_name": "111最新", "goods_unit_name": "KG", "valuation_method": 10254, "goods_custom_code": "0000000003", "number_in_shopcar": "1", "goods_specification": null, "goods_uuid_in_shopcar": "e678686b-38dc-4831-952d-a6128405da23", "store_sales_program_id": 353, "discount_total_price_item": "0", "total_price_in_shopcaritem": "1.00", "store_sales_program_goods_id": 106245, "origin_total_price_in_shopcaritem": "1.00"}], "receivalePrice": "1.00", "systemNotCount": "0.00", "discountTotalPrice": "0.00", "originalTotalPrice": "1.00", "shopcarTotalNumber": "1", "receivables_accuracy": 0}, "item_total_price": "1.00", "shopping_guide_id": null, "business_day_start": null, "external_discounts": [{"id": 1, "name": "整单让价", "type": 1, "values": [{"discount_id": "1a8b59d0-2b80-4561-af8a-25046fddb351", "discount_price": null}]}], "sales_return_items": null, "store_team_info_id": 4823, "total_origin_price": "1", "shopping_guide_name": null}, {"id": 639, "state": 4, "paid_at": "2024-06-28T14:17:10", "version": 4, "disabled": false, "store_id": 49, "create_at": "2024-06-28T14:17:10.359303", "record_id": 2666, "update_at": "2024-06-28T14:17:10.79457", "channel_id": 132, "company_id": 4698, "created_at": "2024-06-28T14:17:10.640269", "deleted_at": null, "store_name": "男男女女", "updated_at": "2024-06-28T14:17:10.932996", "member_guid": null, "member_name": "散客", "operater_id": 8662, "order_items": null, "before_state": 3, "business_day": "2024-06-28", "change_money": "45", "channel_name": "POS", "member_phone": null, "order_number": "X2406281417020001", "order_source": "1", "origin_price": "5", "create_at_end": null, "device_number": "00fdfc4f", "operater_name": "ssy", "receive_price": "50", "discount_price": "4", "operater_phone": "13154954384", "order_payments": null, "create_at_start": null, "holder_store_id": 394, "order_discounts": null, "business_day_end": null, "external_shopcar": {"goodsList": [{"rn": 1, "tag": 12586, "costs": "9.90", "spu_id": null, "barcode": null, "picture": {"id": 121, "url": "https://m-oss.holderzone.cn/imgprx/107,fit/fsgen/a7e2c81c0d52ebb158db81a7f01b70c7"}, "category": [{"id": 18162, "name": "全部1"}], "goods_id": 15357, "plu_code": null, "quantity": "0", "spu_code": "46980000002", "sspgc_id": 109617, "tag_name": "标签2", "is_upsell": true, "combo_type": 41, "goods_unit": 80, "category_id": 18162, "upsell_time": null, "category_name": "全部1", "selling_price": "1.00", "goods_property": null, "combo_type_name": "单品", "goods_sale_name": "开发商品2", "goods_unit_name": "KG", "valuation_method": 10256, "goods_custom_code": "0000000001", "number_in_shopcar": "1.000", "goods_specification": null, "goods_uuid_in_shopcar": "b8742af3-a382-455e-8623-a02fcc3159b6", "store_sales_program_id": 353, "discount_total_price_item": "0", "total_price_in_shopcaritem": "1.00", "store_sales_program_goods_id": 106244, "origin_total_price_in_shopcaritem": "1.00"}], "receivalePrice": "1.00", "systemNotCount": "0.00", "discountTotalPrice": "0.00", "originalTotalPrice": "1.00", "shopcarTotalNumber": "1", "receivables_accuracy": 0}, "item_total_price": "1.00", "shopping_guide_id": null, "business_day_start": null, "external_discounts": [{"id": 1, "name": "整单让价", "type": 1, "values": [{"discount_id": "a28cbf48-8f57-46d2-8026-388b56902d52", "discount_price": "4.00"}]}], "sales_return_items": null, "store_team_info_id": 4823, "total_origin_price": "1", "shopping_guide_name": null}, {"id": 638, "state": 4, "paid_at": "2024-06-28T14:15:14", "version": 4, "disabled": false, "store_id": 49, "create_at": "2024-06-28T14:15:14.217039", "record_id": 2665, "update_at": "2024-06-28T14:15:14.431792", "channel_id": 132, "company_id": 4698, "created_at": "2024-06-28T14:15:14.360481", "deleted_at": null, "store_name": "男男女女", "updated_at": "2024-06-28T14:15:14.578846", "member_guid": null, "member_name": "散客", "operater_id": 8662, "order_items": null, "before_state": 3, "business_day": "2024-06-28", "change_money": "111", "channel_name": "POS", "member_phone": null, "order_number": "X2406281415120001", "order_source": "1", "origin_price": "1", "create_at_end": null, "device_number": "00fdfc4f", "operater_name": "ssy", "receive_price": "112", "discount_price": "0", "operater_phone": "13154954384", "order_payments": null, "create_at_start": null, "holder_store_id": 394, "order_discounts": null, "business_day_end": null, "external_shopcar": {"goodsList": [{"rn": 1, "tag": 12586, "costs": "9.90", "spu_id": null, "barcode": null, "picture": {"id": 121, "url": "https://m-oss.holderzone.cn/imgprx/107,fit/fsgen/a7e2c81c0d52ebb158db81a7f01b70c7"}, "category": [{"id": 18162, "name": "全部1"}], "goods_id": 15357, "plu_code": null, "quantity": "0", "spu_code": "46980000002", "sspgc_id": 109617, "tag_name": "标签2", "is_upsell": true, "combo_type": 41, "goods_unit": 80, "category_id": 18162, "upsell_time": null, "category_name": "全部1", "selling_price": "1.00", "goods_property": null, "combo_type_name": "单品", "goods_sale_name": "开发商品2", "goods_unit_name": "KG", "valuation_method": 10256, "goods_custom_code": "0000000001", "number_in_shopcar": "1.000", "goods_specification": null, "goods_uuid_in_shopcar": "7dbe5fa1-e4d4-4ec6-84bc-c68d8d5f4880", "store_sales_program_id": 353, "discount_total_price_item": "0", "total_price_in_shopcaritem": "1.00", "store_sales_program_goods_id": 106244, "origin_total_price_in_shopcaritem": "1.00"}], "receivalePrice": "1.00", "systemNotCount": "0.00", "discountTotalPrice": "0.00", "originalTotalPrice": "1.00", "shopcarTotalNumber": "1", "receivables_accuracy": 0}, "item_total_price": "1.00", "shopping_guide_id": null, "business_day_start": null, "external_discounts": [{"id": 1, "name": "整单让价", "type": 1, "values": [{"discount_id": "84e4af92-fa73-4f5f-a0b2-39e23fe52eb4", "discount_price": null}]}], "sales_return_items": null, "store_team_info_id": 4823, "total_origin_price": "1", "shopping_guide_name": null}, {"id": 635, "state": 8, "paid_at": "2024-06-28T12:24:47", "version": 5, "disabled": false, "store_id": 49, "create_at": "2024-06-28T12:24:46.440769", "record_id": 2662, "update_at": "2024-06-28T14:13:05.979733", "channel_id": 132, "company_id": 4698, "created_at": "2024-06-28T12:24:46.792151", "deleted_at": null, "store_name": "男男女女", "updated_at": "2024-06-28T14:13:06.630611", "member_guid": null, "member_name": "散客", "operater_id": 8662, "order_items": null, "before_state": 4, "business_day": "2024-06-27", "change_money": "0", "channel_name": "POS", "member_phone": null, "order_number": "X2406281224340001", "order_source": "1", "origin_price": "111", "create_at_end": null, "device_number": "00fdfc4f", "operater_name": "ssy", "receive_price": "111", "discount_price": "0", "operater_phone": "13154954384", "order_payments": null, "create_at_start": null, "holder_store_id": 394, "order_discounts": null, "business_day_end": null, "external_shopcar": {"goodsList": [{"rn": 1, "tag": 14595, "costs": "0.00", "spu_id": null, "barcode": "5465436565456", "picture": null, "category": [{"id": 18312, "name": "水果"}], "goods_id": 18289, "plu_code": null, "quantity": "0", "spu_code": "4698912121213543654", "sspgc_id": 109797, "tag_name": "xasxa", "is_upsell": true, "combo_type": 41, "goods_unit": 81, "category_id": 18312, "upsell_time": null, "category_name": "水果", "selling_price": "111.00", "goods_property": null, "combo_type_name": "单品", "goods_sale_name": "12345678912345464979797979498949464656594949799", "goods_unit_name": "千米", "valuation_method": 10256, "goods_custom_code": "24592", "number_in_shopcar": "1.000", "goods_specification": null, "goods_uuid_in_shopcar": "85ae16d2-b70e-4aa4-8a3b-06828fe39f0d", "store_sales_program_id": 938, "discount_total_price_item": "0", "total_price_in_shopcaritem": "111.00", "store_sales_program_goods_id": 106337, "origin_total_price_in_shopcaritem": "111.00"}], "receivalePrice": "111.00", "systemNotCount": "0.00", "discountTotalPrice": "0.00", "originalTotalPrice": "111.00", "shopcarTotalNumber": "1", "receivables_accuracy": 0}, "item_total_price": "111.00", "shopping_guide_id": null, "business_day_start": null, "external_discounts": [{"id": 1, "name": "整单让价", "type": 1, "values": [{"discount_id": "f1ba7971-b3f2-49b9-b20f-85cf4f99ab15", "discount_price": null}]}], "sales_return_items": null, "store_team_info_id": 4823, "total_origin_price": "111", "shopping_guide_name": null}, {"id": 634, "state": 10, "paid_at": null, "version": 5, "disabled": false, "store_id": 49, "create_at": "2024-06-28T12:24:11.850134", "record_id": 2661, "update_at": "2024-06-28T12:24:21.635143", "channel_id": 132, "company_id": 4698, "created_at": "2024-06-28T12:24:11.997941", "deleted_at": null, "store_name": "男男女女", "updated_at": "2024-06-28T12:24:21.839037", "member_guid": null, "member_name": "散客", "operater_id": 8662, "order_items": null, "before_state": 11, "business_day": "2024-06-27", "change_money": "0", "channel_name": "POS", "member_phone": null, "order_number": "X2406281224010001", "order_source": "1", "origin_price": "111", "create_at_end": null, "device_number": "00fdfc4f", "operater_name": "ssy", "receive_price": "111", "discount_price": "0", "operater_phone": "13154954384", "order_payments": null, "create_at_start": null, "holder_store_id": 394, "order_discounts": null, "business_day_end": null, "external_shopcar": {"goodsList": [{"rn": 1, "tag": 14595, "costs": "0.00", "spu_id": null, "barcode": "5465436565456", "picture": null, "category": [{"id": 18312, "name": "水果"}], "goods_id": 18289, "plu_code": null, "quantity": "0", "spu_code": "4698912121213543654", "sspgc_id": 109797, "tag_name": "xasxa", "is_upsell": true, "combo_type": 41, "goods_unit": 81, "category_id": 18312, "upsell_time": null, "category_name": "水果", "selling_price": "111.00", "goods_property": null, "combo_type_name": "单品", "goods_sale_name": "12345678912345464979797979498949464656594949799", "goods_unit_name": "千米", "valuation_method": 10256, "goods_custom_code": "24592", "number_in_shopcar": "1.000", "goods_specification": null, "goods_uuid_in_shopcar": "85ae16d2-b70e-4aa4-8a3b-06828fe39f0d", "store_sales_program_id": 938, "discount_total_price_item": "0", "total_price_in_shopcaritem": "111.00", "store_sales_program_goods_id": 106337, "origin_total_price_in_shopcaritem": "111.00"}], "receivalePrice": "111.00", "systemNotCount": "0.00", "discountTotalPrice": "0.00", "originalTotalPrice": "111.00", "shopcarTotalNumber": "1", "receivables_accuracy": 0}, "item_total_price": "111.00", "shopping_guide_id": null, "business_day_start": null, "external_discounts": [{"id": 1, "name": "整单让价", "type": 1, "values": [{"discount_id": "f1ba7971-b3f2-49b9-b20f-85cf4f99ab15", "discount_price": null}]}], "sales_return_items": null, "store_team_info_id": 4823, "total_origin_price": "111", "shopping_guide_name": null}, {"id": 633, "state": 10, "paid_at": null, "version": 5, "disabled": false, "store_id": 49, "create_at": "2024-06-28T12:23:27.275602", "record_id": 2660, "update_at": "2024-06-28T12:23:37.581884", "channel_id": 132, "company_id": 4698, "created_at": "2024-06-28T12:23:27.432866", "deleted_at": null, "store_name": "男男女女", "updated_at": "2024-06-28T12:23:37.826025", "member_guid": null, "member_name": "散客", "operater_id": 8662, "order_items": null, "before_state": 11, "business_day": "2024-06-27", "change_money": "0", "channel_name": "POS", "member_phone": null, "order_number": "X2406281223210001", "order_source": "1", "origin_price": "1", "create_at_end": null, "device_number": "00fdfc4f", "operater_name": "ssy", "receive_price": "1", "discount_price": "0", "operater_phone": "13154954384", "order_payments": null, "create_at_start": null, "holder_store_id": 394, "order_discounts": null, "business_day_end": null, "external_shopcar": {"goodsList": [{"rn": 1, "tag": 12586, "costs": "2.00", "spu_id": null, "barcode": "2341211111111", "picture": {"id": 120, "url": "https://m-oss.holderzone.cn/imgprx/107,fit/fsgen/1bbaea5d86d84bae6ce45bc0093d4956"}, "category": [{"id": 18162, "name": "全部1"}], "goods_id": 15355, "plu_code": "2222", "quantity": "0", "spu_code": "46980000003", "sspgc_id": 109619, "tag_name": "标签2", "is_upsell": true, "combo_type": 41, "goods_unit": 80, "category_id": 18162, "upsell_time": null, "category_name": "全部1", "selling_price": "1.00", "goods_property": null, "combo_type_name": "单品", "goods_sale_name": "开发商品3", "goods_unit_name": "克", "valuation_method": 10256, "goods_custom_code": "23197", "number_in_shopcar": "1.000", "goods_specification": null, "goods_uuid_in_shopcar": "c9d827a1-179c-43bd-a4b7-0c1e0cf2525b", "store_sales_program_id": 353, "discount_total_price_item": "0", "total_price_in_shopcaritem": "1.00", "store_sales_program_goods_id": 106246, "origin_total_price_in_shopcaritem": "1.00"}], "receivalePrice": "1.00", "systemNotCount": "0.00", "discountTotalPrice": "0.00", "originalTotalPrice": "1.00", "shopcarTotalNumber": "1", "receivables_accuracy": 0}, "item_total_price": "1.00", "shopping_guide_id": null, "business_day_start": null, "external_discounts": [{"id": 1, "name": "整单让价", "type": 1, "values": [{"discount_id": "42d2a115-dcfd-440b-b147-64db15488e86", "discount_price": null}]}], "sales_return_items": null, "store_team_info_id": 4823, "total_origin_price": "1", "shopping_guide_name": null}, {"id": 632, "state": 10, "paid_at": null, "version": 5, "disabled": false, "store_id": 49, "create_at": "2024-06-28T12:21:14.309381", "record_id": 2659, "update_at": "2024-06-28T12:21:20.648627", "channel_id": 132, "company_id": 4698, "created_at": "2024-06-28T12:21:14.697918", "deleted_at": null, "store_name": "男男女女", "updated_at": "2024-06-28T12:21:20.771617", "member_guid": null, "member_name": "散客", "operater_id": 8662, "order_items": null, "before_state": 11, "business_day": "2024-06-27", "change_money": "0", "channel_name": "POS", "member_phone": null, "order_number": "X2406281221090001", "order_source": "1", "origin_price": "1", "create_at_end": null, "device_number": "00fdfc4f", "operater_name": "ssy", "receive_price": "1", "discount_price": "0", "operater_phone": "13154954384", "order_payments": null, "create_at_start": null, "holder_store_id": 394, "order_discounts": null, "business_day_end": null, "external_shopcar": {"goodsList": [{"rn": 1, "tag": 12586, "costs": "0.00", "spu_id": null, "barcode": "4367578698091", "picture": {"id": 118, "url": "https://m-oss.holderzone.cn/imgprx/107,fit/fsgen/2370b004d9a27be25ced6c16e1ad2611"}, "category": [{"id": 18162, "name": "全部1"}], "goods_id": 15457, "plu_code": null, "quantity": "0", "spu_code": "46980000015", "sspgc_id": 109618, "tag_name": "标签2", "is_upsell": true, "combo_type": 41, "goods_unit": 80, "category_id": 18162, "upsell_time": null, "category_name": "全部1", "selling_price": "1.00", "goods_property": null, "combo_type_name": "单品", "goods_sale_name": "111最新", "goods_unit_name": "克", "valuation_method": 10254, "goods_custom_code": "0000000003", "number_in_shopcar": "1", "goods_specification": null, "goods_uuid_in_shopcar": "01b8be26-fc3a-4439-91d9-73c616c244cb", "store_sales_program_id": 353, "discount_total_price_item": "0", "total_price_in_shopcaritem": "1.00", "store_sales_program_goods_id": 106245, "origin_total_price_in_shopcaritem": "1.00"}], "receivalePrice": "1.00", "systemNotCount": "0.00", "discountTotalPrice": "0.00", "originalTotalPrice": "1.00", "shopcarTotalNumber": "1", "receivables_accuracy": 0}, "item_total_price": "1.00", "shopping_guide_id": null, "business_day_start": null, "external_discounts": [{"id": 1, "name": "整单让价", "type": 1, "values": [{"discount_id": "ffefef3d-458f-48ef-941f-a54ace6aff1b", "discount_price": null}]}], "sales_return_items": null, "store_team_info_id": 4823, "total_origin_price": "1", "shopping_guide_name": null}], "all_state_count": [{"count": 6, "state": 4}, {"count": 2, "state": 8}, {"count": 3, "state": 10}]}

This is how I configure my dataservice：

{"data":{"message":"$query_order_list"}}

The following error is reported when running: [2024-06-30 23:04:56,401] ERROR {JsonStreamFormatter} - Error occurred while writing to application/json java.lang.reflect.InvocationTargetException at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.wso2.micro.integrator.core.json.JsonStreamFormatter.writeTo(JsonStreamFormatter.java:107) at org.apache.synapse.transport.passthru.PassThroughHttpSender.submitResponse(PassThroughHttpSender.java:597) at org.apache.synapse.transport.passthru.PassThroughHttpSender.invoke(PassThroughHttpSender.java:293) at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:442) at org.apache.axis2.receivers.AbstractInOutSyncMessageReceiver.invokeBusinessLogic(AbstractInOutSyncMessageReceiver.java:45) at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:110) at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:180) at org.apache.synapse.transport.passthru.ServerWorker.processNonEntityEnclosingRESTHandler(ServerWorker.java:399) at org.apache.synapse.transport.passthru.ServerWorker.processEntityEnclosingRequest(ServerWorker.java:458) at org.apache.synapse.transport.passthru.ServerWorker.run(ServerWorker.java:206) at org.apache.axis2.transport.base.threads.NativeWorkerPool$1.run(NativeWorkerPool.java:172) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: java.lang.IllegalStateException: Nesting problem. at com.google.gson.stream.JsonWriter.beforeValue(JsonWriter.java:708) at com.google.gson.stream.JsonWriter.value(JsonWriter.java:425) at org.apache.axis2.json.gson.GsonXMLStreamWriter.writeCharacters(GsonXMLStreamWriter.java:820) at org.apache.axiom.om.impl.MTOMXMLStreamWriter.writeCharacters(MTOMXMLStreamWriter.java:289) at org.apache.axiom.om.impl.llom.OMTextImpl.writeOutput(OMTextImpl.java:268) at org.apache.axiom.om.impl.llom.OMTextImpl.internalSerialize(OMTextImpl.java:436) at org.apache.axiom.om.impl.util.OMSerializerUtil.serializeChildren(OMSerializerUtil.java:563) at org.apache.axiom.om.impl.llom.OMElementImpl.internalSerialize(OMElementImpl.java:879) at org.apache.axiom.om.impl.util.OMSerializerUtil.serializeChildren(OMSerializerUtil.java:563) at org.apache.axiom.om.impl.llom.OMElementImpl.internalSerialize(OMElementImpl.java:879) at org.apache.axiom.om.impl.llom.OMSerializableImpl.serialize(OMSerializableImpl.java:125) at org.apache.axiom.om.impl.llom.OMSerializableImpl.serializeAndConsume(OMSerializableImpl.java:117) at org.apache.axis2.json.gson.JsonFormatter.writeTo(JsonFormatter.java:100) ... 18 more

[2024-06-30 23:04:56,401] ERROR {PassThroughHttpSender} - Failed to submit the response org.apache.axis2.AxisFault at org.wso2.micro.integrator.core.json.JsonStreamFormatter.writeTo(JsonStreamFormatter.java:113) at org.apache.synapse.transport.passthru.PassThroughHttpSender.submitResponse(PassThroughHttpSender.java:597) at org.apache.synapse.transport.passthru.PassThroughHttpSender.invoke(PassThroughHttpSender.java:293) at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:442) at org.apache.axis2.receivers.AbstractInOutSyncMessageReceiver.invokeBusinessLogic(AbstractInOutSyncMessageReceiver.java:45) at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:110) at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:180) at org.apache.synapse.transport.passthru.ServerWorker.processNonEntityEnclosingRESTHandler(ServerWorker.java:399) at org.apache.synapse.transport.passthru.ServerWorker.processEntityEnclosingRequest(ServerWorker.java:458) at org.apache.synapse.transport.passthru.ServerWorker.run(ServerWorker.java:206) at org.apache.axis2.transport.base.threads.NativeWorkerPool$1.run(NativeWorkerPool.java:172) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829)

1719763129134

Affected Version(s)

v4.2.0

OS, DB, other environment details and versions

No response

Related issue(s) (optional)

No response

Suggested label(s) (optional)

Priority/Highest

Suggested assignee(s) (optional)

No response