OPENJSON - The Utility function you did not know you needed in a Data transfer Logic App
Background I have been using Logic Apps to transfer data from one database to another. Of course, there is business logic in the queries run on the source database. And in such a case, maybe Azure Data Factory might have been a better choice. It very well could be. But for now I have been using a logic app, that simply runs a pretty big query, fetches the results and inserts into my destination database after some checks on the data present in the destination database. It works. However, using your Logic App to do some data related operations, especially to a SQL database, requires some wisdom. ...