# Invalid JSON **URL:** \ **Category:** Questions\ **Tags:** error\ **Created:** [November 14, 2024, 5:20pm UTC](https://community.make.com/t/invalid-json/60914 "2024-11-14T17:20:14Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Robin\_Hahn](https://avatars.discourse-cdn.com/v4/letter/r/cab0a1/32.png) [@Robin\_Hahn](https://community.make.com/u/Robin_Hahn)\ **Post date:** [November 14, 2024, 5:20pm UTC](https://community.make.com/t/invalid-json/60914/1 "2024-11-14T17:20:14Z")
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: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/4/b4122e2d1fdbcf5ac122346eedda0c14cf832e64.png) Pre Text Aggregator Variable Setup: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/7/4/7485cf04c1ac7ceb0c578759690585b5e80128d9.png) Text Aggregator: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/7/3789e8377ab26004d9533211c783e660a38168ad.png) Validated JSON Online Validator ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/f/ffd9aab6e194d7f002a4501568980fa22a1c7ab5.png) ---
**Author:** ![daydreamer](https://avatars.discourse-cdn.com/v4/letter/d/e9a140/32.png) [@daydreamer](https://community.make.com/u/daydreamer)\ **Post date:** [November 14, 2024, 7:37pm UTC](https://community.make.com/t/invalid-json/60914/2 "2024-11-14T19:37:36Z")
Have you given this a try? > [@Source is not valid JSON](https://community.make.com/t/source-is-not-valid-json/18168/2): > > I discovered that what was making the JSON invalid was that either the Mailhook was receiving data with new lines in it or Make was adding new lines to the data (probably the former). I fixed it by using a simple replace function on the data to replace all new lines with a space. This resulted in the JSON string becoming valid and allowing the scenario to proceed normally. Screenshot for reference: [image] ---
**Author:** ![Robin\_Hahn](https://avatars.discourse-cdn.com/v4/letter/r/cab0a1/32.png) [@Robin\_Hahn](https://community.make.com/u/Robin_Hahn)\ **Post date:** [November 14, 2024, 9:26pm UTC](https://community.make.com/t/invalid-json/60914/3 "2024-11-14T21:26:44Z")
I have just tried it and still gives me the same error. ---
**Author:** ![dilipborad](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/dilipborad/32/53211_2.png) [@dilipborad](https://community.make.com/u/dilipborad)\ **Post date:** [November 15, 2024, 8:26am UTC](https://community.make.com/t/invalid-json/60914/4 "2024-11-15T08:26:03Z")
Hello @Robin_Hahn, **Remove quotation (")** from **Item 3(Name) and Item 4(Description)** > Pre Text Aggregator Variable Setup: > > ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/7/4/7485cf04c1ac7ceb0c578759690585b5e80128d9.png) If it still does not work then also **remove the quotation** from this as well. > Text Aggregator: > > ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/7/3789e8377ab26004d9533211c783e660a38168ad.png) 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](https://community.make.com/t/make-academy-course-overview/29699). If this is helpful, mark it as a solution ✅ and 👍 Need expert help or have questions? Contact or comment below! 👇 ---
**Author:** ![Robin\_Hahn](https://avatars.discourse-cdn.com/v4/letter/r/cab0a1/32.png) [@Robin\_Hahn](https://community.make.com/u/Robin_Hahn)\ **Post date:** [November 15, 2024, 2:12pm UTC](https://community.make.com/t/invalid-json/60914/5 "2024-11-15T14:12:48Z")
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” } }] ---
**Author:** ![dilipborad](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/dilipborad/32/53211_2.png) [@dilipborad](https://community.make.com/u/dilipborad)\ **Post date:** [November 15, 2024, 5:05pm UTC](https://community.make.com/t/invalid-json/60914/6 "2024-11-15T17:05:00Z")
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. ```auto [ { "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. 👍 ---
**Author:** ![Robin\_Hahn](https://avatars.discourse-cdn.com/v4/letter/r/cab0a1/32.png) [@Robin\_Hahn](https://community.make.com/u/Robin_Hahn)\ **Post date:** [November 15, 2024, 6:00pm UTC](https://community.make.com/t/invalid-json/60914/7 "2024-11-15T18:00:37Z")
This was the hint I needed! This is the fix I added on my text aggregator lines that added line breaks. ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/c/2c19ee36a3e42031b852a603cf5b31d83b6890a1.png) Thank you so much for your help! ---
**Author:** ![dilipborad](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/dilipborad/32/53211_2.png) [@dilipborad](https://community.make.com/u/dilipborad)\ **Post date:** [November 15, 2024, 6:03pm UTC](https://community.make.com/t/invalid-json/60914/8 "2024-11-15T18:03:44Z")
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](https://community.make.com/t/make-academy-course-overview/29699) 👍 ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [November 29, 2024, 6:12pm UTC](https://community.make.com/t/invalid-json/60914/9 "2024-11-29T18:12:06Z")