Forum Discussion
When I remove the [0] at the end it does produce all, but it changes the structure from to []. And as I was pushing this to jsonPath($, “$Records[*].Sequence”), it no longer keeps sequence inline with the record.
- joel_bourgault3 years agoNew Contributor III
Hello, same question on my side, where multiple inserts occur within several MySQL snaps (so not the same server, but same need).
But maybe it is sufficient to force “autocommit=False” in these MySQL snaps: if I understand correctly, the commit will be performed only when the pipeline completes, i.e. no commit happens if the pipeline fails.
Is this understanding correct? Is this a correct way to handle this design?
This might be true if you’re inserting several records into one table
but for my usecase, i’ve been looking at inserts into different tables (e.g. a customer table, and a customer contact table) - which should be combined to fail together, which currently seems impossible without the SQL execute snap.
Related Content
- 4 months ago
- 6 years ago
- 2 years ago