Adding Integers in the custom app module

Custom Apps
1

I am sending my data from google sheets to my app. I have some predefined schema in the app for variables. In the communication body, I am giving my json structure as follows: “body”: {
“query”: “mutation ($input: task_insert_input!) { insert_task_one(object: $input) { id __typename } }”,
“variables”: {
“input”: {
“name”: “{{if(bundle.name != ""; bundle.name; "Untitled Task")}}”,
“description”: “{{if(bundle.description != ""; bundle.description; "No description provided")}}”,
“priority”: “{{if(bundle.priority != ""; bundle.priority; "low")}}”,
“type”: “{{if(bundle.type != ""; bundle.type; "task")}}”,
“status”: “{{if(bundle.status != ""; bundle.status; "open")}}”,
“start_date”: “{{formatDate(bundle.start_date; "YYYY-MM-DD")}}”,
“end_date”: “{{formatDate(bundle.end_date; "YYYY-MM-DD")}}”,
“property_id”: “{{bundle.property_id}}”,
“room_id”: “{{ifempty(bundle.room_id; "null")}}”,
“completed_by”: “{{ifempty(bundle.completed_by; "null")}}”
}. The problem is my id fields are integers in the app schema. So, when I pass this, it shows "“message”: “invalid input syntax for type integer: "null"”,. If I remove double quotes from the values in the body, then it shows errors in make. If anyone has experienced this error, please help.

2

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.