To get 2000+ records in Salesforce connector uipath

[brindhaS (Brindha)]

There is limitations of extracting records upto 2000 records there is 8000 + records in my report .I want to get all records bis there is any way.please help me to solve

[Lwissitoon (Luis Mateo)]

Hello there ,
What method are you using? data scraping?

[Cristian_Negulescu]

Hello Brindha,
In this video, I show how to download reports without a limit:

UiPath print a report with more than 2000 rows from Salesforce | RPA | Repot no limit | more 2000

Thanks,
Cristian Negulescu

[Eric_Liu_CA (Eric Liu)]

Hi Cristian,

I downloaded this package and right now I am trying to use Get BIG Data just as you showed in the video. However, same SOQL that works in Get Data SOQL does not work in Get BIG DATA.

[NO DATA
System.Exception: System.NullReferenceException: Object reference not set to an instance of an object.
at UiPathTeam.Salesforce.Lightning_Platform.CmdRestAPI.d__61.MoveNext()
at UiPathTeam.Salesforce.Lightning_Platform.CmdRestAPI.d__61.MoveNext()
]

I am using version 1.0.0.866. How can I fix this?

[Cristian_Negulescu]

Hello Eric,
From what I remember there is a limitation on type SOQL inside of BIG DATA.
in BIG DATA you are allowed only with simple SOQL like SELECT Name,Id FROM Account
You are NOT Allowed to do nested stuff like SELECT Id,Name,Account.Name FROM Opportunity
Thanks,
Cristian