migration Choice

let JSONData = `

{
    "sys_choice": [
        {
            "application_id": "156950344216170038",
            "column_id": "172595442807994096",
            "language": "ru",
            "order": 1,
            "policy": "Open",
            "sys_created_at": "2019-11-26 12:38:47",
            "sys_created_by": "155931135900000001",
            "sys_db_table_id": "155931135900000009",
            "sys_id": "157477192714806904",
            "sys_updated_at": "2019-12-06 09:05:31",
            "sys_updated_by": "155931135900000001",
            "table_id": "172594958203488872",
            "title": "\u041d\u0438\u0436\u0435 \u0443\u0440\u043e\u0432\u043d\u044f \u043e\u0436\u0438\u0434\u0430\u043d\u0438\u0439",
            "value": "1"
        },
        {
            "application_id": "156950344216170038",
            "column_id": "172595442807994096",
            "language": "ru",
            "order": 3,
            "policy": "Open",
            "sys_created_at": "2019-11-26 12:35:32",
            "sys_created_by": "155931135900000001",
            "sys_db_table_id": "155931135900000009",
            "sys_id": "157477173112182090",
            "sys_updated_at": "2019-12-06 09:05:32",
            "sys_updated_by": "155931135900000001",
            "table_id": "172594958203488872",
            "title": "\u0412\u044b\u0448\u0435 \u0443\u0440\u043e\u0432\u043d\u044f \u043e\u0436\u0438\u0434\u0430\u043d\u0438\u0439",
            "value": "3"
        },
        {
            "application_id": "156950344216170038",
            "column_id": "172595442807994096",
            "language": "ru",
            "order": 2,
            "policy": "Open",
            "sys_created_at": "2019-11-26 12:33:00",
            "sys_created_by": "155931135900000001",
            "sys_db_table_id": "155931135900000009",
            "sys_id": "157477157913817421",
            "sys_updated_at": "2019-12-06 09:05:30",
            "sys_updated_by": "155931135900000001",
            "table_id": "172594958203488872",
            "title": "\u0421\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0443\u0435\u0442 \u043e\u0436\u0438\u0434\u0430\u043d\u0438\u044f\u043c",
            "value": "2"
        },
        {
            "application_id": "156950344216170038",
            "column_id": "172595442807994096",
            "language": "en",
            "order": 3,
            "policy": "Open",
            "sys_created_at": null,
            "sys_created_by": null,
            "sys_db_table_id": "155931135900000009",
            "sys_id": "156050065201868851",
            "sys_updated_at": "2019-12-06 09:04:41",
            "sys_updated_by": "155931135900000001",
            "table_id": "172594958203488872",
            "title": "Above Expectations",
            "value": "3"
        },
        {
            "application_id": "156950344216170038",
            "column_id": "172595442807994096",
            "language": "en",
            "order": 2,
            "policy": "Open",
            "sys_created_at": null,
            "sys_created_by": null,
            "sys_db_table_id": "155931135900000009",
            "sys_id": "156050061002496356",
            "sys_updated_at": "2019-12-06 09:04:42",
            "sys_updated_by": "155931135900000001",
            "table_id": "172594958203488872",
            "title": "Meets Expectations",
            "value": "2"
        },
        {
            "application_id": "156950344216170038",
            "column_id": "172595442807994096",
            "language": "en",
            "order": 1,
            "policy": "Open",
            "sys_created_at": null,
            "sys_created_by": null,
            "sys_db_table_id": "155931135900000009",
            "sys_id": "156050058309533090",
            "sys_updated_at": "2019-12-06 09:04:38",
            "sys_updated_by": "155931135900000001",
            "table_id": "172594958203488872",
            "title": "Below Expectations",
            "value": "1"
        }
    ]
}

`
function modifyAndCleanData(dataJSON_IN, keysToRemove = []) {
    // Модифицируем строку JSON, добавляя кавычки вокруг числовых значений
    let modifiedJSON = dataJSON_IN.replace(/"(\w+)": (\d{15,})/g, '"$1": "$2"');

    // Парсим модифицированную строку JSON обратно в объект JavaScript
    let data = JSON.parse(modifiedJSON);

    // Удаляем указанные ключи из каждого элемента в массиве sys_security_acl
    // data.sys_security_acl.forEach(acl => {
    //   keysToRemove.forEach(key => {
    //     delete acl[key];
    //   });
    // });

    return data;
  }

function insertRecords(data) {
    var records = data.sys_choice; // Получаем массив записей из JSON

    records.forEach(function(record) {
        var gr = new SimpleRecord('sys_choice'); // Указываем таблицу для вставки

        gr.setValue('value', record.value);
        gr.setValue('title', record.title);
        gr.setValue('table_id', record.table_id);
        // gr.setValue('sys_updated_by', record.sys_updated_by);
        // gr.setValue('sys_updated_at', record.sys_updated_at);
        // gr.setValue('sys_id', record.sys_id);
        gr.setValue('sys_db_table_id', record.sys_db_table_id);
        // gr.setValue('sys_created_by', record.sys_created_by);
        // gr.setValue('sys_created_at', record.sys_created_at);
        gr.setValue('policy', record.policy);
        gr.setValue('order', record.order);
        gr.setValue('language', record.language);
        gr.setValue('column_id', record.column_id);
        // gr.setValue('application_id', record.application_id);

        gr.insert(); // Вставляем запись в таблицу
    });
}

JSONData = modifyAndCleanData(JSONData)

insertRecords(JSONData);