Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Why Am I Getting Two Different Results From One Constant Source?

I am getting two different source results from one constant Source and can't figure out why.   I am using the following to get my source: Source = Web.Page(Web.Contents("https://webapps.MyDomain/p...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Thanks again v-chuncz-msft. This seems to be working okay:

     

    let
  GetData = () => if List.Contains(Table.ColumnNames(Web.Page(Web.Contents("https://webapps.MyDomain/path/req_search.cfm?page=AP")){1}[Data]), "Details") then 
        Table.RemoveColumns(Web.Page(Web.Contents("https://webapps.MyDomain/path/req_search.cfm?page=AP")){1}[Data],{"Details"}) else @GetData(),    
  ShowData = GetData()
in
  ShowData
  • Anonymous's avatar
    Anonymous
    8 years ago

    v-chuncz-msft, I went back and changed my query to use try-otherwise, with the recursive function structured as below, and it worked this way too. So I'm marking your original response as a solution. Thanks yet again for your help.

     

    let
  GetData = () => try Table.RemoveColumns(Web.Page(Web.Contents("https://webapps.MyDomain/path/req_search.cfm?page=AP")){1}[Data],{"Details"}) otherwise @GetData(),
      ShowData = GetData()
in
  ShowData
Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

Try going into the advanced options and see if you can increase the time-out. What I am guessing is going on here from looking at the second result a little closer is that you are getting back a blank HTML page, it's essentially timing out. If I am reading the second result correctly, you are getting an HTML element that is essentially null. Seems like a timeout kind of problem to me.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Unfortunately, the timeout didn't solve it.

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    Well, I guess another question would be, if you go to the web page in a browser and click refresh a bunch of times, does it sometimes come back blank?

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      I just tried refreshing the web page a bunch of times and it always came up just fine. Separately though, I did try something else that yielded a result I found interesting.

       

      I refreshed my query, then I clicked on the table in the Data column of the Source and got the not desired resulting table of columns; but then I waited a moment and, without refreshing the query, I clicked on the table in the Data column of the Source again and got the desired resulting table of columns. So I'm thinking I need a delay before I navigate to the table of columns via Source{1}[Data]. I'm guessing I need to use Function.InvokeAfter(), but I'm not sure how to use it with Source{1}[Data]. I tried Function.InvokeAfter(Source{1}[Data], #duration(0,0,0,5)) but I got the error:

       

          Expression.Error: We cannot convert a value of type Table to type Function.
          Details:
              Value=Table
              Type=Type

       

      I also attempted to use a function to get around the error, base on some of Chris Webb's blogs but I'm not sure I did it right, because I still got the intermittent problem.

       

      Would you agree that I might need a delay, and if so, how might you add it?