Cannot retreive more than 2000 rows without a unique ID in Salesforce Connector.

art_in_sky
art_in_sky Contributor

I am trying to extract data from a tabular report in salesforce which has almost 155,550 rows. I am unable to retrieve the data as it requires a unique ID, My report does not seem to have a unique ID column. Without unique ID I can only fetch 2000 rows. How would I be able extract the entire data without unique ID, The report is a standard report from Salesforce formed from custom objects.

Tagged:

Best Answer

  • ggenovese
    ggenovese Coach
    Answer ✓

    The connector requires a unique id in order to retrieve more than 2,000 rows. You'd need to add a unique id to your report or you'd have to construct a SOQL query that replicates the report

    image.png

Answers

  • ggenovese
    ggenovese Coach
    Answer ✓

    The connector requires a unique id in order to retrieve more than 2,000 rows. You'd need to add a unique id to your report or you'd have to construct a SOQL query that replicates the report

    image.png