Hello everyone.
I have a question related to the use of the API in AppSheet.
My App have three tables:
1 - “Anclajes clasificacion”, that contais data related to a key named “ID Anclaje”
2 - “Lectura escaneo”, where I entry data
3 - “Registros tensado”, where I want to write new rows from the data of “Lectura escaneo”, using the API
For that porpuse I made a Bot. When a new record in “Lectura escaneo” is created, it triggers a task that write certain number of rows in the “Registros tensado” table, acording with a condition in “Anclajes clasificacion” table.
Even when the test of the bot is working and in the monitor it appears to have no problem, the secuence is not working. I hope you can help me, seening the body of the HTTP request that follows and the sceen captures I attached to this message.
Best regards.
HTTP request:
{
“Action”: “Add”,
“Rows”: [
<<Start: SELECT(Anclajes clasificacion[ID Anclaje],[Clasificación 3]=[_THISROW].[Clasificación 3])>>
{
“ID Registro”: “<<UNIQUEID()>>”,
“Fecha”: “<<TEXT([_THISROW].[Fecha],“dd-mm-yyyy”)>>”,
“Operador”: “<<[_THISROW].[Operador]>>”,
“Clasificación 1”: “<<[Clasificación 1]>>”,
“Clasificación 2”: “<<[Clasificación 2]>>”,
“Clasificación 3”: “<<[Clasificación 3]>>”,
“Fase”: “1”,
“ID Conjunto”: “<<[ID Anclaje]>>”,
“Longitud final E2 (mm)”: “<<IF([Anclaje]=1,[_THISROW].[Estiramientos 1.1],
IF(Anclaje]=2,[_THISROW].[Estiramientos 2.1],
IF(Anclaje]=3,[_THISROW].[Estiramientos 3.1],
IF(Anclaje]=4,[_THISROW].[Estiramientos 4.1],
IF(Anclaje]=5,[_THISROW].[Estiramientos 5.1],”“)))))>>”,
“Estiramiento final (mm)”: “<<IF([Anclaje]=1,[_THISROW].[Estiramientos 1.2],
IF(Anclaje]=2,[_THISROW].[Estiramientos 2.2],
IF(Anclaje]=3,[_THISROW].[Estiramientos 3.2],
IF(Anclaje]=4,[_THISROW].[Estiramientos 4.2],
IF(Anclaje]=5,[_THISROW].[Estiramientos 5.2],”“)))))>>”,
“Usuario”: “<<USEREMAIL()>>”
}
<>
]
}