Forum Discussion

Zack92's avatar
Zack92
Icon for Helper III rankHelper III
2 years ago

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

    • Zack92's avatar
      Zack92
      Icon for Helper III rankHelper 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. 

    • Zack92's avatar
      Zack92
      Icon for Helper III rankHelper III

      lbendlin 

      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