Parsing a complex JSON

Hi Team,

I am having a complex JSON

[
{
“ID”: “d0e3ae16-eca2-434d-af3e-98bfe3d8fd46”,
“createdAt”: “2022-02-08T07:08:49.401Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T07:08:49.401Z”,
“modifiedBy”: “anonymous”,
“surveyFormInstance_ID”: “6d5d0b4c-affa-40ee-9ba9-076338468a21”,
“answers”: [
{
“ID”: “10dd9be3-a832-486f-a625-700ac7a35046”,
“createdAt”: “2022-02-08T07:09:28.977Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T07:09:28.977Z”,
“modifiedBy”: “anonymous”,
“answer”: “ANSWER447”,
“response_ID”: “d0e3ae16-eca2-434d-af3e-98bfe3d8fd46”,
“question_ID”: “37171863-6eb7-493a-9f6f-c87274bdc942”
},
{
“ID”: “113914c7-eeab-472c-9832-59a2b1e24f19”,
“createdAt”: “2022-02-08T07:09:44.323Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T07:09:44.323Z”,
“modifiedBy”: “anonymous”,
“answer”: “ANSWER8534”,
“response_ID”: “d0e3ae16-eca2-434d-af3e-98bfe3d8fd46”,
“question_ID”: “04592356-f638-4d00-8353-03bdd0e18301”
},
{
“ID”: “1be954b9-1d01-45d9-8653-c39e52bf054a”,
“createdAt”: “2022-02-08T07:09:57.053Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T07:09:57.053Z”,
“modifiedBy”: “anonymous”,
“answer”: “ANSWER6366”,
“response_ID”: “d0e3ae16-eca2-434d-af3e-98bfe3d8fd46”,
“question_ID”: “b660117b-9829-45bd-b534-68fc145e43a5”
},
{
“ID”: “715a36eb-b00a-4cad-9d95-6b93ec2cb2ec”,
“createdAt”: “2022-02-08T07:10:09.381Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T07:10:09.381Z”,
“modifiedBy”: “anonymous”,
“answer”: “ANSWER4442”,
“response_ID”: “d0e3ae16-eca2-434d-af3e-98bfe3d8fd46”,
“question_ID”: “2c74c971-850a-44b8-9771-52ceef27820d”
},
{
“ID”: “a7097e9e-8977-4cd9-adb9-3c2be3f9700d”,
“createdAt”: “2022-02-08T07:10:22.101Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T07:10:22.101Z”,
“modifiedBy”: “anonymous”,
“answer”: “ANSWER8875”,
“response_ID”: “d0e3ae16-eca2-434d-af3e-98bfe3d8fd46”,
“question_ID”: “ad0cd264-20da-4929-8744-19fe8ba80585”
},
{
“ID”: “b8e6e8e9-ded9-4fed-b0fc-93ab8ed74b72”,
“createdAt”: “2022-02-08T07:10:33.165Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T07:10:33.165Z”,
“modifiedBy”: “anonymous”,
“answer”: “ANSWER1785”,
“response_ID”: “d0e3ae16-eca2-434d-af3e-98bfe3d8fd46”,
“question_ID”: “98370c22-62c9-4f8f-96f5-87d8fb7f9fc9”
},
{
“ID”: “d6e89a6c-faf3-4c0c-97db-5bd9e40ffc95”,
“createdAt”: “2022-02-08T07:10:46.913Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T07:10:46.913Z”,
“modifiedBy”: “anonymous”,
“answer”: “ANSWER9359”,
“response_ID”: “d0e3ae16-eca2-434d-af3e-98bfe3d8fd46”,
“question_ID”: “11a33f74-15a5-44cd-be98-3096b31056f0”
}
],
“surveyFormInstance”: {
“ID”: “6d5d0b4c-affa-40ee-9ba9-076338468a21”,
“createdAt”: “2022-02-08T06:57:52.123Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T06:57:52.123Z”,
“modifiedBy”: “anonymous”,
“customer_email”: “c1@dummy.com, c2@dummy.com”,
“expiry_date”: null,
“reminder_interval”: 2,
“filled_status”: true,
“region_ID”: “b12c3990-f13a-4724-87a9-563cacc72d62”,
“customer_ID”: “1319296d-f6f4-436c-bf18-ef12e6c6881d”,
“surveyForm_ID”: “ca402e02-dc1d-4fc2-9b70-8223b8081f25”,
“surveyForm”: {
“ID”: “ca402e02-dc1d-4fc2-9b70-8223b8081f25”,
“createdAt”: “2022-02-08T06:55:19.622Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T06:55:19.622Z”,
“modifiedBy”: “anonymous”,
“survey_form_name”: “SURVEY_FORM_A”,
“survey_form_version”: 1,
“activation_status”: true,
“surveyFormQuestion”: [
{
“ID”: “4ea1da7c-7439-49c6-9ba9-bc4c7e07b18e”,
“createdAt”: “2022-02-08T06:59:43.133Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T06:59:43.133Z”,
“modifiedBy”: “anonymous”,
“sequence”: 7,
“question_ID”: “b660117b-9829-45bd-b534-68fc145e43a5”,
“surveyForm_ID”: “ca402e02-dc1d-4fc2-9b70-8223b8081f25”,
“question”: {
“ID”: “b660117b-9829-45bd-b534-68fc145e43a5”,
“createdAt”: “2022-02-08T06:41:01.334Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T06:41:01.334Z”,
“modifiedBy”: “anonymous”,
“question_no”: 7,
“question_label”: “Comment”,
“question_type”: 3,
“options”: [
{
“ID”: “9d952bcf-f6b5-4ef1-8a1b-bb6fd2b3a40c”,
“createdAt”: “2022-02-08T05:53:08.574Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T05:53:08.574Z”,
“modifiedBy”: “anonymous”,
“option_label”: null,
“question_ID”: “b660117b-9829-45bd-b534-68fc145e43a5”
}
]
}
},
{
“ID”: “4d66e2a3-22d8-4c4b-9987-5c8821f40b7c”,
“createdAt”: “2022-02-08T06:59:54.322Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T06:59:54.322Z”,
“modifiedBy”: “anonymous”,
“sequence”: 3,
“question_ID”: “ad0cd264-20da-4929-8744-19fe8ba80585”,
“surveyForm_ID”: “ca402e02-dc1d-4fc2-9b70-8223b8081f25”,
“question”: {
“ID”: “ad0cd264-20da-4929-8744-19fe8ba80585”,
“createdAt”: “2022-02-08T06:40:49.158Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T06:40:49.158Z”,
“modifiedBy”: “anonymous”,
“question_no”: 3,
“question_label”: “Would you like to allow your users to access some S/4HANA functionality such as creating, approving POs, approving workflow items on mobile devices?”,
“question_type”: 1,
“options”: [
{
“ID”: “1e014750-7998-4ce3-84b5-e48da59c9b0b”,
“createdAt”: “2022-02-08T05:51:34.390Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T05:51:34.390Z”,
“modifiedBy”: “anonymous”,
“option_label”: “Yes”,
“question_ID”: “ad0cd264-20da-4929-8744-19fe8ba80585”
},
{
“ID”: “b7ed8bb4-89ba-4df6-8a47-ae87fe170e22”,
“createdAt”: “2022-02-08T05:53:32.956Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T05:53:32.956Z”,
“modifiedBy”: “anonymous”,
“option_label”: “No”,
“question_ID”: “ad0cd264-20da-4929-8744-19fe8ba80585”
}
]
}
},
{
“ID”: “60deb3ab-308a-42b0-ae8f-f8b5f4ed9f55”,
“createdAt”: “2022-02-08T07:00:05.860Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T07:00:05.860Z”,
“modifiedBy”: “anonymous”,
“sequence”: 2,
“question_ID”: “11a33f74-15a5-44cd-be98-3096b31056f0”,
“surveyForm_ID”: “ca402e02-dc1d-4fc2-9b70-8223b8081f25”,
“question”: {
“ID”: “11a33f74-15a5-44cd-be98-3096b31056f0”,
“createdAt”: “2022-02-08T05:56:18.696Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T05:56:18.696Z”,
“modifiedBy”: “anonymous”,
“question_no”: 2,
“question_label”: “As part of your S/4HANA Migration, are you interested in identifying custom code that can be retired or migrated to the cloud?”,
“question_type”: 1,
“options”: [
{
“ID”: “bc8554b7-61f9-465b-a1ad-310d555e684a”,
“createdAt”: “2022-02-08T05:53:51.318Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T05:53:51.318Z”,
“modifiedBy”: “anonymous”,
“option_label”: “No”,
“question_ID”: “11a33f74-15a5-44cd-be98-3096b31056f0”
},
{
“ID”: “f153c2aa-734d-4ca8-9263-f852561719c4”,
“createdAt”: “2022-02-08T05:54:16.199Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T05:54:16.199Z”,
“modifiedBy”: “anonymous”,
“option_label”: “Yes”,
“question_ID”: “11a33f74-15a5-44cd-be98-3096b31056f0”
}
]
}
},
{
“ID”: “705cdeec-8ba5-4c77-81c6-20c500528562”,
“createdAt”: “2022-02-08T07:00:17.654Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T07:00:17.654Z”,
“modifiedBy”: “anonymous”,
“sequence”: 1,
“question_ID”: “04592356-f638-4d00-8353-03bdd0e18301”,
“surveyForm_ID”: “ca402e02-dc1d-4fc2-9b70-8223b8081f25”,
“question”: {
“ID”: “04592356-f638-4d00-8353-03bdd0e18301”,
“createdAt”: “2022-02-08T05:56:07.642Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T05:56:07.642Z”,
“modifiedBy”: “anonymous”,
“question_no”: 1,
“question_label”: “Are you looking to reinvent/modernize any of your business processes as part of this S/4HANA RISE Migration?”,
“question_type”: 1,
“options”: [
{
“ID”: “0bd96e9f-503a-49f1-817a-b682d8a72f63”,
“createdAt”: “2022-02-08T05:51:20.401Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T05:51:20.401Z”,
“modifiedBy”: “anonymous”,
“option_label”: “Yes”,
“question_ID”: “04592356-f638-4d00-8353-03bdd0e18301”
},
{
“ID”: “84232b79-2e02-42b3-ac4f-9d06dbe4d534”,
“createdAt”: “2022-02-08T05:52:57.907Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T05:52:57.907Z”,
“modifiedBy”: “anonymous”,
“option_label”: “No”,
“question_ID”: “04592356-f638-4d00-8353-03bdd0e18301”
}
]
}
},
{
“ID”: “80f0befa-6795-47fa-8e12-d1ba3e2fdd5d”,
“createdAt”: “2022-02-08T07:00:30.731Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T07:00:30.731Z”,
“modifiedBy”: “anonymous”,
“sequence”: 6,
“question_ID”: “2c74c971-850a-44b8-9771-52ceef27820d”,
“surveyForm_ID”: “ca402e02-dc1d-4fc2-9b70-8223b8081f25”,
“question”: {
“ID”: “2c74c971-850a-44b8-9771-52ceef27820d”,
“createdAt”: “2022-02-08T05:56:30.554Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T05:56:30.554Z”,
“modifiedBy”: “anonymous”,
“question_no”: 6,
“question_label”: “Would you like to deploy Robotic Process Automation to automate some manual tasks in S/4 such as”,
“question_type”: 2,
“options”: [
{
“ID”: “558335ad-10a2-4be0-b1db-b57893a38dfc”,
“createdAt”: “2022-02-08T05:52:13.574Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T05:52:13.574Z”,
“modifiedBy”: “anonymous”,
“option_label”: “Automate manual update of delivery with picked quantity in the system and then perform post goods issue.”,
“question_ID”: “2c74c971-850a-44b8-9771-52ceef27820d”
},
{
“ID”: “56890234-49b5-4ab5-b89c-03e94b0fb1a4”,
“createdAt”: “2022-02-08T05:52:33.319Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T05:52:33.319Z”,
“modifiedBy”: “anonymous”,
“option_label”: “Automatic Sales Order Creation”,
“question_ID”: “2c74c971-850a-44b8-9771-52ceef27820d”
},
{
“ID”: “77d2b49a-c576-4ba7-9edd-742414116fab”,
“createdAt”: “2022-02-08T05:52:44.998Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T05:52:44.998Z”,
“modifiedBy”: “anonymous”,
“option_label”: “Create a business partner based on text data in email/spreadsheets”,
“question_ID”: “2c74c971-850a-44b8-9771-52ceef27820d”
},
{
“ID”: “c289a740-af62-4489-bc3d-98da215f9581”,
“createdAt”: “2022-02-08T05:54:04.686Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T05:54:04.686Z”,
“modifiedBy”: “anonymous”,
“option_label”: “Auto upload of supplier invoices”,
“question_ID”: “2c74c971-850a-44b8-9771-52ceef27820d”
},
{
“ID”: “f5a104a8-1ae0-438a-92dd-0e982f7be99f”,
“createdAt”: “2022-02-08T05:54:27.948Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T05:54:27.948Z”,
“modifiedBy”: “anonymous”,
“option_label”: “Automatic upload of GL Entries”,
“question_ID”: “2c74c971-850a-44b8-9771-52ceef27820d”
}
]
}
},
{
“ID”: “8a62fdb6-b45d-43c3-a3cf-8e605f2eb8c2”,
“createdAt”: “2022-02-08T07:00:42.098Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T07:00:42.098Z”,
“modifiedBy”: “anonymous”,
“sequence”: 4,
“question_ID”: “37171863-6eb7-493a-9f6f-c87274bdc942”,
“surveyForm_ID”: “ca402e02-dc1d-4fc2-9b70-8223b8081f25”,
“question”: {
“ID”: “37171863-6eb7-493a-9f6f-c87274bdc942”,
“createdAt”: “2022-02-08T05:56:42.746Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T05:56:42.746Z”,
“modifiedBy”: “anonymous”,
“question_no”: 4,
“question_label”: “Would you like to allow end-users access different S/4HANA functionality in a single, intuitive screen via a Central Launchpad?”,
“question_type”: 1,
“options”: [
{
“ID”: “4ac6dcf3-110a-443b-b67b-a4f71095502b”,
“createdAt”: “2022-02-08T05:51:59.280Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T05:51:59.280Z”,
“modifiedBy”: “anonymous”,
“option_label”: “No”,
“question_ID”: “37171863-6eb7-493a-9f6f-c87274bdc942”
},
{
“ID”: “f6559406-3b4d-45d1-b20e-3b281d24b548”,
“createdAt”: “2022-02-08T05:54:38.337Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T05:54:38.337Z”,
“modifiedBy”: “anonymous”,
“option_label”: “Yes”,
“question_ID”: “37171863-6eb7-493a-9f6f-c87274bdc942”
}
]
}
},
{
“ID”: “c645776e-627d-4b63-be7d-1bd354731c56”,
“createdAt”: “2022-02-08T07:00:55.117Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T07:00:55.117Z”,
“modifiedBy”: “anonymous”,
“sequence”: 5,
“question_ID”: “98370c22-62c9-4f8f-96f5-87d8fb7f9fc9”,
“surveyForm_ID”: “ca402e02-dc1d-4fc2-9b70-8223b8081f25”,
“question”: {
“ID”: “98370c22-62c9-4f8f-96f5-87d8fb7f9fc9”,
“createdAt”: “2022-02-08T05:58:47.656Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T05:58:47.656Z”,
“modifiedBy”: “anonymous”,
“question_no”: 5,
“question_label”: “As part of your S/4HANA migration, would you like to clean up Business Partner Master data(such as address) so data quality in S/4 improves?”,
“question_type”: 1,
“options”: [
{
“ID”: “3fd5f96a-7672-40e0-8b8a-9d603ad34bc0”,
“createdAt”: “2022-02-08T05:51:45.845Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T05:51:45.845Z”,
“modifiedBy”: “anonymous”,
“option_label”: “Yes”,
“question_ID”: “98370c22-62c9-4f8f-96f5-87d8fb7f9fc9”
},
{
“ID”: “f90fc4d3-3865-4480-8df0-33733c3d46e7”,
“createdAt”: “2022-02-08T05:54:51.286Z”,
“createdBy”: “anonymous”,
“modifiedAt”: “2022-02-08T05:54:51.286Z”,
“modifiedBy”: “anonymous”,
“option_label”: “No”,
“question_ID”: “98370c22-62c9-4f8f-96f5-87d8fb7f9fc9”
}
]
}
}
]
}
}
}
]

I want to parse each field into a variable and set it into repetition so that every time the variable fetches the new value of that field

i would start by creating a rest api data connection and make a test call
and then set the schema from that data

then you will be able to have a data connection in the page you need and you will be able to work with that data in the app

1 Like