OK awesome. That worked, and its allowing me to use jsonPath to filter! as described by you and @Paul_Danyliuk here: Filtering with ParseJSON - #2 by Paul_Danyliuk
So that’s great! But I’m curious now how to ‘do json right’ in coda? For example I have this jsonHistory column in my table. When I have a new entry, I am using object() to create the newJson, then I am using listcombine(newJson,jsonHistory) to append it.
This has been working (except for this use case). Should I be using join() instead of listcombine()? Do I need to add the {“o”:[ … ]} each time? What is the best practice here @Agile_Dynamics ?