Join us June 17–18 for a deep dive into Copilot Control System—live expert-led sessions and Q&A on data security, agent lifecycle, adoption, and more! Learn more >

Forum Discussion

eynarain

Brass Contributor

Aug 07, 2020

SQL Server Merge a javascript list with a table

I have a javascript object containing a bunch of user info that's sourced from Microsoft Teams team member list. I want to merge this object to a SQL table at predefined intervals. The team members o...

bake13

Microsoft

Aug 13, 2020

Hi eynarain --

The easiest approach might be to break this task down into two distinct parts. First, load the JSON data to a staging or temporary table in the database. Next, perform your insert/merge into the primary base table.

SQL Server has good JSON support.

https://docs.microsoft.com/en-us/sql/relational-databases/json/json-data-sql-server?view=sql-server-ver15#key-json-capabilities-of-sql-server-and-sql-database