The remote server returned an error (429)' when using Sharepoint Online.

Error Message: 'The remote server returned an error (429)' when using Sharepoint Online.

Summary
The error 429 is related to throttled or blocked in Sharepoint Online when sending too many requests as mentioned here Avoid getting throttled or blocked in Sharepoint Online SharePoint Online API requests occasionally return a 429 error, indicating that request throttling limits have been exceeded. This KB article outlines steps to address and mitigate 429 errors when interacting with SharePoint Online.
Action
When using Sharepoint Online for Reading or Writing data, the following error is received.
Error Message:
An error occurs with the following error message:
"System.Net.WebException: The remote server returned an error (429)"
Solution:
Upon receiving a 429 error, implement retry logic in your package.

    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

      • Error Message: An existing connection was forcibly closed by the remote host

        Action When making a request to a service connection, the following error message was returned. Error Message Error Message: An existing connection was forcibly closed by the remote host Solution The error message can be somewhat generic across ...
      • SharePoint - Error Message: Object Reference not set to an instance of an object.

        Action: We started getting an error from a component which copies a file to an Office 365 SharePoint site. This upload has been working fine for months and no deployments have been made to it. The error is happening both on the deployed version and ...
      • Error Message: The operation has timed out.

        Action: When moving data into a SharePoint list using the SharePoint Destination component, the following error intermittently occurs. Error Message: The operation has timed out. Solution: Try increasing the timeout parameter in the Sharepoint ...
      • Error Message: unable to connect to remote server

        Action:           When I run my SSIS+ package for transferring data from Salesforce Source to Salesforce Destination I get the following error message: Error Message: Unable to connect to remote server Solution:                        The reason for ...
      • Error Message: "Could not initialize component for use in the designer."

        Action:  While creating a new CRM destination, the following error is encountered. Error Message: TITLE: Microsoft Visual Studio ------------------------------   The component could not be added to the Data Flow task. Verify that this component is ...