Delete multiple records at once

[Dick Honing]

I'm trying to delete multiple records at once and for this purpose I create an SQLSELECT API with the following Source Code:

DELETE FROM Data WHERE id IN ( @PARAM_DATA )

If I test this with only one id, this works:

{
"DATA": "(8970538)"
}

But as soon as try multiple id's, I get an error ... Operand should contain 1 column(s).

What might I be doing wrong? And/or is there a better approach for deleting multiple records at once?

Thanks in advance for your help!

[Wassim]

Hey,

You wrote that your query is :

DELETE FROM Data WHERE id IN ( @PARAM_DATA )

So the computed query would be nested parenthesis no?

DELETE FROM Data WHERE id IN ( (8970538,14361538) )

Maybe try without parenthesis in the input parameters section?

[Dick Honing]

that seems to do the trick! @Wassim thanks!