非常感谢你这个例子,我看这个jsondoc的url里传了参数
我需要的是可以动态绑定报表的参数,并把参数值传给jsondoc里的URL
- method=POST;headers={"Content-Type": "application/json"};body={"dataSetDoc":{"name":"楼盘数据","query":{"dataSources":[{"id":"0e08eb20-b984-4ca0-ab28-6d85b515d6ec","name":"项目运营","fileName":null,"provider":null,"useAdvancedConfig":false,"connectionString":null,"mappingConfigs":null,"useUserContext":false,"useMultiTenant":false,"isExtracted":false}],"parameters":[],"commandText":"SELECT [楼号],[数值] FROM [楼盘数据] ","commandType":"Sql","commandModel":{"firstTable":{"id":"715464","tableType":"NativeTable","tableName":"楼盘数据(0e08eb20-b984-4ca0-ab28-6d85b515d6ec)","sql":null,"dataSourceId":"0e08eb20-b984-4ca0-ab28-6d85b515d6ec","unionType":"none","unionMap":null,"filters":[],"sQlExpressions":[],"tables":[]},"joinRelations":[]}},"fields":[{"table":"楼盘数据(0e08eb20-b984-4ca0-ab28-6d85b515d6ec)","column":"楼号","alias":"","description":"","dataType":"String","format":"","fieldType":"Normal","aggregation":null,"rawType":null,"msDescription":""},{"table":"楼盘数据(0e08eb20-b984-4ca0-ab28-6d85b515d6ec)","column":"数值","alias":"","description":"","dataType":"Number","format":"f2","fieldType":"Normal","aggregation":null,"rawType":null,"msDescription":""}],"groupFields":[],"customSqlTables":[],"filterExpressions":null,"filterConditions":{"conditionType":0,"conditionItems":[],"type":null,"table":null,"column":null,"expression":null,"operator":null,"value":null,"valueType":null,"targetType":null},"indexed":true,"tagIds":null,"comment":null,"incrementalUpdateSetting":null},"parameters":[],"uriParams":[]};jsondoc=http://localhost:51980/api/datasetmanagement/preview?ignoreusercontext=false&rowcount=100&token=959bcde9cde7eb36aa691e34c2f453b4af21d4541cb7fb98514c4583f38a2984¶m1={@P1}
复制代码 |