Trying to Sync Wrike with Excel

Hi 
I am trying to sync Excel with one of my reports in Wrike. I am using PowerQuery code (in advance query option). The code that I used is

let
    Source = Web.Contents("https://www.wrike.com/workspace.htm#path=reports-new&reportId=18709213",
[Headers=[#"Authorization"="bearer <My_Wrike_Permanent_API_Access_Token>"]]),
convertToJson = Json.Document(Source)
in
    convertToJson

The error that I am getting is: -

Expression.Error: The 'Authorization' header is only supported when connecting anonymously. These headers can be used with all authentication types: Accept, Accept-Charset, Accept-Encoding, Accept-Language, Cache-Control, If-Modified-Since, Prefer, Referer.

Kindly suggest, what to do.

Regards,
Sahil 

2
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
11 commentaires
Avatar
Pavel M

Hi Sahil! Sorry to hear you've run into this trouble! The code looks good to me, so it seems like an issue with software itself. First of all, could you please let me know whether you are using online Power BI version of the desktop one?

I have found some evidence on Power BI community that Authorization header may not be accepted if you are using Power BI Web.

In desktop software asks you to set up the level of access upon first connection and it should be 'Anonymous', everything is supposed to work fine at that point. 

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Hi 
I am trying to sync Excel with one of my reports in Wrike. I am using PowerQuery code (in advance query option). The code that I used is

let
   Source = Web.Contents("https://https://www.wrike.com/workspace.htm?acc=556408&wr=4#/reports/59136948",
[Headers=[#"Authorization"="bearer <PermanentAccessToken>"]]),
convertToJson = Json.Document(Source)
in
    convertToJson

The error that I am getting is: - DataSource.Error: The downloaded data is HTML, which isn't the expected type. The URL may be wrong or you might not have provided the right credentials to the server.

Please suggest how to resolve

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Hi Afrona Sela, I can see you've chatted about this with my colleagues from the Support team 👍

Please let me know if I can help you with anything else 🙂

Lisa Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover

Lisa Wrike Team member Become a Wrike expert with Wrike Discover

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Lisa when trying to connect to Wrike's API is there a way to specifically connect to the project level? Similar to what is currently shown on the Wrike Developers page for 'Get Folder Tree'?

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Hello Afrona Sela!
To achieve that, please use the GET /folders/{folderId}/folders and parameter project = true to query only projects in a certain Space. Use Space ID and use it instead of the {folderId}. More information can be found here: https://developers.wrike.com/api/v4/folders-projects/#get-folder-tree.  
Here's how to query Spaces: https://developers.wrike.com/api/v4/spaces/.
Hope that helps.

Darina Community Team at Wrike Wrike Product Manager En savoir plus sur les fonctionalités et les meilleures pratiques grace à nos Webinaires online

Darina Wrike Team member En savoir plus sur les fonctionalités et les meilleures pratiques grace à nos Webinaires online

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Lisa, I have the same issue as Afrona Sela, DataSource.Error: The downloaded data is HTML, which isn't the expected type. The URL may be wrong or you might not have provided the right credentials to the server.

Do you have an answer for that please ?

Thank you !

let
    Source = Web.Contents("https://www.wrike.com/workspace.htm?acc=1990198#/reports", 
[Headers=[#"Authorization"="bearer <...>"]]),
convertToJson = Json.Document(Source)
in
    convertToJson
0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Hi Lorenzo Forte!

I've asked my colleague from the Support team to reach out to you about this, and I can see they have 👍

Lisa Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover

Lisa Wrike Team member Become a Wrike expert with Wrike Discover

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Hi Guys, 
Can you share the correct PowerQuery code to access WRIKE Reports in Excel? 

Thank you

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
Avatar
Juan

Hi Gana Venthan, welcome to the Community! I've opened a ticket with our Support Team on your behalf on one of our experts will contact you shortly to assist you with this 👍

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Hi,

I have the same issue with Lorenzo and Afrona.

DataSource.Error:

Could you please let me know how to fix this error?

 

Thanks

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Hi Simon Wu, welcome to the forums 👋 

Reports are not available via API, this is why you may be getting this error. Please use the methods we have available at https://developers.wrike.com/ to pull the data about the items you want to report on. For instance, you could use GET/tasks or GET/folders calls. To retrieve the additional fields, please add them with fields parameter. I hope this helps! 

Lisa Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover

Lisa Wrike Team member Become a Wrike expert with Wrike Discover

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Folllowing List for Post: Trying to Sync Wrike with Excel
[this list is visible for admins and agents only]

Haut de la page
Didn’t find what you were looking for? Write new post