Forum Discussion
How to workaround on require Premium to refresh for dynamically fill the "Web. Contents" API?
Hey there,
I've been grappling with this problem for the past week but haven't found a solution yet. I've tried several different approaches, but none seem to work. I'm attempting to pass the Event ID as a parameter to my API to fill the web contents dynamically. However, I keep running into an error that says, "Computed tables require Premium to refresh. To enable refresh, upgrade this workspace to Premium capacity, or remove this table." It's been quite frustrating, to be honest.
I'm wondering if there's another way I can get around this issue. So far, I've taken the following steps: After creating the parameter, I've tried invoking it on a different table, but that hasn't been successful either. If you have any ideas or suggestions, I would greatly appreciate it.
(eventId as text) =>
let
BasicURL = "https://api.calendly.com/scheduled_events/",
RelativePathString = BasicURL & eventId & "/invitees",
Headers = [Authorization =""&CalendlyApiKey],
Source = Web.Contents(RelativePathString, [Headers=Headers])
in
Source
2nd Try
(eventId as text) =>
let
Source = Json.Document(Web.Contents("https://api.calendly.com/scheduled_events/" & eventId & "/invitees", [Headers=[Authorization=""&CalendlyApiKey]]))
in
Source
3dr Try
(eventId as text)=>
let
apiUrl = "https://api.calendly.com/scheduled_events/" & eventId & "/invitees",
headers = [Authorization=""&CalendlyApiKey, #"Content-Type"="application/json"],
jsonData = Json.Document(Web.Contents(apiUrl, [Headers=headers])),
tableData = Table.FromRecords({jsonData}),
expandedData = Table.ExpandListColumn(tableData, "collection"})
in
expandedColumns
4th Try, this did not work due, "Token Literal expected.". I try "[RelativePath= ""&eventId"/invitees"" no luck
(eventId as text) =>
let
Source = Json.Document(Web.Contents("https://api.calendly.com/scheduled_events/", [RelativePath= & eventId &"/invitees", [Headers=[Authorization=""&CalendlyApiKey]]
in
Source
After trying out the steps mentioned above, I go ahead and invoke the function in the following manner:
let
Source = nl_Events,
#"Removed other columns" = Table.SelectColumns(Source, {"Event ID"}),
#"Invoked custom function" = Table.AddColumn(#"Removed other columns", "Invoked custom function", each EventIDs([Event ID])),
#"Expanded Invoked custom function" = Table.ExpandRecordColumn(#"Invoked custom function", "Invoked custom function", {"collection"}, {"collection"}),
#"Expanded collection" = Table.ExpandListColumn(#"Expanded Invoked custom function", "collection"),
#"Expanded collection 1" = Table.ExpandRecordColumn(#"Expanded collection", "collection", {"email"}, {"email"})
in
#"Expanded collection 1"
Thank you so much
4 Replies
- AnonymousNot applicable
Hi Zack92
Please try the scenarios mentioned in the documentation below:
Merging tables in Power BI dataflows with PRO subscription - Simple Talk (red-gate.com)Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Zack92
Helper III
Anonymous Thanks, but I am already using this method to remove enable loading and take the reference from the last table. For this issue, this does not work tho.
- lbendlin
Super User
Please follow the documentation. Use RelativePath the way it is intended.
- Zack92
Helper III
Thanks. I am trying to use RelativePath but getting an error call, Expected token near & eventID, I could not figure it out.
(eventId as text) => let Source = Json.Document(Web.Contents("https://api.calendly.com/scheduled_events/", [RelativePath= & eventId &"/invitees", [Headers=[Authorization=""&CalendlyApiKey]] in Source