MS SQL JSON Data Insertion

Job ID: 38234416

Budget: $10 – $30 USD

I need a skilled freelancer to assist with the dynamic insertion of JSON data into an existing MS SQL table. The JSON string will have nested type 4 structures, and the insertion must be based on these nested levels.

Key Requirements:
- The received JSON data is nested.
- Insertion into the MS SQL Server should be dynamic, based on the nested structures.
- Each nesting point should correspond to a unique table in the SQL server.

The ideal candidate for this project is:
- Proficient in MS SQL Server.
- Experienced in handling and parsing nested JSON data.
- Capable of dynamically inserting data into SQL tables.

Please provide examples of your previous work with nested JSON and MS SQL Server.
Example
1. opportunitiesData is the primary table that is the first recordset
2. Next would be award which has another nested value awardee
3. pointOfContact would be the table name for point of contact
4. officeAddress would be a table for the Offfice Address
5. links1 would be the table name for URL links
6 Links would be the table off the root

DO NOT HARDCODE NAMES - MUST BE DYNAMIC. I have provided this as an example.