ADP configuration pagination issue can occur if the BatchSize in Rest Source is above 100.

ADP Connection Manager unable to retrieve all the records

Action:
When executing a package using Data Flow Task Plus to retrieve all the records.
Error:
''Unable to retrieve ."
Solution:

This issue can occur if the BatchSize in Rest Source is above 100. Previously one of the customer had reported the same issue where the solution was to keep the BatchSize to 100. Please try to set the BatchSize to 100 and re-run your package to see if that fixes the issue.


    Book a Presales Call


    Are you new to COZYROC and evaluating our solutions? 
    Book a Presales Call with us now and get 5% off SSIS+.

      • Related Articles

      • Where can I find the documentation for the ADP Connection?

        You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the ADP Connection can be found at the following link. For many of the components you can find resources ...

      • ADP Connection Manager Out of Memory Error Message

        Solution: The out of memory error occurs because of the excessive field Metadata. To overcome this issue, right click on REST SOURCE and select Advance Editor to remove the External columns and Output columns that you don't need. If there is a child ...

      • How can I retrieve updated and deleted Salesforce records?

        You can use the following reusable script with the JavaScript component to retrieve records that were deleted from Salesforce between specified dates: https://www.cozyroc.com/ssis/script-salesforce-get-deleted-source To retrieve records that have ...

      • Why the buttons on the REST Connection manager are missing?

        Problem: I am not able to configure my REST Connection Manager component. After I select "Configuration", the buttons on the REST Connection manager screen are gone, they are missing . Look at the screenshot below: Solution: A possible reason for ...

      • NetSuite Source: How to retrieve transaction records like Sales Orders

        Sales order records are found under the general transactions record. To retrieve them, specify a SearchXml statement. For sales order records, specifically, you can use the following statement: 1 2 3 4 5 <TransactionSearchBasic>   <type ...