Troubleshooting JSON Parsing Issues in AI Prompts

Scott S. · 2025-09-04 15:52:45.025359+00

Hi team - i’m having trouble parsing information from a large AI prompt into separate columns. I’m not a coder and am using ChatGPT to try and help figure it out. I keep running into parsing errors. GPT is telling me to use the formula function but it’s not working. Is that the best way or is there another way to parse out different sections of a large JSON blob inside the output of an AI column?

Troubleshooting JSON Parsing Issues in AI Prompts | Clay

Scott S.
·
·
https://app.clay.com/workspaces/295465/workbooks/wb_0t20wnkz8BMedgGKrjD/tables/t_0t20wp3esBoGgqk9gGa/views/gv_0t20wp3J2jPwkoATXVo
Scott S.
·
·
thanks Sayli G.. I’m looking at the last two columns (which are basically the same) and need to pull out a few different values: Core fields
Account Summary
parse_json({{V4_FlatJSON}}, "$.AccountSummary")
EDP Title
parse_json({{V4_FlatJSON}}, "$.EDP1_Title")
EDP Why Urgent
parse_json({{V4_FlatJSON}}, "$.EDP1_WhyUrgent")
Evidence #1
parse_json({{V4_FlatJSON}}, "$.EDP1_Evidence1")
Evidence #2
parse_json({{V4_FlatJSON}}, "$.EDP1_Evidence2")
PVP #1 snippets
PVP1 Title
parse_json({{V4_FlatJSON}}, "$.EDP1_PVP1_Title")
PVP1 Live Demo Insight
parse_json({{V4_FlatJSON}}, "$.EDP1_PVP1_LiveDemoInsight")
PVP1 Why Valuable
parse_json({{V4_FlatJSON}}, "$.EDP1_PVP1_WhyValuable")
PVP1 CTA
parse_json({{V4_FlatJSON}}, "$.EDP1_PVP1_CallToAction")
Scott S.
·
·
This is what I see when i try to create the formula.
Loading attachments
Scott S.
·
·
but nothing populates
Scott S.
·
·
Loading attachments
Scott S.
·
·
also, it would be great to be able to do all the fileds at once vs having to do this like 10 times. wonder if there’s an easier way to do this
Scott S.
·
·
I’ve done this a lot where the parsing happens in the AI prompt and it automatically outputs the JSON blob into sections that are easily referenceable… but for whatever reason it wasn’t working.
Scott S.
·
·
i’m sure i was doing something wrong
Scott S.
·
·
okay thanks!
Scott S.
·
·
i feel like there is one small thing that i’m not doing right. would love to figure out what it is to simplify this in the future
Sayli G.
·
·
I can see V4 Industry Report has been formatted correctly. As you can see the fields are setup correctly. I think honestly just adding fields in each setup will solve the issue.
Loading attachments
Scott S.
·
·
so just manually create the fields in the AI column for the datapoints i want, making sure to keep the formatting the same and it should magically work?
Scott S.
·
·
i hadn’t tired that yet. … GPT was pushing me to do this all in JSON… but if it’s that easy i’m going to punch myself
Scott S.
·
·
🤣
Scott S.
·
·
HAHAHAHAHA… it worked

17 comments