Skip to content

Instantly share code, notes, and snippets.

@Hugoberry
Last active January 25, 2018 11:53
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save Hugoberry/fad134c9dcebee3dc1c56a9cb22de435 to your computer and use it in GitHub Desktop.
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