Skip to content

Instantly share code, notes, and snippets.

@Hugoberry
Last active January 25, 2018 11:53
Embed
What would you like to do?
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