Skip to content

Instantly share code, notes, and snippets.

@Hugoberry

Hugoberry/JSON.m

Last active Jan 25, 2018
Star
Embed
What would you like to do?
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