Delete record in DB using jitterbit script

262 views Asked by At

I am trying to delete a record sing record Id in DB. Am using jitterbit script.

I have tried below script:

<trans>
$recIdVar = "003M000001I8PtGIAV"; 
DBExecute("<TAG>endpoint:database/My Database</TAG>", "Delete From Contact where Id ="+Quote($recIdVar),
  "1");

Its giving me below error:

Failed to test expression: DBExecute failed to execute SQL statement "Delete From Contact where Id ="003M000001I8PtGIAV"". 'endpoint:database/My Database' is not a valid Source/Target identifier. Error occurred when evaluating function at line 3 DBExecute(

</trans>
0

There are 0 answers