Forum Discussion

Mekist's avatar
Mekist
Helper III
6 months ago
Solved

Retrieving data via HTML

Hello I am retrieving company information as a table using the following query. Since the data is retrieved from the table, a timeout issue occurs on the website. Is it possible to retrieve the data...
Need Help
Show and Tell
  • Mekist's avatar
    Mekist
    5 months ago

    v-saisrao-msft  Hello

     

    Thank you for your support, there is no waiting problem

v-saisrao-msft's avatar
v-saisrao-msft
Community Support
5 months ago

Hi Mekist,

Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.

 

Thank you.

Mekist's avatar
Mekist
Helper III
5 months ago

Hello

 

I had the opportunity to check it, but the web page timed out again, so I followed a different process. Thank you for your support.

  • v-saisrao-msft's avatar
    v-saisrao-msft
    Community Support
    5 months ago

    Hi Mekist,

    Since you mentioned using a different approach, could you share your insights on the issue? This would be helpful for community members who are experiencing similar problems.

     

    Thank you.

    • Mekist's avatar
      Mekist
      Helper III
      5 months ago

      Hello
      I created the list manually because I couldn't find a permanent solution

      • v-saisrao-msft's avatar
        v-saisrao-msft
        Community Support
        5 months ago

        Hi Mekist,

        I tried opening the URL in the browser, but it resulted in a timeout error.

        Could you check the URL you provided or see if any extra details are needed to access it?

         

        Thank  you.

    • Mekist's avatar
      Mekist
      Helper III
      5 months ago

      Helloh v-saisrao-msft 

       

      Hello with the help of a master, the following code was shared

       

      let
    Kaynak = Web.Contents("https://www.isyatirim.com.tr/tr-tr/analiz/hisse/Sayfalar/Temel-Degerler-Ve-Oranlar.aspx"),
    Tablo = Html.Table(Kaynak,
        {
            {"Kod", "td:nth-child(1)"},
            {"Hisse Adı", "td:nth-child(2)"},
            {"Sektör", "td:nth-child(3)"},
            {"Kapanış (TL)", "td:nth-child(4)"},
            {"Piyasa Değeri (mn TL)", "td:nth-child(5)"},
            {"Piyasa Değeri (mn $)", "td:nth-child(6)"},
            {"Halka Açıklık Oranı (%)", "td:nth-child(7)"},
            {"Sermaye (mn TL)", "td:nth-child(8)"}
        },
        [RowSelector="tbody#temelTBody_Ozet tr"]
    )
in
    Tablo
      • v-saisrao-msft's avatar
        v-saisrao-msft
        Community Support
        5 months ago

        Hi Mekist,

        May I know if you are still experiencing the timeout issue when using the above code? If you encounter any further issues, please let us know.

         

        Thank you.