I am using Salesforce Input tool, but the results is always limited to 1000 rows (see pic for validate response)
From the search, a 2019 post, it was stated it is set to limit 2000
But in the new Salesforce Input tool, there is nothing I can see about pagination to run an macro on it.
Any suggestions to get more data out?
Tool version: 2022.1 (I think, it is hard to checksales)
Alteryx Designer version: 2021.3.5
Solved! Go to Solution.
The SalesForce API has that limit on reports, not on SOQL queries (SalesForce limit, not Alteryx limit). Are you sure that there are more than 1000 records from the table that you are pulling from?
Thanks, it is fine now as I can download more rows.
I guess something has changed in the background, maybe more rows are loaded.