Script to import json to MSSQL
Budget: $250 – $750 USD
Hello! I have a json data file that I need imported to SQL. There are many nested arrays in this file. I would like to have this data parsed into relational tables in MSSQL.
This is just one file out of MANY that I will receive to import so I am looking for an SQL script to accomplish the import and parsing into SQL tables.
Attachments:
--Schema.txt - Current known schema of json files I will be receiving.
--CreateSQLTables.txt - Destination source SQL tables. **These are not set in stone, just a creation based on the json schema. However, this is the basic theory of what I would like to accomplish.
--09232020_index.json - Sample json data file to import.
Requirements:
--Must go into Microsoft SQL (not mysql, etc)
--I would like this in a t-sql script. I have been playing around with this:
https://stackoverflow.com/questions/47104722/how-to-parse-nested-json-array-using-sql-server
But it is a little out of my league. The concept appears to solve what I am looking for though.
** If you are unable to do this through t-sql please do not bid. If t-sql is impossible I'll probably go another route with some other development.
Thanks!
This is just one file out of MANY that I will receive to import so I am looking for an SQL script to accomplish the import and parsing into SQL tables.
Attachments:
--Schema.txt - Current known schema of json files I will be receiving.
--CreateSQLTables.txt - Destination source SQL tables. **These are not set in stone, just a creation based on the json schema. However, this is the basic theory of what I would like to accomplish.
--09232020_index.json - Sample json data file to import.
Requirements:
--Must go into Microsoft SQL (not mysql, etc)
--I would like this in a t-sql script. I have been playing around with this:
https://stackoverflow.com/questions/47104722/how-to-parse-nested-json-array-using-sql-server
But it is a little out of my league. The concept appears to solve what I am looking for though.
** If you are unable to do this through t-sql please do not bid. If t-sql is impossible I'll probably go another route with some other development.
Thanks!