Parsing JSON with multiple nested objects

dfah · 2025-01-01T15:21:24.345Z

Hi,

I’m trying to parse a number of objects and nested objects that I receive back from the chatgpt API. When I receive a response from the API in JSON, I process this via backend workflow and have used the detect data function to in order to ingest the data. Where I am getting stuck is I can process the top object in the JSON below, but when creating records from objects below the first object, I cannot create an association, since the data type is defined as text and not a thing in bubble. Any idea how this can be done? I’ve been stuck on this for quite a while now and it is driving me mad!

{
“first_name”: “”,
“last_name”: “”,
“job_title”: “”,
“address_city”: “”,
“address_country”: “”,
“email”: “”,
“phone_number”: “”,
“profile_summary”: “”,
“employment_history”: [
{
“employer_name”: “”,
“location”: “”,
“employment_roles”: [
{
“role_title”: “”,
“current_role”: false,
“start_date”: “”,
“end_date”: “”,
“experiences”: [
{
“experience”: “”
}
]
}
]
}
],
“education”: [
{
“city”: “”,
“degree”: “”,
“description”: “”,
“start_date”: “”,
“end_date”: “”,
“school”: “”
}
],
“skills”: [
{
“skill”: “”,
“years_of_experience”: “”
}
],
“links”: [
{
“label”: “”,
“url”: “”
}
]
}

mitchbaylis · 2025-01-01T22:59:31.158Z

you can add another schedule api on list step to the receiving api workflow and then iterate the items in that second api workflow (the array shows as a thing in the data for that workflow)

dfah · 2025-01-02T10:44:32.561Z

That works for assigning roles to employers, but assigning the nested experience is tricky. Since I have to send it over as list of texts, how do I know how to assign which experience to the role?