Integrate Custom Field into Power BI
I am trying to connect wrike with Power BI. I was successful in doing so, but the when the column are extracted into power bi I don't see custom columns with it.
The code that I use right know is
let
Source = Web.Contents("https://www.wrike.com",
[Headers=[#"Authorization"="bearerAPI"],
RelativePath = "/api/v3/folders/IEAA6OFNI4CQ5SOI/folders?project=true"]),
convertToJson = Json.Document(Source),
in
convertToJson
I tried using this code for custom field but it gives error on field=["customField"] point.
let
Source = Web.Contents("https://www.wrike.com",
[Headers=[#"Authorization"="bearerAPI"],
RelativePath = "/api/v3/folders/IEAA6OFNI4CQ5SOI/folders?project=true&field=["customFields"]"]),
convertToJson = Json.Document(Source),
in
convertToJson
Kindly help regarding the same.
Hi Sahil! The correct syntax for CFs parameter would be &fields=["customFields"].
I am also suggesting you to try Query option if your way with Relative Path is not working for some reason. I have described the alternative way in this article.
Pavel M Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover
Pavel M Wrike Team member Become a Wrike expert with Wrike Discover