Hey all, I am trying to write a GPT-4 generated json list to another table and I am getting "Please add a valid list here" - I tried using an intermediary column and wrapping the GPT-4 json object in a JSON.stringify like this:
JSON.stringify({{Decision-Maker Identification}}?.response?.found_decision_maker_bool == 1 ? {{Decision-Maker Identification}}?.response?.primary_decision_maker : "")And it will properly run and create something like this:
[{"country":"GB","experience":[{"company":"Terra (YC W21)","company_domain":"tryterra.co","is_current":true,"title":"Co-Founder"},{"company":"Flex Living","company_domain":"theflexliving.com","is_current":false,"title":"Co-Founder"},{"company":"Y Combinator","company_domain":"ycombinator.com","is_current":false,"title":"W21 Batch"},{"company":"PwC UK","company_domain":"pwcukcareers.com","is_current":false,"title":"Technology Risk Consultant"},{"company":"Nofalo","company_domain":"nofalo.com","is_current":false,"title":"Founder"},{"company":"Circuit Genius","company_domain":null,"is_current":false,"title":"Founder"},{"company":"Curtiss-Wright Controls","company_domain":"curtisswright.com","is_current":false,"title":"Electronic Engineer"},{"company":"B&B TOOLS","company_domain":"bb.se","is_current":false,"title":"Business Analyst"}],"first_name":"Raouf","full_name":"Raouf Yousfi","headline":"Founder @ Terra | YC (W21) I Forbes 30 under 30 I We are Hiring","last_name":"Yousfi","linkedin_url":"https://linkedin.com/in/raouf-yousfi-53914479","location_name":"United Kingdom","summary":null,"title":"Co-Founder"}]But the export to other table still throws an error - is there any way to reformat/use a formula to set it up so I can map it to columns in the other table? Thanks!
