PQ常用模板

 

//json请求
Json.Document(Web.Contents("",[Headers=[#"cookie"=tk,#"Content-Type"="application/json;charset=UTF-8"],Content=Text.ToBinary("")]))

 

//表单请求
Json.Document(Web.Contents("",[Headers=[#"cookie"=tk,#"Content-Type"="application/x-www-form-urlencoded; charset=UTF-8"],Content=Text.ToBinary("")]))

 

//获取当前查询列表
Record.FieldNames(#sections[Section1])
Text.Split(Record.FieldNames(#sections[Section1]){1},"-"){3}