Hi @michaelshparber
Saving the blob somewhere in a folder has the advantage that you can fetch it later without doing another API call. But then you need to keep track of if you have a file or you need to perform an HTTP request. It makes things forked, and I would advise against it.
It's important, however, to deal with errors because if you're loading a lot of information, it will fail, so I would build in my Power Automate paths for when the insert fails to re-try or log those somewhere to deal with them later (either manually or have another Power Automate that deals with them).
Also, keep in mind that you want to continue inserting in case of the failure, so be aware of the "Run after" choices so that you can get the Power Automate going, even if there are errors.
Finally, if you have a big dataset to parse and insert, tap the 3 buttons and enable parallelisation. This will make things more efficient and make your inserts faster.
I hope this helps, and if something is not clear, please let me know.
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers
Manuel
