To run code that doesn't fit these attributes, you can create and call a function using Azure Functions. This guide shows how the action works in an example workflow that starts with an Office 365 ...
SQL Server's OpenJson function will let you dismantle JSON structures into relational tables, including tables with foreign/primary key relationships. As I noted in an earlier column, JSON is great ...