Подскажите по работе с JSON
В БП получаю массив данных:
{
"status": "ok",
"error_description": "",
"error": {},
"data_type": "",
"total_records": 12,
"data": [
{
"id": 12,
"uid": "a8d89141-566b-07b1-6614-daf82425ae74",
"version": 379842381,
"state": 0,
"modify_date": "2020-05-03T13:50:22.690",
"modify_user": "jsokol",
"create_date": "2020-04-08T10:36:44.609",
"create_user": "jsokol",
"subscription_code": "SMALL",
"client_code": "",
"fee_code": "CONVERTATION",
"event_code": "CONVERTATION",
"cycle_code": "OPERATION",
"algorithm": "GENERAL",
"fixed_amount": 1.08000000,
"percentage": 1.00000000,
"minimum_amount": 4.08000000,
"maximum_amount": 5.08000000,
"fee_currency": "EUR",
"country_group": "EU",
"payment_currency": "",
"gl": 60245000,
"account": "",
"activation_date": "2020-04-08",
"expiration_date": null,
"fee_status": "",
"urgency": "",
"client_statuses": "",
"fee_code_description": "Currency Exchange Operation",
"fee_dates_status": "ACTIVE"
},
{
"id": 20,
"uid": "fcfc544b-6d86-8a8c-6714-beeb80d72b61",
"version": 425526629,
"state": 0,
"modify_date": "2020-05-10T13:58:57.361",
"modify_user": "azukovs",
"create_date": "2020-04-23T21:31:48.324",
"create_user": "jsokol",
"subscription_code": "SMALL",
"client_code": "",
"fee_code": "OUTWARD",
"event_code": "OUTWARD",
"cycle_code": "OPERATION",
"algorithm": "GENERAL",
"fixed_amount": 1.33000000,
"percentage": 19.00000000,
"minimum_amount": 1.00000000,
"maximum_amount": 2.00000000,
"fee_currency": "EUR",
"country_group": "",
"payment_currency": "",
"gl": 60225000,
"account": "",
"activation_date": "2020-04-23",
"expiration_date": null,
"fee_status": "",
"urgency": "STANDART",
"client_statuses": "",
"fee_code_description": "Outward Payments",
"fee_dates_status": "ACTIVE"
},
{
"id": 21,
"uid": "fcfc544b-6d86-8a8c-6714-c9eb60ba3868",
"version": 414943660,
"state": 0,
"modify_date": "2020-05-04T17:21:52.021",
"modify_user": "azukovs",
"create_date": "2020-04-23T21:35:45.119",
"create_user": "jsokol",
"subscription_code": "SMALL",
"client_code": "",
"fee_code": "151000",
"event_code": "ACCOUNT_OPEN_NEW",
"cycle_code": "OPERATION",
"algorithm": "GENERAL",
"fixed_amount": 1.05000000,
"percentage": 0.00000000,
"minimum_amount": 0.00000000,
"maximum_amount": 0.00000000,
"fee_currency": "EUR",
"country_group": "",
"payment_currency": "",
"gl": 60265000,
"account": "",
"activation_date": "2020-04-23",
"expiration_date": null,
"fee_status": "",
"urgency": "",
"client_statuses": "",
"fee_code_description": "Open e-Cash Account",
"fee_dates_status": "ACTIVE"
},
{
"id": 22,
"uid": "fcfc544b-6d86-8a8c-6714-cfebd0d18e1b",
"version": 414944059,
"state": 0,
"modify_date": "2020-05-04T17:22:09.987",
"modify_user": "azukovs",
"create_date": "2020-04-23T21:37:47.539",
"create_user": "jsokol",
"subscription_code": "SMALL",
"client_code": "",
"fee_code": "152000",
"event_code": "ACCOUNT_CLOSE",
"cycle_code": "OPERATION",
"algorithm": "GENERAL",
"fixed_amount": 1.06000000,
"percentage": 0.00000000,
"minimum_amount": 0.00000000,
"maximum_amount": 0.00000000,
"fee_currency": "EUR",
"country_group": "",
"payment_currency": "",
"gl": 60265000,
"account": "",
"activation_date": "2020-04-23",
"expiration_date": null,
"fee_status": "",
"urgency": "",
"client_statuses": "",
"fee_code_description": "Close e-Cash Account",
"fee_dates_status": "ACTIVE"
},
{
"id": 24,
"uid": "fcfc544b-6d86-8a8c-6714-d7ebb4d659aa",
"version": 379028868,
"state": 0,
"modify_date": "2020-04-23T21:40:51.325",
"modify_user": "jsokol",
"create_date": "2020-04-23T21:40:51.323",
"create_user": "jsokol",
"subscription_code": "SMALL",
"client_code": "",
"fee_code": "154000",
"event_code": "FEE_MANUAL",
"cycle_code": "MONTH",
"algorithm": "GENERAL",
"fixed_amount": 1.24000000,
"percentage": 0.00000000,
"minimum_amount": 0.00000000,
"maximum_amount": 0.00000000,
"fee_currency": "EUR",
"country_group": "",
"payment_currency": "",
"gl": 60215000,
"account": "",
"activation_date": "2020-04-23",
"expiration_date": null,
"fee_status": "",
"urgency": "",
"client_statuses": "",
"fee_code_description": "e-Wallet management service",
"fee_dates_status": "ACTIVE"
},
{
"id": 25,
"uid": "fcfc544b-6d86-8a8c-6714-daebc479837a",
"version": 379029080,
"state": 0,
"modify_date": "2020-04-23T21:41:51.735",
"modify_user": "jsokol",
"create_date": "2020-04-23T21:41:51.732",
"create_user": "jsokol",
"subscription_code": "SMALL",
"client_code": "",
"fee_code": "155000",
"event_code": "FEE_MANUAL",
"cycle_code": "MONTH",
"algorithm": "GENERAL",
"fixed_amount": 1.03000000,
"percentage": 0.00000000,
"minimum_amount": 0.00000000,
"maximum_amount": 0.00000000,
"fee_currency": "EUR",
"country_group": "",
"payment_currency": "",
"gl": 60215000,
"account": "",
"activation_date": "2020-04-23",
"expiration_date": null,
"fee_status": "",
"urgency": "",
"client_statuses": "",
"fee_code_description": "Inactive e-Wallet management",
"fee_dates_status": "ACTIVE"
},
{
"id": 26,
"uid": "fcfc544b-6d86-8a8c-6714-e1ebb0fbe1e2",
"version": 379029661,
"state": 0,
"modify_date": "2020-04-23T21:44:30.810",
"modify_user": "jsokol",
"create_date": "2020-04-23T21:44:30.808",
"create_user": "jsokol",
"subscription_code": "SMALL",
"client_code": "",
"fee_code": "171000",
"event_code": "FEE_MANUAL",
"cycle_code": "DAY",
"algorithm": "GENERAL",
"fixed_amount": 1.21000000,
"percentage": 0.00000000,
"minimum_amount": 0.00000000,
"maximum_amount": 0.00000000,
"fee_currency": "EUR",
"country_group": "",
"payment_currency": "",
"gl": 60265000,
"account": "",
"activation_date": "2020-04-23",
"expiration_date": null,
"fee_status": "",
"urgency": "",
"client_statuses": "",
"fee_code_description": "SMS Service Maintenance",
"fee_dates_status": "ACTIVE"
},
{
"id": 29,
"uid": "fcfc544b-6d86-8a8c-6714-eceb705bf7e8",
"version": 379030515,
"state": 0,
"modify_date": "2020-04-23T21:48:27.546",
"modify_user": "jsokol",
"create_date": "2020-04-23T21:48:27.544",
"create_user": "jsokol",
"subscription_code": "SMALL",
"client_code": "",
"fee_code": "173000",
"event_code": "FEE_MANUAL",
"cycle_code": "DAY",
"algorithm": "GENERAL",
"fixed_amount": 1.23000000,
"percentage": 0.00000000,
"minimum_amount": 0.00000000,
"maximum_amount": 0.00000000,
"fee_currency": "EUR",
"country_group": "",
"payment_currency": "",
"gl": 60265000,
"account": "",
"activation_date": "2020-04-23",
"expiration_date": null,
"fee_status": "",
"urgency": "",
"client_statuses": "",
"fee_code_description": "Email Service Maintenance",
"fee_dates_status": "ACTIVE"
},
{
"id": 36,
"uid": "dfe34e1e-e3e0-e49b-6814-f1833c2ad799",
"version": 379842549,
"state": 0,
"modify_date": "2020-05-03T13:57:17.132",
"modify_user": "jsokol",
"create_date": "2020-05-03T13:57:17.131",
"create_user": "jsokol",
"subscription_code": "SMALL",
"client_code": "",
"fee_code": "INWARD",
"event_code": "INWARD",
"cycle_code": "OPERATION",
"algorithm": "GENERAL",
"fixed_amount": 1.43000000,
"percentage": 49.00000000,
"minimum_amount": 1.00000000,
"maximum_amount": 2.00000000,
"fee_currency": "EUR",
"country_group": "",
"payment_currency": "",
"gl": 60225000,
"account": "",
"activation_date": "2020-05-03",
"expiration_date": null,
"fee_status": "",
"urgency": "",
"client_statuses": "",
"fee_code_description": "Inward Payments",
"fee_dates_status": "ACTIVE"
},
{
"id": 37,
"uid": "b1a95e84-8225-eb8b-6814-f783b030f703",
"version": 379842611,
"state": 0,
"modify_date": "2020-05-03T13:59:13.399",
"modify_user": "jsokol",
"create_date": "2020-05-03T13:59:13.397",
"create_user": "jsokol",
"subscription_code": "SMALL",
"client_code": "",
"fee_code": "OUTWARD",
"event_code": "OUTWARD",
"cycle_code": "OPERATION",
"algorithm": "GENERAL",
"fixed_amount": 3.33000000,
"percentage": 1.00000000,
"minimum_amount": 3.33000000,
"maximum_amount": 3.33000000,
"fee_currency": "EUR",
"country_group": "",
"payment_currency": "",
"gl": 60225000,
"account": "",
"activation_date": "2020-05-03",
"expiration_date": null,
"fee_status": "",
"urgency": "URGENT",
"client_statuses": "",
"fee_code_description": "Outward Payments",
"fee_dates_status": "ACTIVE"
},
{
"id": 38,
"uid": "b1a95e84-8225-eb8b-6814-fa83a8bd038d",
"version": 429115257,
"state": 0,
"modify_date": "2020-05-12T15:15:28.410",
"modify_user": "azukovs",
"create_date": "2020-05-03T14:00:29.336",
"create_user": "jsokol",
"subscription_code": "SMALL",
"client_code": "",
"fee_code": "INTERNAL",
"event_code": "INTERNAL",
"cycle_code": "OPERATION",
"algorithm": "GENERAL",
"fixed_amount": 1.09000000,
"percentage": 0.50000000,
"minimum_amount": 0.03000000,
"maximum_amount": 0.05000000,
"fee_currency": "EUR",
"country_group": "",
"payment_currency": "",
"gl": 60225000,
"account": "",
"activation_date": "2020-05-03",
"expiration_date": null,
"fee_status": "",
"urgency": "",
"client_statuses": "",
"fee_code_description": "Internal Payments",
"fee_dates_status": "ACTIVE"
},
{
"id": 39,
"uid": "94a5eff9-f8e1-21a3-6814-4095942b65c0",
"version": 379898769,
"state": 0,
"modify_date": "2020-05-04T16:23:15.480",
"modify_user": "azukovs",
"create_date": "2020-05-04T16:23:15.477",
"create_user": "azukovs",
"subscription_code": "SMALL",
"client_code": "",
"fee_code": "154000",
"event_code": "FEE_PERIODIC",
"cycle_code": "MONTH",
"algorithm": "GENERAL",
"fixed_amount": 1.11000000,
"percentage": 0.00000000,
"minimum_amount": 0.00000000,
"maximum_amount": 0.00000000,
"fee_currency": "EUR",
"country_group": "",
"payment_currency": "",
"gl": 60215000,
"account": "",
"activation_date": "2019-01-01",
"expiration_date": null,
"fee_status": "",
"urgency": "",
"client_statuses": "",
"fee_code_description": "e-Wallet management service",
"fee_dates_status": "ACTIVE"
}
]
}
Нужно разобрать и сложить в базу каждый элемент массива как отдельную строку разбитую по колонкам. Количество элементов массива меняется.
Как реализовать?
Возможно, очень плохо искал решение, но не наткнулся.
