I’m creating a custom JSON body format using a formula, but when i save the HTTP enrichment column it seems to be wiping it away. Is this expected behavior? More info in the thread here
This isn't expected behavior - your custom JSON body should persist when saving the HTTP enrichment column.
Common causes include JSON formatting issues that prevent proper saving. When using dynamic variables with /column, ensure strings have quotation marks but numbers don't (except numbers with trailing zeros like 0004).
Could you copy and paste your JSON body into the chat so I can help troubleshoot the specific formatting issue?
{ "agentOId": "ca_7bzGsaxsFDyS4Jjg2ASP1", "jobTitle": "' + Clay.formatForJSON({{Title}}) + '", "companyDomain": "' + Clay.formatForJSON({{Contact Company Website}}) + '", "companyName": "' + Clay.formatForJSON({{Company Name}}) + '", "firstName": "' + Clay.formatForJSON({{Webhook}}?.first) + '", "linkedInProfile": "' + Clay.formatForJSON({{Linkedin FINAL}}) + '", "runtimeContext": { "1": "", "2": "", "3": "", "4": "", "all": "Li profile summary - ' + Clay.formatForJSON({{LinkedIn Profile Summary (AT)}}) + ' recent posts - ' + Clay.formatForJSON(Array.isArray({{Filter Recent Posts}}?.Recent_Profile_Posts) ? {{Filter Recent Posts}}?.Recent_Profile_Posts.join(' | ') : {{Filter Recent Posts}}?.Recent_Profile_Posts) + ' media mentions - ' + Clay.formatForJSON({{Lookup Media Mentions}}) + ' Podcasts -' + Clay.formatForJSON({{Podcast Episode Summaries}}?.podcasts) + ' youtube videos - ' + Clay.formatForJSON({{Combined Transcript Summary}}) + ' " }, "runtimeInstructions": { "1": "", "2": "", "3": "", "4": "", "all": "everything shared here is research we've conducted on this contact that can potentially be used to personalize an email to them and to give it a better chance of being answered. specifically here is a breakdown of each category. LI profile summary is a linkedin summary of the persons profile. recent posts is the content of any recent posts the person has made on linkedin. media mentions is any articles they were quoted in or that were about the contact. podcast is the summary of any podcasts that they were on recently. youtube videos is the transcript summary of any youtube videos they were on recently." }, "lang": "en" }
I can see you're experiencing issues with your JSON body being wiped when saving the HTTP enrichment column. This typically happens due to JSON formatting errors that prevent proper saving. Could you copy and paste your JSON body from the formula column into this chat? This will help me identify the specific formatting issue causing the problem. Common causes include missing quotation marks around dynamic string variables, extra commas, or syntax errors that prevent the JSON from being parsed correctly.
I found the issue with your JSON body. There's a syntax error in the "runtimeContext" section - you have an extra space and quote after "youtube videos" that's breaking the JSON format.
**Fix this line::**LBKS```LBKS"all":: "Li profile summary - ' + Clay.formatForJSON({{LinkedIn Profile Summary (AT)}}) + ' recent posts - ' + Clay.formatForJSON(Array.isArray({{Filter Recent Posts}}?.Recent_Profile_Posts) ? {{Filter Recent Posts}}?.Recent_Profile_Posts.join(' | ') : {{Filter Recent Posts}}?.Recent_Profile_Posts) + ' media mentions - ' + Clay.formatForJSON({{Lookup Media Mentions}}) + ' Podcasts -' + Clay.formatForJSON({{Podcast Episode Summaries}}?.podcasts) + ' youtube videos - ' + Clay.formatForJSON({{Combined Transcript Summary}}) + ' "LBKS**Should be:**LBKS"all": "Li profile summary - ' + Clay.formatForJSON({{LinkedIn Profile Summary (AT)}}) + ' recent posts - ' + Clay.formatForJSON(Array.isArray({{Filter Recent Posts}}?.Recent_Profile_Posts) ? {{Filter Recent Posts}}?.Recent_Profile_Posts.join(' | ') : {{Filter Recent Posts}}?.Recent_Profile_Posts) + ' media mentions - ' + Clay.formatForJSON({{Lookup Media Mentions}}) + ' Podcasts -' + Clay.formatForJSON({{Podcast Episode Summaries}}?.podcasts) + ' youtube videos - ' + Clay.formatForJSON({{Combined Transcript Summary}}) + '"```Remove the extra space and quote before the closing quote. This formatting error prevents the JSON from saving properly.
Testing this now
Same issue
still isn’t showing up in the text w/ tokens view. new json definition i’m using: { “agentOId”: “ca_7bzGsaxsFDyS4Jjg2ASP1", “jobTitle”: “' + Clay.formatForJSON({{Title}}) + ‘“, “companyDomain”: “’ + Clay.formatForJSON({{Contact Company Website}}) + ‘“, “companyName”: “’ + Clay.formatForJSON({{Company Name}}) + ‘“, “firstName”: “’ + Clay.formatForJSON({{Webhook}}?.first) + ‘“, “linkedInProfile”: “’ + Clay.formatForJSON({{Linkedin FINAL}}) + ‘“, “runtimeContext”: { “1": “”, “2": “”, “3": “”, “4": “”, “all”: “Li profile summary - ’ + Clay.formatForJSON({{LinkedIn Profile Summary (AT)}}) + ' recent posts - ' + Clay.formatForJSON(Array.isArray({{Filter Recent Posts}}?.Recent_Profile_Posts) ? {{Filter Recent Posts}}?.Recent_Profile_Posts.join(' | ‘) : {{Filter Recent Posts}}?.Recent_Profile_Posts) + ’ media mentions - ' + Clay.formatForJSON({{Lookup Media Mentions}}) + ' Podcasts -' + Clay.formatForJSON({{Podcast Episode Summaries}}?.podcasts) + ' youtube videos - ' + Clay.formatForJSON({{Combined Transcript Summary}}) + ’” }, “runtimeInstructions”: { “1”: “”, “2”: “”, “3”: “”, “4”: “”, “all”: “everything shared here is research we’ve conducted on this contact that can potentially be used to personalize an email to them and to give it a better chance of being answered. specifically here is a breakdown of each category. LI profile summary is a linkedin summary of the persons profile. recent posts is the content of any recent posts the person has made on linkedin. media mentions is any articles they were quoted in or that were about the contact. podcast is the summary of any podcasts that they were on recently. youtube videos is the transcript summary of any youtube videos they were on recently.” }, “lang”: “en” }
Any updates here?
Hey there - Happy to take a look at this now. Just to confirm, is the issue that in the Octave (Research Only) column, your JSON payload isn't saving?
Yes. Also, related but unrelated, but I’m not able to see the outbound payload for the HTTP requests. Is there a log somewhere?
Hey there - I was just able to copy and paste in that JSON for you and it seems to have saved - you should be able to go in and include the column references now. Which column specifically are you looking for the outbound payload?
Really any HTTP column
