LinkedIn
Twitter
I am setting up a bot with the intention of filling a series of records in the child table when inserting a record in the parent table. The records to be inserted come from a parameters table. The SELECT query is correct and generates the records as expected.
The problem is that I cannot insert the parent record's ID into the child table; I get the following error:
Properties: { "RestAPIVersion": 2, "TableName": "tbl_au_task", "Action": "Add", "RestActionType": "Add", "DataAction": "App: add a new row (not a row-level action)", "locale": "en-US", "runAsUserEmail": "", "selector": "", "timezone": "Central Standard Time", "userId": 824396116, "Rows": 7, "AppTemplateVersion": "3.000818", "RowSize": 322, "AppTemplateName": "391ba874-46b1-4e88-9286-d6da9ed0027c", "Operation": "REST API invoke", "RecordType": "Stop", "ResultSuccess": false, "Errors": "Error: Can't add or update a row because of an invalid value. Update the value and try again.\n\n\tRow ID to correct: dd5f3bd6 \n\tInvalid value for column audit_id: 630693d9", "StatusCode": "BadRequest", "Performance"...: "Result": "Failure" }
However, that audit_id value is correct. If I insert it manually, it works fine.
What am I doing wrong?
This is the bot:
{
"Action": "Add",
"Properties": {
"Locale": "en-US",
"Timezone": "Central Standard Time"
},
"Rows": [
<<Start: SELECT(zprm_task_audit[id],[audit_tipo_id]=[_THISROW].[au_tipo]) >>
{
"id": "<<UNIQUEID()>>"
,"marcatiempo": "<<NOW()>>"
,"usuario":"<<USERSETTINGS('Usuario')>>"
,"audit_id": "<<[_THISROW].[id]>>"
,"tsk_id": "<<[id]>>"
}
<<End>>
]
}
