Skip to content
All gists
Back to GitHub
Sign in
Sign up
Sign in
Sign up
{{ message }}
Instantly share code, notes, and snippets.
Hugoberry
/
JSON.m
Last active
Jan 25, 2018
Star
0
Fork
0
Star
Code
Revisions
6
Embed
What would you like to do?
Embed
Embed this gist in your website.
Share
Copy sharable link for this gist.
Clone via HTTPS
Clone with Git or checkout with SVN using the repository’s web address.
Learn more about clone URLs
Download ZIP
Raw
JSON.m
let
//
serialize table
[
dummy
]
into a
JSON
object
json
=
Text
.
FromBinary
(
Json
.
FromValue
(
dummy
))
,
//
pass
JSON
object to
SP
that unwrapps it as a recordset & performs
INSERT
operation
out
=
Value
.
NativeQuery
(
Sql
.
Database
(
"."
,
"QueryPower"
)
,
"usp_InsertDemoJSON @json"
,
[
json
=
json
])
in
out
Sign up for free
to join this conversation on GitHub
. Already have an account?
Sign in to comment
You can’t perform that action at this time.
You signed in with another tab or window.
Reload
to refresh your session.
You signed out in another tab or window.
Reload
to refresh your session.