[sc-143215] Adding an "append to list" recipe

[shortcut-integration[bot]]

This pull request has been linked to Shortcut Story #143215: [SharePoint Online] Keep the list id when overwriting the list's content.

[alexbourret]

Hi @liamlynch-data ! Here are some answers:

1. This recipe is restricted to append mode. The write_mode selector in recipe.json is hidden ignored in the recipe itself, where the value is forced to append. The option is indeed available in the sync recipe, but until now it is not passed to plugins. (it actually raise an error if used)
2. Output is mandatory to recipe. The concept of the flow is more about building datasets rather than running the recipes that produce these datasets.
3. It could be done, we'll discuss it

[liamlynch-data]

Hi @liamlynch-data ! Here are some answers:

1. This recipe is restricted to append mode. The write_mode selector in recipe.json is hidden ignored in the recipe itself, where the value is forced to append. The option is indeed available in the sync recipe, but until now it is not passed to plugins. (it actually raise an error if used)
2. Output is mandatory to recipe. The concept of the flow is more about building datasets rather than running the recipes that produce these datasets.
3. It could be done, we'll discuss it

Re 1 - thanks - I see now I mis-understood the input/output config, where this is selecting it for the DSS dataset output not for the sharepoint one.

2. I see, I thought it might be something like that.
3. Ok - not a blocker for this PR though, IMO

[liamlynch-data]

@alexbourret - have you addressed everything you want to now? Shall I re-review?

[liamlynch-data]

@alexbourret that's for those last couple of changes - all looks good, and I did a quick retest and all was still working fine for me.