appsheet webhook not writing parent data inside <<start expression

[jairod]

I am running an automation bot with a json webhook task to the appsheet api with a <<start :[related child table] expresion.

{
"Action": "Add",
"Properties": {
"Locale": "en-US"
},
"Rows": [ <<Start: [Related Part BOMs]>>
{
"codigo":"[_THISROW-1].[SKU]",
"productID":"<<[ID]>>",
"nombre":"<<[nombre]>>",
"material":"<<[material]>>",
"cantidad":"<<[cantidad]>>",
"udm":"<<[udm]>>"
},
<<End>>]
}

I´m using the [_THISROW-1].[SKU] to access the parent table "SKU" record, but it won´t write it to the table, all the related child records are written fine.

CHILD TABLE

What am I doing wrong?

[WillowMobileSys]

We are missing some important details.  I understand you have Parent and Children.  Are you adding both Parent and Children before saving? When does the automation run?  On Parent ADD?

[jairod]

I´m copying the child records with an "execute sequence of actions" action which first asks for an input (the ID which will be used as the new parent) writes it to the parent table to the "NextParent" column, then sets a "trigger" value which fires the automation "on add", runs the aforementioned webhook task and lastly clears the trigger column.

initial actionbot eventtrigger and next parent records