Hi,
I am currently trying to connect Airtables → PandaDocs through Make and despite validating my JSON structure to an online validator, it still returns the error “Invalid JSON”. Would appreciate any help for this project.
Scenario structure:
Pre Text Aggregator Variable Setup:
Text Aggregator:
Validated JSON Online Validator
Have you given this a try?
I have just tried it and still gives me the same error.
Hello @Robin_Hahn,
Remove quotation (") from Item 3(Name) and Item 4(Description)
Pre Text Aggregator Variable Setup:
If it still does not work then also remove the quotation from this as well.
Text Aggregator:
After that last thing is to share your text output as a file or using a code block.
P.S.: Always search first, Check Make Academy. If this is helpful, mark it as a solution 
and 
Need expert help or have questions? Contact or comment below! 
The text output for the JSON looks good, but still says invalid. I have already removed the quotations from the text aggregator.
[{
“options”: {
“optional”: true,
“optional_selected”: true,
“qty_editable”: true
},
“data”: {
“Name”: “Prep place and finish”,
“Description”: "Pump truck, place and finish
",
“Price”: “4500”,
“QTY”: “1”
}
},{
“options”: {
“optional”: true,
“optional_selected”: true,
“qty_editable”: true
},
“data”: {
“Name”: “Scan floor”,
“Description”: "Have scantec scan area prior to cutting
",
“Price”: “750”,
“QTY”: “1”
}
},{
“options”: {
“optional”: true,
“optional_selected”: true,
“qty_editable”: true
},
“data”: {
“Name”: “Remove”,
“Description”: "Chip old section and haul away
",
“Price”: “1250”,
“QTY”: “1”
}
},{
“options”: {
“optional”: true,
“optional_selected”: true,
“qty_editable”: true
},
“data”: {
“Name”: “Saw cut”,
“Description”: "Have Doncore in for sawcut
",
“Price”: “600”,
“QTY”: “1”
}
}]
Hello @Robin_Hahn,
There are a couple of things you need to follow while handling JSON.
Make sure you use proper regular quotation marks (") not this ” or “.
Another thing is to remove unnecessary line breaks at the end of the line.
For example, on your every Description key there are line breaks at the end.
See this working example created.
[
{
"options":{
"optional":true,
"optional_selected":true,
"qty_editable":true
},
"data":{
"Name":"Prep place and finish",
"Description":"Pump truck, place and finish",
"Price":"4500",
"QTY":"1"
}
},
{
"options":{
"optional":true,
"optional_selected":true,
"qty_editable":true
},
"data":{
"Name":"Scan floor",
"Description":"Have scantec scan area prior to cutting",
"Price":"750",
"QTY":"1"
}
},
{
"options":{
"optional":true,
"optional_selected":true,
"qty_editable":true
},
"data":{
"Name":"Remove",
"Description":"Chip old section and haul away",
"Price":"1250",
"QTY":"1"
}
},
{
"options":{
"optional":true,
"optional_selected":true,
"qty_editable":true
},
"data":{
"Name":"Saw cut",
"Description":"Have Doncore in for sawcut",
"Price":"600",
"QTY":"1"
}
}
]
I hope this helps you.
This was the hint I needed!
This is the fix I added on my text aggregator lines that added line breaks.
Thank you so much for your help!
Hello @Robin_Hahn ,
If this helps you and solves your problems then please mark this topic as complete
Then later other makers also get more help based on this topic.
Also, make sure you practice things with 🟣 Make Academy: Course Overview