session.Write 10000 records limit

Forum|Forum|8 years ago
August 21, 2018
4 replies
3576 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by Adhiyan

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

RaulOcanaAuthor

Level 3

Hi Adhiyan,

thank you, I'll do that.

- Raúl

AdhiyanAccepted solution

Employee

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

RaulOcanaAuthor

Level 3

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

vraghav

Employee

Hi Raul,

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

Regards,
Vipul

Sign up

Login with SSO

Login to the community

Login with SSO