I have a JSON block that I am trying to extract Keys and Values from, after receiving it from OpenAI. I have been bashing my head against the wall with ChatGPT and Gemini on this one:
This is the actual JSON I need to extract KVP data from:
{
“Jobs”: [
{
“JobTitle1”: “Co-Founder”,
“JobDescription1”: “Co-founded a consultancy focused on business operations and project management for technology-driven projects.”,
“JobIndustry1”: “Consultancy, Technology”,
“JobTitle2”: “CTI and Business Operations Architect”,
“JobDescription2”: “Delivered strategic consulting services to clients such as AT&T, Verizon, IBM and Deutsche Telekom.”,
“JobIndustry2”: “Independent Consulting, Technology”,
“JobTitle3”: “Senior CTI/CRM Consultant”,
“JobDescription3”: “Led the design and deployment of CRM solutions and CTI systems for large-scale banking operations.”,
“JobIndustry3”: “Banking, BNP Paribas”
}
]
}
I need to use the “Get Results of Previous Step” in the correct manner to extract each of the Values and their associated Keys, such as JobTitle1 as the Title and then the associated Value (Co-Founder), etc.
As I understand it, bubble only allows me to reach down into the JSON content element level by using …choices:first item’s message content - but how to actually identify and extract each KVP within that content is beyond me.
I think I should be using Regex to extract the Fields - but none of the Regex typical scripts return anything at all (example: (?<=JobTitle1":“)(.*?)(?=”) )
If there is a plug in, process, procedure, script or approach I should be taking here, I would appreciate any insights - thanks!