Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Salesforce Input tool Limit restriction limit?

LiuZhang
9 - Comet

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 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Salesforce-Input-Tool-amp-Going-Beyond....

 

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

limited connection.png

2 REPLIES 2
BrandonB
Alteryx
Alteryx

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? 

LiuZhang
9 - Comet

Thanks, it is fine now as I can download more rows.

I guess something has changed in the background, maybe more rows are loaded.

Labels