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:
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)
Hi,
Our flow:
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)
{
"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
User | Count |
---|---|
27 | |
16 | |
15 | |
12 | |
11 |
User | Count |
---|---|
43 | |
30 | |
28 | |
24 | |
23 |