Avatar

Community Advisor

Hi Szymons,


When you implement the custom method, you define a parameter for ID list.
Either it will be a varchar and you are limited by the underlying RDBMS (such as varchar(4000) as common, or varchar(8000) and equivalent nvarchar etc).

So for storing the list value for a varchar(4000), it is 363 values that you can put, if comma separated. If it is JSON, well a bit less, and for XML lesser.

So either you split your API calls into N calls of 363 values of ID.


Or you use a TEXT / BLOB column type, that is said memo type or XML type in Adobe Campaign, it means very large (in GB) value so no problem of length for very long content as parameter (as for MessageCenter rtEvent context parameter).

Regards

J-Serge