session.Write 10000 records limit

[#1]

Hi guys,

We have a Javascript code in a workflow that reads the whole database and updates a field. The problem is that it only updates the first 10.000 records so have to re-run it each time it finshes.

How can we overwrite that limit? By paging or something similar? I'm new to the platform so I don't understand the SDK or the coding limitations.

Thank you!

- Raul

[#2 · Accepted solution]

Hello Raul,

This is a limitation of the API when you use the querydef function.

The workaround is to use an attribute like noLineCount="1" or lineCount="<max_records>" inside the JS to overcome the limitation .

Else, you the OOB update data activity which does not have any such limitation as Vipul suggested

Regards,
Adhiyan

[#3]

Hi Adhiyan,

thank you, I'll do that.

- Raúl

[#4]

Hi Vipul,

Yes, we are encrypting a couple of values that we have stored, so we have the whole algorithm there and the update. It is a one time bulk update, after that, it will be updating the records on a weekly basis and there won't be more than 10.000.

- Raul

[#5]

Hi Raul,

Any specific reason to perform updates using session.Write JS code and not using the out of box activity?

Regards,
Vipul