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.

0
1 commento
Spot On Innovative Approach Stellar Advice
Avatar

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 Conosci le straordinarie funzionalità di Wrike e le best practices

Pavel M Wrike Team member Conosci le straordinarie funzionalità di Wrike e le best practices

0
Azioni per commenti Permalink

Folllowing List for Post: Integrate Custom Field into Power BI
[this list is visible for admins and agents only]

Su
Didn’t find what you were looking for? Write new post