Salesforce data getting only 200 rows

[ba19c1e84c03a81430ebd2ea1 (Uipath)]

Hi Team,

Im using soql to fetch data from saleforce, its working fine, but after moving to prod, we found it is giving only top 200 rows. Also tried get records and soql queries. Can some one give some info or provide any workarounds. Checked with IT team, they have kept this 200 limit , and not ready to change.

[ashokkarale]

@ba19c1e84c03a81430ebd2ea1

Recently a member faced similar blocker. Here is what worked for him.

Salesforce List all records of +100k rows

Thank you, the idea is indeed to use Bulk Job. Here’s how i managed to get the data : Use the Create Bulk Download Job using SOQL to start a Job in Salesforce. Inside a Do While, check the Job State with the Get Bulk Job Info activity until we get “JobComplete” state (All states here) Finally, download the csv file containing query result with the Download SOQL Bulk Job Results activity.

[MohammedShabbir (shabbir.qs)]

This thread may be helpful.

1. Use the Create Bulk Download Job using SOQL to start a Job in Salesforce.
2. Inside a Do While, check the Job State with the Get Bulk Job Info activity until we get “JobComplete” state (All states here)
3. Finally, download the csv file containing query result with the Download SOQL Bulk Job Results activity.

Salesforce List all records of +100k rows - Help / Studio - UiPath Community Forum

[yedukondaluaregala]

@ba19c1e84c03a81430ebd2ea1

Look at below thread, same kind of issue someone faced and he got the solution as well

Salesforce List all records of +100k rows

Hello, I am using Salesforce IntegrationService “List all records” to get records from the object Product2. The ouput should be around 100k+ rows. But it returns only 250 rows When i try to increase the “Max record” Int value, it doesn’t works. Is there a way to fetch 100k+ rows using IntegrationService activities ?

if this post helpful please mark it as solution!
Happy automation

[Monali_Vekariya (Mona)]

Hi @ba19c1e84c03a81430ebd2ea1

In Salesforce, SOQL returns only 200 records per batch by default. Since the limit can’t be changed, use pagination—loop with queryMore or split queries (e.g., by date or ID) to fetch all records in multiple calls.

[Anil_G (Anil Gorthi)]

@ba19c1e84c03a81430ebd2ea1

As the limit is present from Salesforce side..you might need to use skip till you get all records you need and run query in loop

cheers