Rerun all integrations for all submissions?

[adrianjean]

Question

Is it possible to rerun all the integrations for all the submissions in a form?
Since I was having a hard time exporting submission data, I thought I could add an integration to get the data out and just rerun all integrations.

I know I can do 100 at a time using the select boxes, but I have 40,000+ submissions.

Additional context

No response

[engram-design]

This is only possible via a console command.

./craft formie/submissions/run-integration --submission-id=12345 --integration=mailchimp

[adrianjean]

Is there a way to bulk do this for all of the submissions for a specific form Id?

I saw that CLI command but it looked like I had to run it for every submission separately.

[engram-design]

Not really, sorry! But it does support multiple IDs. You could spin up a quick submission query in Twig:

{% set submissions = craft.formie.submissions.ids() %}

{{ submissions | join(',') }}

Which should spit you out a list of IDs, that you can pass into the console command.