Service Desk User Discussions
cancel

How to screlation with a scheduled script : SD's with IM's and RQ's

Highlighted
Norita Super Contributor.
Super Contributor.

How to screlation with a scheduled script : SD's with IM's and RQ's

Hi experts,  i'm working with SM 9.34 and a chatBOT with API Rest that creates interactions (SD) identified as "autogestion".  Some of that SD's are also identifided as "RECLAMO" and the RQnumber or IMnumber that must be related with the interaction.  I need to automate the "screlation" between an interaction (SD) with the RQnumber  or  the IMnumber  collected by the chatBOT
There's a few amount of that kind of interactions (50 per month) :
SD "RECLAMO" a RQnumber
SD "RECLAMO" a IMnumber

Nowadays the relation is made later manually but I need to automate it and I don't know how

Perhaps may be a scheduled script that inserts a record in the screlation table (I add an image as an example)

Any suggestion will be appreciated.  Thanks in advance.

Nora

Good questions will have Good answers
1 REPLY
Contributor.. DeBa Contributor..
Contributor..

Re: How to screlation with a scheduled script : SD's with IM's and RQ's

Did you consider using a trigger (table trigggers) After Add when one of the records is added into the system?