UPDATE RECORDS WITH WEBHOOK CALL (APSHEET API)

 

I'm trying to update the values ​​of multiple child records using an automation that calls a webhook.

2024-01-25 11_47_10-● edit new id - api - Visual Studio Code.png

my API body is this:

{
"Action": "Edit",
"Properties": {
"Locale": "en-US"

},
"Rows": [
<<START: [PREVIOUS_PIANO_ID].[Related INTERVENTI_RADICALIs]>>
{ "IDINT" : "<<[IDINT]>>",
"NEXT_INT_ID" : "<<UNIQUEID()>>",
"PREVIOUS_INT_ID" : "<<[IDINT]>>"
}
<<END>>
,
<<START: [PREVIOUS_PIANO_ID].[Related INTERVENTI_FOGLIARIs]>>
{ "IDINT" : "<<[IDINT]>>",
"NEXT_INT_ID" : "<<UNIQUEID()>>",
"PREVIOUS_INT_ID" : "<<[IDINT]>>"
}
<<END>>
,
<<START: [PREVIOUS_PIANO_ID].[Related RIGHE INTERVENTI RADICALIs]>>
{ "IDRIGA" : "<<[IDRIGA]>>",
"NEXT_INT_ID" : "<<UNIQUEID()>>",
"PREVIOUS_INT_ID" : "<<[IDINT]>>"
}
<<END>>
,
<<START: [PREVIOUS_PIANO_ID].[Related RIGHE_INTERVENTI_FOGLIARIs]>>
{ "IDRIGA" : "<<[IDRIGA]>>",
"NEXT_INT_ID" : "<<UNIQUEID()>>",
"PREVIOUS_INT_ID" : "<<[IDINT]>>"
}
<<END>>
]
}

the automation runs successfully, but the values ​​are not actually updated.

2024-01-25 11_44_08-Impostazioni.png2024-01-25 11_43_54-AppSheet Monitoring.png

I am not an expert in these functions but the answer seems to report the values ​​to be updated but these are not inserted.

2024-01-25 11_44_47-AppSheet Monitoring.png


Task Properties
{"Response":"","Task Type":"Webhook","Task Name":"IMPOSTA ID FIGLI E NIPOTI Task - 1","Url":"https://api.appsheet.com/api/v2/apps/6ad36934-6c77-408c-aaaf-c6b35a5ae87b/tables/PIANI/Action","Verb":"Post","MimeType":"application/json","Headers":"applicationAccessKey:V2-BGQUW-2qd7n-I3fqH-UPlgG-htOPv-DZaqZ-IjOgh-ETnBV, _webhookActionDepth:0","Payload":"{\"Action\": \"Edit\",\"Properties\": {\"Locale\": \"en-US\"},\"Rows\": [{ \"IDINT\" : \"9c6897c6\",\"NEXT_INT_ID\" : \"efd9a72f\",\"PREVIOUS_INT_ID\" : \"9c6897c6\" },{ \"IDINT\" : \"a5052446\",\"NEXT_INT_ID\" : \"02a6ca69\",\"PREVIOUS_INT_ID\" : \"a5052446\" },{ \"IDINT\" : \"08231fae\",\"NEXT_INT_ID\" : \"f8ddebed\",\"PREVIOUS_INT_ID\" : \"08231fae\" },{ \"IDRIGA\" : \"7a448498\",\"NEXT_INT_ID\" : \"0f7bf3b2\",\"PREVIOUS_INT_ID\" : \"9c6897c6\" },{ \"IDRIGA\" : \"4bd80505\",\"NEXT_INT_ID\" : \"f08bfeaf\",\"PREVIOUS_INT_ID\" : \"08231fae\" },{ \"IDRIGA\" : \"d94253ca\",\"NEXT_INT_ID\" : \"615b9786\",\"PREVIOUS_INT_ID\" : \"a5052446\" },{ \"IDRIGA\" : \"4c7ba85f\",\"NEXT_INT_ID\" : \"dd9545d1\",\"PREVIOUS_INT_ID\" : \"08231fae\" },{ \"IDRIGA\" : \"be91d032\",\"NEXT_INT_ID\" : \"4c2e1d71\",\"PREVIOUS_INT_ID\" : \"a5052446\" }]}"}

What am I doing wrong?

0 0 49
0 REPLIES 0
Top Labels in this Space