How do I update a specific nested JSON property via Create or Update workflow action?

Hi there!

Thank you for posting to our community, We’re happy to help you here!

I’m afraid it is not possible to update nested JSON attributes using Liquid. The reason your current flow creates a new attribute, is because the “value” you enter in the “Attribute” field in your Create or Update Person action does not exist, so Customer.io creates an attribute with this name.

With that said, you can absolutely achieve what you’re looking for using simple JavaScript code. You would select the “Attribute” as “last_estima”, and here’s a snippet of what that code could look like:

const jsonObject = customer.last_estima;

// Convert the provided date string to a Unix timestamp
const unixTimestamp = new Date(jsonObject.date).getTime() / 1000;

// Update the "date" field in the JSON object with the Unix timestamp
jsonObject.date = unixTimestamp;

// return the updated JSON object value
return(jsonObject);

I hope this is helpful! Let us know if you run into any trouble with this!