Sahil Hira

January 26, 2018 19:02

Integrate Custom Field into Power BI

Follow

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.

• Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪

  

  Pavel M

  February 07, 2018 07:43

  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 🌎Discover... Wrike Discover and become a Wrike expert. Click here to get started

  Is this helpful? 0

  Comment actions Permalink

Please sign in to leave a comment.