I am getting this error using Postman to patch some data in Kobo, but I don’t understand the error message. I use run Collection and select a csv file.
Postman error message: JSON parse error - Expecting property name enclosed in double quotes: line 6 column 13 (char 135)
This is the request body:
{
“payload”: {
“submission_ids”: [
“638275350”
],
“data”: {
“start”: “1/21/2025”,
“end”: “2/10/2025”,
“Form_Type”: “Baseline”,
“Child1_Age_Months”: “0”,
“Child1_Boy”: “0”,
“Child1_Edema_cnt”: “0”,
“Child1_Girl”: “0”,
“Child1_Moderate_Malnutrition”: “0”,
“Child1_MUAC_MM”: “0”,
“Child1_Nutritional_Status”: “”,
“Child1_Severe_Malnutrition”: “0”,
“Child2_Age_Months”: “0”,
“Child2_Boy”: “0”,
“Child2_Edema_cnt”: “0”,
“Child2_Girl”: “0”,
“Child2_Moderate_Malnutrition”: “0”,
“Child2_MUAC_MM”: “0”,
“Child2_Nutritional_Status”: “”,
“Child2_Severe_Malnutrition”: “0”,
“Child3_Age_Months”: “0”,
“Child3_Boy”: “0”,
“Child3_Edema_cnt”: “0”,
“Child3_Girl”: “0”,
“Child3_Moderate_Malnutrition”: “0”,
“Child3_MUAC_MM”: “0”,
“Child3_Nutritional_Status”: “”,
“Child3_Severe_Malnutrition”: “0”
}
}
}
What is line 6 column 13?
Hi @carlfost7,
Your code is wrong i believe it needs to be like this. You will add your form as x-www-form-urlencoded and use the payload as key and paste your code to value section. If it is not mandatory try to avoid empty variables
{“submission_ids”: [
“638275350”
],
“data”: {
“start”: “1/21/2025”,
“end”: “2/10/2025”,
“Form_Type”: “Baseline”,
“Child1_Age_Months”: “0”,
“Child1_Boy”: “0”,
“Child1_Edema_cnt”: “0”,
“Child1_Girl”: “0”,
“Child1_Moderate_Malnutrition”: “0”,
“Child1_MUAC_MM”: “0”,
“Child1_Nutritional_Status”: “”,
“Child1_Severe_Malnutrition”: “0”,
“Child2_Age_Months”: “0”,
“Child2_Boy”: “0”,
“Child2_Edema_cnt”: “0”,
“Child2_Girl”: “0”,
“Child2_Moderate_Malnutrition”: “0”,
“Child2_MUAC_MM”: “0”,
“Child2_Nutritional_Status”: “”,
“Child2_Severe_Malnutrition”: “0”,
“Child3_Age_Months”: “0”,
“Child3_Boy”: “0”,
“Child3_Edema_cnt”: “0”,
“Child3_Girl”: “0”,
“Child3_Moderate_Malnutrition”: “0”,
“Child3_MUAC_MM”: “0”,
“Child3_Nutritional_Status”: “”,
“Child3_Severe_Malnutrition”: “0”
}
}
}
3 Likes
I forgot to paste the Postman Patch request. Here it is:
{
“payload” : {
“submission_ids” : [“{{_id}}”],
“data” : {
“start” : “{{start}}”,
“end” : “{{end}}”,
“Form_Type” : “{{Form_Type}}”,
“Child1_Age_Months” : “{{Child1_Age_Months}}”,
“Child1_Boy” : “{{Child1_Boy}}”,
“Child1_Edema_cnt” : “{{Child1_Edema_cnt}}”,
“Child1_Girl” : “{{Child1_Girl}}”,
“Child1_Moderate_Malnutrition” : “{{Child1_Moderate_Malnutrition}}”,
“Child1_MUAC_MM” : “{{Child1_MUAC_MM}}”,
“Child1_Nutritional_Status” : “{{Child1_Nutritional_Status}}”,
“Child1_Severe_Malnutrition” : “{{Child1_Severe_Malnutrition}}”,
“Child2_Age_Months” : “{{Child2_Age_Months}}”,
“Child2_Boy” : “{{Child2_Boy}}”,
“Child2_Edema_cnt” : “{{Child2_Edema_cnt}}”,
“Child2_Girl” : “{{Child2_Girl}}”,
“Child2_Moderate_Malnutrition” : “{{Child2_Moderate_Malnutrition}}”,
“Child2_MUAC_MM” : “{{Child2_MUAC_MM}}”,
“Child2_Nutritional_Status” : “{{Child2_Nutritional_Status}}”,
“Child2_Severe_Malnutrition” : “{{Child2_Severe_Malnutrition}}”,
“Child3_Age_Months” : “{{Child3_Age_Months}}”,
“Child3_Boy” : “{{Child3_Boy}}”,
“Child3_Edema_cnt” : “{{Child3_Edema_cnt}}”,
“Child3_Girl” : “{{Child3_Girl}}”,
“Child3_Moderate_Malnutrition” : “{{Child3_Moderate_Malnutrition}}”,
“Child3_MUAC_MM” : “{{Child3_MUAC_MM}}”,
“Child3_Nutritional_Status” : “{{Child3_Nutritional_Status}}”,
“Child3_Severe_Malnutrition” : “{{Child3_Severe_Malnutrition}}”
}
}
}
As i shared an example in the image above, You can’t use the “payload” with in your json. You need to use it as key as in the image and past the test of the code to value part.
{
“submission_ids” : [“{{_id}}”],
“data” : {
“start” : “{{start}}”,
“end” : “{{end}}”,
“Form_Type” : “{{Form_Type}}”,
“Child1_Age_Months” : “{{Child1_Age_Months}}”,
“Child1_Boy” : “{{Child1_Boy}}”,
“Child1_Edema_cnt” : “{{Child1_Edema_cnt}}”,
“Child1_Girl” : “{{Child1_Girl}}”,
“Child1_Moderate_Malnutrition” : “{{Child1_Moderate_Malnutrition}}”,
“Child1_MUAC_MM” : “{{Child1_MUAC_MM}}”,
“Child1_Nutritional_Status” : “{{Child1_Nutritional_Status}}”,
“Child1_Severe_Malnutrition” : “{{Child1_Severe_Malnutrition}}”,
“Child2_Age_Months” : “{{Child2_Age_Months}}”,
“Child2_Boy” : “{{Child2_Boy}}”,
“Child2_Edema_cnt” : “{{Child2_Edema_cnt}}”,
“Child2_Girl” : “{{Child2_Girl}}”,
“Child2_Moderate_Malnutrition” : “{{Child2_Moderate_Malnutrition}}”,
“Child2_MUAC_MM” : “{{Child2_MUAC_MM}}”,
“Child2_Nutritional_Status” : “{{Child2_Nutritional_Status}}”,
“Child2_Severe_Malnutrition” : “{{Child2_Severe_Malnutrition}}”,
“Child3_Age_Months” : “{{Child3_Age_Months}}”,
“Child3_Boy” : “{{Child3_Boy}}”,
“Child3_Edema_cnt” : “{{Child3_Edema_cnt}}”,
“Child3_Girl” : “{{Child3_Girl}}”,
“Child3_Moderate_Malnutrition” : “{{Child3_Moderate_Malnutrition}}”,
“Child3_MUAC_MM” : “{{Child3_MUAC_MM}}”,
“Child3_Nutritional_Status” : “{{Child3_Nutritional_Status}}”,
“Child3_Severe_Malnutrition” : “{{Child3_Severe_Malnutrition}}”
}
}
1 Like
Thanks for the suggestions. I also found that some variable names had a space in the front of the name, which I eliminated with find and replace.
Now I was able to successfully patch 4 submission records.
1 Like