cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CrackerManiac
Frequent Visitor

Retrieve data from http request and store it into SQL

Hi,

 

We are trying to create a certain database structure with our forms. One of the problems we face is that we wan't to store a value from a http request:

CrackerManiac_0-1628256812206.png

called 'title' in the database.

Is there a easy way to accomplish this?

I tried to Parse JSON and store the 'title' in SQL but it generates a for each loop (propably because there are like 12 questions)

3 REPLIES 3
Nived_Nambiar
Resolver III
Resolver III

Hi @CrackerManiac 

Can u share the sample data (json) for testing it out ?

CrackerManiac
Frequent Visitor

Hi,

Our flow:

CrackerManiac_0-1628512486227.png

 

Code snippet with Json Respons:

{
    "body": {
        "form": {
            "description": "Controle zijwanden: Linkerwand",
            "onlineSafetyLevel": 0,
            "reputationTier": 1,
            "background": {
                "altText": null,
                "contentType": null,
                "fileIdentifier": null,
                "originalFileName": null,
                "resourceId": null,
                "resourceUrl": null,
                "height": null,
                "width": null,
                "size": null
            },
            "header": {
                "altText": null,
                "contentType": null,
                "fileIdentifier": null,
                "originalFileName": null,
                "resourceId": null,
                "resourceUrl": null,
                "height": null,
                "width": null,
                "size": null
            },
            "logo": {
                "altText": null,
                "contentType": null,
                "fileIdentifier": null,
                "originalFileName": null,
                "resourceId": null,
                "resourceUrl": null,
                "height": null,
                "width": null,
                "size": null
            },
            "tableId": "T4PUWJFEPO5GPNBI57RTKT2PYY",
            "otherInfo": "{\"Theme\":{\"Name\":\"Default Theme\"}}",
            "runtimeResponses": null,
            "permissions": [],
            "responderPermissions": [],
            "status": "Active",
            "category": null,
            "localeInfo": "{\"TimezoneOffset\":120,\"Locale\":\"nl-NL\",\"TimezoneId\":\"Europe/Amsterdam\"}",
            "descriptiveQuestions": [
                {
                    "groupId": null,
                    "defaultValue": null,
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-27T07:34:04.5195949Z",
                    "status": "Added",
                    "subtitle": "Laskwaliteit",
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": null,
                    "insightsInfo": null,
                    "isFromSuggestion": false,
                    "id": "r8e544a79c3304f4c97709a8257f4173c",
                    "isQuiz": false,
                    "order": 540.625,
                    "deserializedQuestionInfo": null,
                    "questionInfo": null,
                    "required": false,
                    "title": "Lasrobot",
                    "type": "Question.ColumnGroup",
                    "allowCustomChoice": null,
                    "trackingId": "21b67d471ce7483fa3c8c8077409b84d"
                },
                {
                    "groupId": null,
                    "defaultValue": null,
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-27T07:27:22.4789997Z",
                    "status": "Added",
                    "subtitle": "",
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": null,
                    "insightsInfo": null,
                    "isFromSuggestion": false,
                    "id": "ra6b734befc5d4d4fb8f709f8e9f47015",
                    "isQuiz": false,
                    "order": 534.375,
                    "deserializedQuestionInfo": null,
                    "questionInfo": null,
                    "required": false,
                    "title": "Formulier",
                    "type": "Question.ColumnGroup",
                    "allowCustomChoice": null,
                    "trackingId": "7af27fc37b314cbd8dc29a866d5ad4ae"
                },
                {
                    "groupId": null,
                    "defaultValue": null,
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:38:37.1955125Z",
                    "status": "Added",
                    "subtitle": "<<Removed for privacy>",
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": null,
                    "insightsInfo": null,
                    "isFromSuggestion": false,
                    "id": "r1cc71a2a1c9649b08c8935b4544cd728",
                    "isQuiz": false,
                    "order": 1450,
                    "deserializedQuestionInfo": null,
                    "questionInfo": null,
                    "required": false,
                    "title": "Afwerking",
                    "type": "Question.ColumnGroup",
                    "allowCustomChoice": null,
                    "trackingId": "6e60375baf9543babdf8c2658b447d69"
                }
            ],
            "questions": [
                {
                    "groupId": null,
                    "defaultValue": "null",
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:44:48.3967056Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "rca602a6346ed4f30a2ac6b7632c281f5",
                    "isQuiz": false,
                    "order": 1650,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"OptionDisplayStyle\":\"ListAll\",\"Choices\":[{\"Description\":\"Ok\"},{\"Description\":\"Niet Ok\"}],\"ChoiceType\":1}",
                    "required": true,
                    "title": "<<Title placed here, but removed for privacy>>",
                    "type": "Question.Choice",
                    "allowCustomChoice": null,
                    "trackingId": "f6ffa96588f647258155915ce3a518a4"
                },
                {
                    "groupId": null,
                    "defaultValue": "null",
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T06:57:13.8677324Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "r9a03551709714169ac03cbcfebd67910",
                    "isQuiz": false,
                    "order": 650,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"OptionDisplayStyle\":\"ListAll\",\"Choices\":[{\"Description\":\"Goed\",\"BranchInfo\":{\"TargetQuestionId\":\"rece417dcdc4145d3bfc60c9b08602389\"}},{\"Description\":\"Goed na afwerking\",\"BranchInfo\":{\"TargetQuestionId\":\"re649b07307de4612808b77ba64a7cb59\"}}],\"ChoiceType\":1}",
                    "required": true,
                    "title": "<<Title placed here, but removed for privacy>>",
                    "type": "Question.Choice",
                    "allowCustomChoice": null,
                    "trackingId": "3e0b10a59fed4d948a2460e8251af49c"
                },
                {
                    "groupId": null,
                    "defaultValue": null,
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:37:51.5965804Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "r07fd2261a3774e1194bc1968b02f9577",
                    "isQuiz": false,
                    "order": 1350,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"Multiline\":true,\"IsAnswerPlainText\":true,\"IsMathInputDefault\":false,\"InputSwitcherDisabled\":true}",
                    "required": false,
                    "title": "<<Title placed here, but removed for privacy>>",
                    "type": "Question.TextField",
                    "allowCustomChoice": null,
                    "trackingId": "191f40bcca83469d9be347bbcf8b4ae6"
                },
                {
                    "groupId": null,
                    "defaultValue": "null",
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T07:00:44.3376402Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "rece417dcdc4145d3bfc60c9b08602389",
                    "isQuiz": false,
                    "order": 750,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"OptionDisplayStyle\":\"ListAll\",\"Choices\":[{\"Description\":\"Goed\",\"BranchInfo\":{\"TargetQuestionId\":\"rfbcaf9cb58ce4f7ab087e8f227e1315f\"}},{\"Description\":\"Goed na afwerking\",\"BranchInfo\":{\"TargetQuestionId\":\"raec4a72cef16430a9444b73a6c327fbb\"}}],\"ChoiceType\":1}",
                    "required": false,
                    "title": "<<Title placed here, but removed for privacy>>",
                    "type": "Question.Choice",
                    "allowCustomChoice": null,
                    "trackingId": "2215d2ff5caa45a39dd9c7dcff03e23c"
                },
                {
                    "groupId": null,
                    "defaultValue": null,
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-25T08:21:19.0536555Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "re320c8296d2842878139fb3bc96f26c5",
                    "isQuiz": false,
                    "order": 1850,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"Multiline\":false,\"IsAnswerPlainText\":true,\"IsMathInputDefault\":false,\"InputSwitcherDisabled\":true}",
                    "required": false,
                    "title": "Ingevuld door",
                    "type": "Question.TextField",
                    "allowCustomChoice": null,
                    "trackingId": "22f6bad0f6b04b5b9ce336df245c8068"
                },
                {
                    "groupId": null,
                    "defaultValue": null,
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:31:34.2231895Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "r9ba8e9d4ef0e4efdb1c9e13b8ea7a51e",
                    "isQuiz": false,
                    "order": 950,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"Multiline\":true,\"IsAnswerPlainText\":true,\"IsMathInputDefault\":false,\"InputSwitcherDisabled\":true}",
                    "required": false,
                    "title": "1.4 Uitgevoerde afwerking",
                    "type": "Question.TextField",
                    "allowCustomChoice": null,
                    "trackingId": "c38d6bd3adb44b5f8439c422412a2637"
                },
                {
                    "groupId": null,
                    "defaultValue": null,
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:32:26.693357Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "r5bc11918a42b47dc9427c375dba2b448",
                    "isQuiz": false,
                    "order": 1050,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"Multiline\":true,\"IsAnswerPlainText\":true,\"IsMathInputDefault\":false,\"InputSwitcherDisabled\":true}",
                    "required": false,
                    "title": "1.5 Uitgevoerde afwerking",
                    "type": "Question.TextField",
                    "allowCustomChoice": null,
                    "trackingId": "0c43fe8bf01c48318855db623386fb26"
                },
                {
                    "groupId": null,
                    "defaultValue": "null",
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:39:29.7609473Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "rf8d84eb874604d55a0bb85c08c2a9e09",
                    "isQuiz": false,
                    "order": 1550,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"OptionDisplayStyle\":\"ListAll\",\"Choices\":[{\"Description\":\"Ok\"},{\"Description\":\"Niet OK\"}],\"ChoiceType\":1}",
                    "required": true,
                    "title": "<<Title placed here, but removed for privacy>>",
                    "type": "Question.Choice",
                    "allowCustomChoice": null,
                    "trackingId": "655a55d2c07144f2932a58f643e3f8fc"
                },
                {
                    "groupId": null,
                    "defaultValue": null,
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-27T07:30:22.8490381Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "rd1e9ec1975424b9997a338ff2d170194",
                    "isQuiz": false,
                    "order": 543.75,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"Multiline\":false,\"IsAnswerPlainText\":true,\"IsMathInputDefault\":false,\"InputSwitcherDisabled\":true}",
                    "required": true,
                    "title": "Projectnummer",
                    "type": "Question.TextField",
                    "allowCustomChoice": null,
                    "trackingId": "a92100f016b64c41b22eeebd9e6727f7"
                },
                {
                    "groupId": null,
                    "defaultValue": null,
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:36:45.9425237Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "r3e3f574ec47848d8b9630741f3734d24",
                    "isQuiz": false,
                    "order": 1250,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"Multiline\":true,\"IsAnswerPlainText\":true,\"IsMathInputDefault\":false,\"InputSwitcherDisabled\":true}",
                    "required": false,
                    "title": "1.7 Uitgevoerde afwerking",
                    "type": "Question.TextField",
                    "allowCustomChoice": null,
                    "trackingId": "99e52b983faf40298054d3283e7e3311"
                },
                {
                    "groupId": null,
                    "defaultValue": null,
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:27:26.0580516Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "rf6afe16e2dac4b06b4975b4ab1b82e6b",
                    "isQuiz": false,
                    "order": 600,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"Multiline\":true,\"IsAnswerPlainText\":true,\"IsMathInputDefault\":false,\"InputSwitcherDisabled\":true}",
                    "required": false,
                    "title": "1.1 uitgevoerde afwerking",
                    "type": "Question.TextField",
                    "allowCustomChoice": null,
                    "trackingId": "8383af0328e648bdba97d037fb216bf4"
                },
                {
                    "groupId": null,
                    "defaultValue": "null",
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:45:06.3174048Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "ra7b8421919804a57bbacc552d3bd10a1",
                    "isQuiz": false,
                    "order": 1700,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"OptionDisplayStyle\":\"ListAll\",\"Choices\":[{\"Description\":\"Ok\"},{\"Description\":\"Niet Ok\"}],\"ChoiceType\":1}",
                    "required": true,
                    "title": "<<Title placed here, but removed for privacy>>",
                    "type": "Question.Choice",
                    "allowCustomChoice": null,
                    "trackingId": "c1a7b6ac20de4b8c94eccaca7b365089"
                },
                {
                    "groupId": null,
                    "defaultValue": null,
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:29:00.7391332Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "re649b07307de4612808b77ba64a7cb59",
                    "isQuiz": false,
                    "order": 700,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"Multiline\":true,\"IsAnswerPlainText\":true,\"IsMathInputDefault\":false,\"InputSwitcherDisabled\":true}",
                    "required": false,
                    "title": "<<Title placed here, but removed for privacy>>",
                    "type": "Question.TextField",
                    "allowCustomChoice": null,
                    "trackingId": "9b859482512343eb8e785854dbab69ce"
                },
                {
                    "groupId": null,
                    "defaultValue": "null",
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:31:14.2581179Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "rfbcaf9cb58ce4f7ab087e8f227e1315f",
                    "isQuiz": false,
                    "order": 900,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"OptionDisplayStyle\":\"ListAll\",\"Choices\":[{\"Description\":\"Goed\",\"BranchInfo\":{\"TargetQuestionId\":\"rb17b3f0625ed49ff814c341b69c93b32\"}},{\"Description\":\"Goed na afwerking\",\"BranchInfo\":{\"TargetQuestionId\":\"r9ba8e9d4ef0e4efdb1c9e13b8ea7a51e\"}}],\"ChoiceType\":1}",
                    "required": true,
                    "title": "<<Title placed here, but removed for privacy>>",
                    "type": "Question.Choice",
                    "allowCustomChoice": null,
                    "trackingId": "fae99f457c5a4ea597370b53932dfd92"
                },
                {
                    "groupId": null,
                    "defaultValue": null,
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:29:49.4684009Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "raec4a72cef16430a9444b73a6c327fbb",
                    "isQuiz": false,
                    "order": 800,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"Multiline\":true,\"IsAnswerPlainText\":true,\"IsMathInputDefault\":false,\"InputSwitcherDisabled\":true}",
                    "required": false,
                    "title": "<<Title placed here, but removed for privacy>>",
                    "type": "Question.TextField",
                    "allowCustomChoice": null,
                    "trackingId": "3d60dd6f341f42a1852eacf7443b299f"
                },
                {
                    "groupId": null,
                    "defaultValue": "null",
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:44:30.6871689Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "r94459abaccf543b1b31c9d6e9b5514e1",
                    "isQuiz": false,
                    "order": 1600,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"OptionDisplayStyle\":\"ListAll\",\"Choices\":[{\"Description\":\"Ok\"},{\"Description\":\"Niet Ok\"}],\"ChoiceType\":1}",
                    "required": true,
                    "title": "<<Title placed here, but removed for privacy>>",
                    "type": "Question.Choice",
                    "allowCustomChoice": null,
                    "trackingId": "960788456f1d48b1b72d219d1d929729"
                },
                {
                    "groupId": null,
                    "defaultValue": "null",
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T06:53:28.7709641Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "rde8619b8dd854d90a93f5a93a9f0170f",
                    "isQuiz": false,
                    "order": 550,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"ShowSubtitle\":true,\"AllowOtherAnswer\":false,\"OptionDisplayStyle\":\"ListAll\",\"Choices\":[{\"Description\":\"Goed\",\"BranchInfo\":{\"TargetQuestionId\":\"r9a03551709714169ac03cbcfebd67910\"}},{\"Description\":\"Goed na afwerking\"}],\"ChoiceType\":1}",
                    "required": true,
                    "title": "<<Title placed here, but removed for privacy>>",
                    "type": "Question.Choice",
                    "allowCustomChoice": null,
                    "trackingId": "e898297469394da0a60cf98ab2e7d396"
                },
                {
                    "groupId": null,
                    "defaultValue": null,
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:45:26.1481958Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "r03bd977a58d14e3fbf45923d4fc5ab73",
                    "isQuiz": false,
                    "order": 1750,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"Multiline\":false,\"IsAnswerPlainText\":true,\"IsMathInputDefault\":false,\"InputSwitcherDisabled\":true}",
                    "required": false,
                    "title": "Opmerkingen",
                    "type": "Question.TextField",
                    "allowCustomChoice": null,
                    "trackingId": "60bec5c0e35e4c32a36e99a165279612"
                },
                {
                    "groupId": null,
                    "defaultValue": "null",
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:33:44.1538709Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "rd4149db173c540eab2c1367dee4c3473",
                    "isQuiz": false,
                    "order": 1100,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"OptionDisplayStyle\":\"ListAll\",\"Choices\":[{\"Description\":\"Goed\",\"BranchInfo\":{\"TargetQuestionId\":\"r7b4d478733a14220a6dcdd2cac174a99\"}},{\"Description\":\"Goed na afwerking\",\"BranchInfo\":{\"TargetQuestionId\":\"r43a5803c62d645a7a6620b10add66fe0\"}}],\"ChoiceType\":1}",
                    "required": true,
                    "title": "<<Title placed here, but removed for privacy>>",
                    "type": "Question.Choice",
                    "allowCustomChoice": null,
                    "trackingId": "a808465521fb4da1859cc2bc0551e859"
                },
                {
                    "groupId": null,
                    "defaultValue": "null",
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-27T07:30:05.3105445Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "r317907824d894da999e380e360af9cab",
                    "isQuiz": false,
                    "order": 537.5,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"OptionDisplayStyle\":\"ListAll\",\"Choices\":[{\"Description\":\"FOR 732.01 Lasrobot Zijwand Links\"}],\"ChoiceType\":1}",
                    "required": true,
                    "title": "Selecteer formulier",
                    "type": "Question.Choice",
                    "allowCustomChoice": null,
                    "trackingId": "f04efc184894460daeed4fb6e350cc47"
                },
                {
                    "groupId": null,
                    "defaultValue": "null",
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:37:31.8840952Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "rdca940f78cf147b69ffdd033362c42cb",
                    "isQuiz": false,
                    "order": 1300,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"OptionDisplayStyle\":\"ListAll\",\"Choices\":[{\"Description\":\"Goed\",\"BranchInfo\":{\"TargetQuestionId\":\"r1cc71a2a1c9649b08c8935b4544cd728\"}},{\"Description\":\"Goed na afwerking\",\"BranchInfo\":{\"TargetQuestionId\":\"r07fd2261a3774e1194bc1968b02f9577\"}}],\"ChoiceType\":1}",
                    "required": true,
                    "title": "<<Title placed here, but removed for privacy>>",
                    "type": "Question.Choice",
                    "allowCustomChoice": null,
                    "trackingId": "0984ece743ff42e8b5ff649f4102d312"
                },
                {
                    "groupId": null,
                    "defaultValue": "null",
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:31:51.8357412Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "rb17b3f0625ed49ff814c341b69c93b32",
                    "isQuiz": false,
                    "order": 1000,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"OptionDisplayStyle\":\"ListAll\",\"Choices\":[{\"Description\":\"Goed\",\"BranchInfo\":{\"TargetQuestionId\":\"rd4149db173c540eab2c1367dee4c3473\"}},{\"Description\":\"Goed na afwerking\",\"BranchInfo\":{\"TargetQuestionId\":\"r5bc11918a42b47dc9427c375dba2b448\"}}],\"ChoiceType\":1}",
                    "required": true,
                    "title": "<<Title placed here, but removed for privacy>>",
                    "type": "Question.Choice",
                    "allowCustomChoice": null,
                    "trackingId": "c3174c8b13dd44c6bb8727dc38bc312c"
                },
                {
                    "groupId": null,
                    "defaultValue": "null",
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:36:22.1293016Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "r7b4d478733a14220a6dcdd2cac174a99",
                    "isQuiz": false,
                    "order": 1200,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"OptionDisplayStyle\":\"ListAll\",\"Choices\":[{\"Description\":\"Goed\",\"BranchInfo\":{\"TargetQuestionId\":\"rdca940f78cf147b69ffdd033362c42cb\"}},{\"Description\":\"Goed na afwerking\",\"BranchInfo\":{\"TargetQuestionId\":\"r3e3f574ec47848d8b9630741f3734d24\"}}],\"ChoiceType\":1}",
                    "required": true,
                    "title": "<<Title placed here, but removed for privacy>>",
                    "type": "Question.Choice",
                    "allowCustomChoice": null,
                    "trackingId": "a97889f0c29547b8aaf24c10f45ad0a8"
                },
                {
                    "groupId": null,
                    "defaultValue": null,
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:34:02.29932Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "r43a5803c62d645a7a6620b10add66fe0",
                    "isQuiz": false,
                    "order": 1150,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"Multiline\":true,\"IsAnswerPlainText\":true,\"IsMathInputDefault\":false,\"InputSwitcherDisabled\":true}",
                    "required": false,
                    "title": "<<Title placed here, but removed for privacy>>",
                    "type": "Question.TextField",
                    "allowCustomChoice": null,
                    "trackingId": "f673be3ab6d74f6ab5495e72913dfb93"
                }
            ],
            "predefinedResponses": null,
            "id": "81wEyk8sEUa8CWwx1lcXks5R8Y2pokBOljYw5oyGOl9UNFBVV0pGRVBPNUdQTkJJNTdSVEtUMlBZWS4u",
            "title": "<<Title placed here, but removed for privacy>>",
            "createdDate": "2021-05-10T06:52:52.357Z",
            "modifiedDate": "2021-08-06T11:57:56.34Z",
            "version": "1.0",
            "ownerId": "8df151ce-a2a9-4e40-9636-30e68c863a5f",
            "ownerTenantId": "ca045cf3-2c4f-4611-bc09-6c31d6571792",
            "settings": "{\"LockGivenQuestionsEndDisplayOrder\":23,\"LockGivenQuestionsStartDisplayOrder\":1,\"RequiresUniqueResponse\":false,\"IsAnonymous\":false,\"NotRecordIdentity\":false,\"IsQuizMode\":false}",
            "deserializedSettings": null,
            "softDeleted": 0,
            "thankYouMessage": null,
            "flags": 4,
            "emailReceiptEnabled": null,
            "type": "form",
            "meetingId": null,
            "formsInsightsInfo": null,
            "formsProRTTitle": null,
            "formsProRTDescription": null,
            "defaultLanguage": null,
            "dataClassificationLevel": null,
            "localeList": [],
            "responseThresholdCount": null,
            "inviteExpiryDays": null,
            "tenantSwitches": 1,
            "privacyUrl": "https://go.microsoft.com/fwlink/p/?linkid=857875",
            "collectionId": null,
            "mfpBranchingData": null,
            "rowCount": 35,
            "Type": null,
            "progressBarEnabled": "false",
            "trackingId": "5f22447161e148249cba7f7d5332c70b"
        }
    }
}

So it seems that the 'parse json' does it's job (it returns the data we need) , but we don't know how to accomplish the steps to store the "title" in SQL (Microsoft SQL Server)

CrackerManiac
Frequent Visitor

{
    "body": {
        "form": {
            "description": "Controle zijwanden: Linkerwand",
            "onlineSafetyLevel": 0,
            "reputationTier": 1,
            "background": {
                "altText": null,
                "contentType": null,
                "fileIdentifier": null,
                "originalFileName": null,
                "resourceId": null,
                "resourceUrl": null,
                "height": null,
                "width": null,
                "size": null
            },
            "header": {
                "altText": null,
                "contentType": null,
                "fileIdentifier": null,
                "originalFileName": null,
                "resourceId": null,
                "resourceUrl": null,
                "height": null,
                "width": null,
                "size": null
            },
            "logo": {
                "altText": null,
                "contentType": null,
                "fileIdentifier": null,
                "originalFileName": null,
                "resourceId": null,
                "resourceUrl": null,
                "height": null,
                "width": null,
                "size": null
            },
            "tableId": "T4PUWJFEPO5GPNBI57RTKT2PYY",
            "otherInfo": "{\"Theme\":{\"Name\":\"Default Theme\"}}",
            "runtimeResponses": null,
            "permissions": [],
            "responderPermissions": [],
            "status": "Active",
            "category": null,
            "localeInfo": "{\"TimezoneOffset\":120,\"Locale\":\"nl-NL\",\"TimezoneId\":\"Europe/Amsterdam\"}",
            "descriptiveQuestions": [
                {
                    "groupId": null,
                    "defaultValue": null,
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-27T07:34:04.5195949Z",
                    "status": "Added",
                    "subtitle": "Laskwaliteit",
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": null,
                    "insightsInfo": null,
                    "isFromSuggestion": false,
                    "id": "r8e544a79c3304f4c97709a8257f4173c",
                    "isQuiz": false,
                    "order": 540.625,
                    "deserializedQuestionInfo": null,
                    "questionInfo": null,
                    "required": false,
                    "title": "Lasrobot",
                    "type": "Question.ColumnGroup",
                    "allowCustomChoice": null,
                    "trackingId": "21b67d471ce7483fa3c8c8077409b84d"
                },
                {
                    "groupId": null,
                    "defaultValue": null,
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-27T07:27:22.4789997Z",
                    "status": "Added",
                    "subtitle": "",
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": null,
                    "insightsInfo": null,
                    "isFromSuggestion": false,
                    "id": "ra6b734befc5d4d4fb8f709f8e9f47015",
                    "isQuiz": false,
                    "order": 534.375,
                    "deserializedQuestionInfo": null,
                    "questionInfo": null,
                    "required": false,
                    "title": "Formulier",
                    "type": "Question.ColumnGroup",
                    "allowCustomChoice": null,
                    "trackingId": "7af27fc37b314cbd8dc29a866d5ad4ae"
                },
                {
                    "groupId": null,
                    "defaultValue": null,
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:38:37.1955125Z",
                    "status": "Added",
                    "subtitle": "<<Removed for privacy>",
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": null,
                    "insightsInfo": null,
                    "isFromSuggestion": false,
                    "id": "r1cc71a2a1c9649b08c8935b4544cd728",
                    "isQuiz": false,
                    "order": 1450,
                    "deserializedQuestionInfo": null,
                    "questionInfo": null,
                    "required": false,
                    "title": "Afwerking",
                    "type": "Question.ColumnGroup",
                    "allowCustomChoice": null,
                    "trackingId": "6e60375baf9543babdf8c2658b447d69"
                }
            ],
            "questions": [
                {
                    "groupId": null,
                    "defaultValue": "null",
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:44:48.3967056Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "rca602a6346ed4f30a2ac6b7632c281f5",
                    "isQuiz": false,
                    "order": 1650,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"OptionDisplayStyle\":\"ListAll\",\"Choices\":[{\"Description\":\"Ok\"},{\"Description\":\"Niet Ok\"}],\"ChoiceType\":1}",
                    "required": true,
                    "title": "<<Title placed here, but removed for privacy>>",
                    "type": "Question.Choice",
                    "allowCustomChoice": null,
                    "trackingId": "f6ffa96588f647258155915ce3a518a4"
                },
                {
                    "groupId": null,
                    "defaultValue": "null",
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T06:57:13.8677324Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "r9a03551709714169ac03cbcfebd67910",
                    "isQuiz": false,
                    "order": 650,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"OptionDisplayStyle\":\"ListAll\",\"Choices\":[{\"Description\":\"Goed\",\"BranchInfo\":{\"TargetQuestionId\":\"rece417dcdc4145d3bfc60c9b08602389\"}},{\"Description\":\"Goed na afwerking\",\"BranchInfo\":{\"TargetQuestionId\":\"re649b07307de4612808b77ba64a7cb59\"}}],\"ChoiceType\":1}",
                    "required": true,
                    "title": "<<Title placed here, but removed for privacy>>",
                    "type": "Question.Choice",
                    "allowCustomChoice": null,
                    "trackingId": "3e0b10a59fed4d948a2460e8251af49c"
                },
                {
                    "groupId": null,
                    "defaultValue": null,
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:37:51.5965804Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "r07fd2261a3774e1194bc1968b02f9577",
                    "isQuiz": false,
                    "order": 1350,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"Multiline\":true,\"IsAnswerPlainText\":true,\"IsMathInputDefault\":false,\"InputSwitcherDisabled\":true}",
                    "required": false,
                    "title": "<<Title placed here, but removed for privacy>>",
                    "type": "Question.TextField",
                    "allowCustomChoice": null,
                    "trackingId": "191f40bcca83469d9be347bbcf8b4ae6"
                },
                {
                    "groupId": null,
                    "defaultValue": "null",
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T07:00:44.3376402Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "rece417dcdc4145d3bfc60c9b08602389",
                    "isQuiz": false,
                    "order": 750,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"OptionDisplayStyle\":\"ListAll\",\"Choices\":[{\"Description\":\"Goed\",\"BranchInfo\":{\"TargetQuestionId\":\"rfbcaf9cb58ce4f7ab087e8f227e1315f\"}},{\"Description\":\"Goed na afwerking\",\"BranchInfo\":{\"TargetQuestionId\":\"raec4a72cef16430a9444b73a6c327fbb\"}}],\"ChoiceType\":1}",
                    "required": false,
                    "title": "<<Title placed here, but removed for privacy>>",
                    "type": "Question.Choice",
                    "allowCustomChoice": null,
                    "trackingId": "2215d2ff5caa45a39dd9c7dcff03e23c"
                },
                {
                    "groupId": null,
                    "defaultValue": null,
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-25T08:21:19.0536555Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "re320c8296d2842878139fb3bc96f26c5",
                    "isQuiz": false,
                    "order": 1850,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"Multiline\":false,\"IsAnswerPlainText\":true,\"IsMathInputDefault\":false,\"InputSwitcherDisabled\":true}",
                    "required": false,
                    "title": "Ingevuld door",
                    "type": "Question.TextField",
                    "allowCustomChoice": null,
                    "trackingId": "22f6bad0f6b04b5b9ce336df245c8068"
                },
                {
                    "groupId": null,
                    "defaultValue": null,
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:31:34.2231895Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "r9ba8e9d4ef0e4efdb1c9e13b8ea7a51e",
                    "isQuiz": false,
                    "order": 950,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"Multiline\":true,\"IsAnswerPlainText\":true,\"IsMathInputDefault\":false,\"InputSwitcherDisabled\":true}",
                    "required": false,
                    "title": "1.4 Uitgevoerde afwerking",
                    "type": "Question.TextField",
                    "allowCustomChoice": null,
                    "trackingId": "c38d6bd3adb44b5f8439c422412a2637"
                },
                {
                    "groupId": null,
                    "defaultValue": null,
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:32:26.693357Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "r5bc11918a42b47dc9427c375dba2b448",
                    "isQuiz": false,
                    "order": 1050,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"Multiline\":true,\"IsAnswerPlainText\":true,\"IsMathInputDefault\":false,\"InputSwitcherDisabled\":true}",
                    "required": false,
                    "title": "1.5 Uitgevoerde afwerking",
                    "type": "Question.TextField",
                    "allowCustomChoice": null,
                    "trackingId": "0c43fe8bf01c48318855db623386fb26"
                },
                {
                    "groupId": null,
                    "defaultValue": "null",
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:39:29.7609473Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "rf8d84eb874604d55a0bb85c08c2a9e09",
                    "isQuiz": false,
                    "order": 1550,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"OptionDisplayStyle\":\"ListAll\",\"Choices\":[{\"Description\":\"Ok\"},{\"Description\":\"Niet OK\"}],\"ChoiceType\":1}",
                    "required": true,
                    "title": "<<Title placed here, but removed for privacy>>",
                    "type": "Question.Choice",
                    "allowCustomChoice": null,
                    "trackingId": "655a55d2c07144f2932a58f643e3f8fc"
                },
                {
                    "groupId": null,
                    "defaultValue": null,
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-27T07:30:22.8490381Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "rd1e9ec1975424b9997a338ff2d170194",
                    "isQuiz": false,
                    "order": 543.75,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"Multiline\":false,\"IsAnswerPlainText\":true,\"IsMathInputDefault\":false,\"InputSwitcherDisabled\":true}",
                    "required": true,
                    "title": "Projectnummer",
                    "type": "Question.TextField",
                    "allowCustomChoice": null,
                    "trackingId": "a92100f016b64c41b22eeebd9e6727f7"
                },
                {
                    "groupId": null,
                    "defaultValue": null,
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:36:45.9425237Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "r3e3f574ec47848d8b9630741f3734d24",
                    "isQuiz": false,
                    "order": 1250,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"Multiline\":true,\"IsAnswerPlainText\":true,\"IsMathInputDefault\":false,\"InputSwitcherDisabled\":true}",
                    "required": false,
                    "title": "1.7 Uitgevoerde afwerking",
                    "type": "Question.TextField",
                    "allowCustomChoice": null,
                    "trackingId": "99e52b983faf40298054d3283e7e3311"
                },
                {
                    "groupId": null,
                    "defaultValue": null,
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:27:26.0580516Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "rf6afe16e2dac4b06b4975b4ab1b82e6b",
                    "isQuiz": false,
                    "order": 600,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"Multiline\":true,\"IsAnswerPlainText\":true,\"IsMathInputDefault\":false,\"InputSwitcherDisabled\":true}",
                    "required": false,
                    "title": "1.1 uitgevoerde afwerking",
                    "type": "Question.TextField",
                    "allowCustomChoice": null,
                    "trackingId": "8383af0328e648bdba97d037fb216bf4"
                },
                {
                    "groupId": null,
                    "defaultValue": "null",
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:45:06.3174048Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "ra7b8421919804a57bbacc552d3bd10a1",
                    "isQuiz": false,
                    "order": 1700,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"OptionDisplayStyle\":\"ListAll\",\"Choices\":[{\"Description\":\"Ok\"},{\"Description\":\"Niet Ok\"}],\"ChoiceType\":1}",
                    "required": true,
                    "title": "<<Title placed here, but removed for privacy>>",
                    "type": "Question.Choice",
                    "allowCustomChoice": null,
                    "trackingId": "c1a7b6ac20de4b8c94eccaca7b365089"
                },
                {
                    "groupId": null,
                    "defaultValue": null,
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:29:00.7391332Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "re649b07307de4612808b77ba64a7cb59",
                    "isQuiz": false,
                    "order": 700,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"Multiline\":true,\"IsAnswerPlainText\":true,\"IsMathInputDefault\":false,\"InputSwitcherDisabled\":true}",
                    "required": false,
                    "title": "<<Title placed here, but removed for privacy>>",
                    "type": "Question.TextField",
                    "allowCustomChoice": null,
                    "trackingId": "9b859482512343eb8e785854dbab69ce"
                },
                {
                    "groupId": null,
                    "defaultValue": "null",
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:31:14.2581179Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "rfbcaf9cb58ce4f7ab087e8f227e1315f",
                    "isQuiz": false,
                    "order": 900,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"OptionDisplayStyle\":\"ListAll\",\"Choices\":[{\"Description\":\"Goed\",\"BranchInfo\":{\"TargetQuestionId\":\"rb17b3f0625ed49ff814c341b69c93b32\"}},{\"Description\":\"Goed na afwerking\",\"BranchInfo\":{\"TargetQuestionId\":\"r9ba8e9d4ef0e4efdb1c9e13b8ea7a51e\"}}],\"ChoiceType\":1}",
                    "required": true,
                    "title": "<<Title placed here, but removed for privacy>>",
                    "type": "Question.Choice",
                    "allowCustomChoice": null,
                    "trackingId": "fae99f457c5a4ea597370b53932dfd92"
                },
                {
                    "groupId": null,
                    "defaultValue": null,
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:29:49.4684009Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "raec4a72cef16430a9444b73a6c327fbb",
                    "isQuiz": false,
                    "order": 800,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"Multiline\":true,\"IsAnswerPlainText\":true,\"IsMathInputDefault\":false,\"InputSwitcherDisabled\":true}",
                    "required": false,
                    "title": "<<Title placed here, but removed for privacy>>",
                    "type": "Question.TextField",
                    "allowCustomChoice": null,
                    "trackingId": "3d60dd6f341f42a1852eacf7443b299f"
                },
                {
                    "groupId": null,
                    "defaultValue": "null",
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:44:30.6871689Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "r94459abaccf543b1b31c9d6e9b5514e1",
                    "isQuiz": false,
                    "order": 1600,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"OptionDisplayStyle\":\"ListAll\",\"Choices\":[{\"Description\":\"Ok\"},{\"Description\":\"Niet Ok\"}],\"ChoiceType\":1}",
                    "required": true,
                    "title": "<<Title placed here, but removed for privacy>>",
                    "type": "Question.Choice",
                    "allowCustomChoice": null,
                    "trackingId": "960788456f1d48b1b72d219d1d929729"
                },
                {
                    "groupId": null,
                    "defaultValue": "null",
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T06:53:28.7709641Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "rde8619b8dd854d90a93f5a93a9f0170f",
                    "isQuiz": false,
                    "order": 550,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"ShowSubtitle\":true,\"AllowOtherAnswer\":false,\"OptionDisplayStyle\":\"ListAll\",\"Choices\":[{\"Description\":\"Goed\",\"BranchInfo\":{\"TargetQuestionId\":\"r9a03551709714169ac03cbcfebd67910\"}},{\"Description\":\"Goed na afwerking\"}],\"ChoiceType\":1}",
                    "required": true,
                    "title": "<<Title placed here, but removed for privacy>>",
                    "type": "Question.Choice",
                    "allowCustomChoice": null,
                    "trackingId": "e898297469394da0a60cf98ab2e7d396"
                },
                {
                    "groupId": null,
                    "defaultValue": null,
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:45:26.1481958Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "r03bd977a58d14e3fbf45923d4fc5ab73",
                    "isQuiz": false,
                    "order": 1750,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"Multiline\":false,\"IsAnswerPlainText\":true,\"IsMathInputDefault\":false,\"InputSwitcherDisabled\":true}",
                    "required": false,
                    "title": "Opmerkingen",
                    "type": "Question.TextField",
                    "allowCustomChoice": null,
                    "trackingId": "60bec5c0e35e4c32a36e99a165279612"
                },
                {
                    "groupId": null,
                    "defaultValue": "null",
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:33:44.1538709Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "rd4149db173c540eab2c1367dee4c3473",
                    "isQuiz": false,
                    "order": 1100,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"OptionDisplayStyle\":\"ListAll\",\"Choices\":[{\"Description\":\"Goed\",\"BranchInfo\":{\"TargetQuestionId\":\"r7b4d478733a14220a6dcdd2cac174a99\"}},{\"Description\":\"Goed na afwerking\",\"BranchInfo\":{\"TargetQuestionId\":\"r43a5803c62d645a7a6620b10add66fe0\"}}],\"ChoiceType\":1}",
                    "required": true,
                    "title": "<<Title placed here, but removed for privacy>>",
                    "type": "Question.Choice",
                    "allowCustomChoice": null,
                    "trackingId": "a808465521fb4da1859cc2bc0551e859"
                },
                {
                    "groupId": null,
                    "defaultValue": "null",
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-27T07:30:05.3105445Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "r317907824d894da999e380e360af9cab",
                    "isQuiz": false,
                    "order": 537.5,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"OptionDisplayStyle\":\"ListAll\",\"Choices\":[{\"Description\":\"FOR 732.01 Lasrobot Zijwand Links\"}],\"ChoiceType\":1}",
                    "required": true,
                    "title": "Selecteer formulier",
                    "type": "Question.Choice",
                    "allowCustomChoice": null,
                    "trackingId": "f04efc184894460daeed4fb6e350cc47"
                },
                {
                    "groupId": null,
                    "defaultValue": "null",
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:37:31.8840952Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "rdca940f78cf147b69ffdd033362c42cb",
                    "isQuiz": false,
                    "order": 1300,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"OptionDisplayStyle\":\"ListAll\",\"Choices\":[{\"Description\":\"Goed\",\"BranchInfo\":{\"TargetQuestionId\":\"r1cc71a2a1c9649b08c8935b4544cd728\"}},{\"Description\":\"Goed na afwerking\",\"BranchInfo\":{\"TargetQuestionId\":\"r07fd2261a3774e1194bc1968b02f9577\"}}],\"ChoiceType\":1}",
                    "required": true,
                    "title": "<<Title placed here, but removed for privacy>>",
                    "type": "Question.Choice",
                    "allowCustomChoice": null,
                    "trackingId": "0984ece743ff42e8b5ff649f4102d312"
                },
                {
                    "groupId": null,
                    "defaultValue": "null",
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:31:51.8357412Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "rb17b3f0625ed49ff814c341b69c93b32",
                    "isQuiz": false,
                    "order": 1000,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"OptionDisplayStyle\":\"ListAll\",\"Choices\":[{\"Description\":\"Goed\",\"BranchInfo\":{\"TargetQuestionId\":\"rd4149db173c540eab2c1367dee4c3473\"}},{\"Description\":\"Goed na afwerking\",\"BranchInfo\":{\"TargetQuestionId\":\"r5bc11918a42b47dc9427c375dba2b448\"}}],\"ChoiceType\":1}",
                    "required": true,
                    "title": "<<Title placed here, but removed for privacy>>",
                    "type": "Question.Choice",
                    "allowCustomChoice": null,
                    "trackingId": "c3174c8b13dd44c6bb8727dc38bc312c"
                },
                {
                    "groupId": null,
                    "defaultValue": "null",
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:36:22.1293016Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "r7b4d478733a14220a6dcdd2cac174a99",
                    "isQuiz": false,
                    "order": 1200,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"OptionDisplayStyle\":\"ListAll\",\"Choices\":[{\"Description\":\"Goed\",\"BranchInfo\":{\"TargetQuestionId\":\"rdca940f78cf147b69ffdd033362c42cb\"}},{\"Description\":\"Goed na afwerking\",\"BranchInfo\":{\"TargetQuestionId\":\"r3e3f574ec47848d8b9630741f3734d24\"}}],\"ChoiceType\":1}",
                    "required": true,
                    "title": "<<Title placed here, but removed for privacy>>",
                    "type": "Question.Choice",
                    "allowCustomChoice": null,
                    "trackingId": "a97889f0c29547b8aaf24c10f45ad0a8"
                },
                {
                    "groupId": null,
                    "defaultValue": null,
                    "image": {
                        "altText": null,
                        "contentType": null,
                        "fileIdentifier": null,
                        "originalFileName": null,
                        "resourceId": null,
                        "resourceUrl": null,
                        "height": null,
                        "width": null,
                        "size": null
                    },
                    "modifiedDate": "2021-05-10T08:34:02.29932Z",
                    "status": "Added",
                    "subtitle": null,
                    "allowMultipleValues": null,
                    "choices": [],
                    "titleHasPhishingKeywords": false,
                    "subtitleHasPhishingKeywords": false,
                    "fileUploadSPOInfo": null,
                    "formsProRTQuestionTitle": null,
                    "formsProRTSubtitle": null,
                    "questionTagForIntelligence": "Unknown",
                    "insightsInfo": "None",
                    "isFromSuggestion": false,
                    "id": "r43a5803c62d645a7a6620b10add66fe0",
                    "isQuiz": false,
                    "order": 1150,
                    "deserializedQuestionInfo": null,
                    "questionInfo": "{\"Multiline\":true,\"IsAnswerPlainText\":true,\"IsMathInputDefault\":false,\"InputSwitcherDisabled\":true}",
                    "required": false,
                    "title": "<<Title placed here, but removed for privacy>>",
                    "type": "Question.TextField",
                    "allowCustomChoice": null,
                    "trackingId": "f673be3ab6d74f6ab5495e72913dfb93"
                }
            ],
            "predefinedResponses": null,
            "id": "81wEyk8sEUa8CWwx1lcXks5R8Y2pokBOljYw5oyGOl9UNFBVV0pGRVBPNUdQTkJJNTdSVEtUMlBZWS4u",
            "title": "<<Title placed here, but removed for privacy>>",
            "createdDate": "2021-05-10T06:52:52.357Z",
            "modifiedDate": "2021-08-06T11:57:56.34Z",
            "version": "1.0",
            "ownerId": "8df151ce-a2a9-4e40-9636-30e68c863a5f",
            "ownerTenantId": "ca045cf3-2c4f-4611-bc09-6c31d6571792",
            "settings": "{\"LockGivenQuestionsEndDisplayOrder\":23,\"LockGivenQuestionsStartDisplayOrder\":1,\"RequiresUniqueResponse\":false,\"IsAnonymous\":false,\"NotRecordIdentity\":false,\"IsQuizMode\":false}",
            "deserializedSettings": null,
            "softDeleted": 0,
            "thankYouMessage": null,
            "flags": 4,
            "emailReceiptEnabled": null,
            "type": "form",
            "meetingId": null,
            "formsInsightsInfo": null,
            "formsProRTTitle": null,
            "formsProRTDescription": null,
            "defaultLanguage": null,
            "dataClassificationLevel": null,
            "localeList": [],
            "responseThresholdCount": null,
            "inviteExpiryDays": null,
            "tenantSwitches": 1,
            "privacyUrl": "https://go.microsoft.com/fwlink/p/?linkid=857875",
            "collectionId": null,
            "mfpBranchingData": null,
            "rowCount": 35,
            "Type": null,
            "progressBarEnabled": "false",
            "trackingId": "5f22447161e148249cba7f7d5332c70b"
        }
    }
}

The output seems to work, we receive the data we want, but we don't know how to 'get' the data and store it into SQL

CrackerManiac_0-1628578085864.png

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (3,597)