SQL Server's OpenJson function will let you dismantle JSON structures into relational tables, including tables with foreign/primary key relationships.

With Tasker beta 5.12.0, the most powerful smartphone automation tool is adding native JSON and HTML reading, plus some other additions.