Appflow using Microsoft sharepoint always downloads all files for every App flow run and other questions

Dear Customer,

Thanks for reaching out with your inquiry. I understand that you are seeking assistance for your queries.

Kindly allow me to address your queries in detail:

Query 1: How can we enable this to incremental sync for every on-demand flow run it should download only changed/added files only?

---> The scope of the output depends on whether you configured the flow to run on a schedule or run on demand:

If the flow runs on a schedule, Amazon AppFlow performs incremental data transfers. When the flow runs for the first time, Amazon AppFlow transfers every document in the document libraries that you chose in the data source configuration. Then, for all subsequent flow runs, Amazon AppFlow transfers only those files that you created or changed in SharePoint since the prior flow run.

To configure a flow to run on a schedule, you can use the console to set the schedule settings under Flow trigger in the flow creation process.

If the flow runs on demand, Amazon AppFlow performs full data transfers. For every flow run, Amazon AppFlow transfers every document in the document libraries that you chose in the data source configuration.

To configure a flow to run on demand, you can use the console to set this option under Flow trigger in the flow creation process. After you create an on-demand flow, you run the flow by choosing Run flow on the flow details page.

[+] https://docs.aws.amazon.com/appflow/latest/userguide/connectors-microsoft-sharepoint-online.html

Query 2: How can we enable to only download only files not the folders from SharePoint library?

---> The SharePoint connector in Amazon AppFlow does not offer a direct feature to exclude folders from a transfer. When you select a document library or folder as a "resource" in the flow configuration, AppFlow transfers all items within it, including subfolders and their contents.

Query 3: 3) Can this App flow be created/executed using API and exhibit the above behaviour?

---> Users can manage connections by using the following actions in the Amazon AppFlow API:

[+] https://docs.aws.amazon.com/appflow/1.0/APIReference/Welcome.html

Some examples are listed below:

CreateConnectorProfile – Creates a connection. https://docs.aws.amazon.com/appflow/1.0/APIReference/API_CreateConnectorProfile.html

DescribeConnectorProfiles – Provides details about your connections. https://docs.aws.amazon.com/appflow/1.0/APIReference/API_DescribeConnectorProfiles.html

UpdateConnectorProfile – Edits a connection. https://docs.aws.amazon.com/appflow/1.0/APIReference/API_UpdateConnectorProfile.html

DeleteConnectorProfile – Deletes a connection. https://docs.aws.amazon.com/appflow/1.0/APIReference/API_DeleteConnectorProfile.html

I hope the above answers all your queries. Please feel free to revert if any of your queries were missed answering or misunderstood.

Thank you!!