Forum Discussion
Anyone using Power BI to pull 8x8 CRM data?
SteveCarter1
Very small topic, I have not seen any thing related to 8x8 with power bi. Is it possible to get help from the 8x8 support?Paul Zheng
I have been trying to parse this for over a day, and I don't understand where some of the changes go.
When adding the "otherwise “<activities></activities>”, does that go in the function, the query the function is based on (activity), or the query that uses the function (group)?
I also would like to know the same for the transformation listed in part 1.
Thanks!
Andrew
Hi
The otherwise is part of the try function but formatting might be messing things up. When I copy/paste from above, the double-quotes around the code in the otherwise part were a different style than stright double-quotes. Hopefully with this in a code block it should be more clear and work for you. In a nutshell I am returning an empty XML table that PBI can parse without producing an error.
Source = try Xml.Tables(Web.Contents("https://vcc-au1.8x8.com/api/stats/groups/",
[
RelativePath=#"group-id" & "/activities",
Query=[n=offset]
]
)) otherwise "<activities></activities>"
I get that, I just am not sure if these are edits in the function (GetActivities) , the group query, or the activity query. I am just unclear where these edits go. For example, the transformation edit in part 1, I have no clue where that goes, so I have tried the function and the group query, and both. at the same time. When I add the offset step at the end, I just end up copying the same query of 50 items over and over again and am rather lost.
It's inside the function. For example for me: