Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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?

leozhang2work
10 - Fireball

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? 

leozhang2work
10 - Fireball

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
Top Solution Authors