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 Kommentar
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 Erfahren Sie mehr über Wrikes leistungsstarke Funktionen und lernen Sie Anwendungsbeispiele kennen

0
Aktionen für Kommentare Permalink

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

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