Genesys Cloud - Main

 View Only

Sign Up

Expand all | Collapse all

Static Link Problem

  Thread closed by the administrator, not accepting new replies.
  • 1.  Static Link Problem

    Posted 08-28-2024 11:33
    No replies, thread closed.
    Hello All,
    I'm facing an issue with a static link where I have scheduled a recurring interaction report (Daily) and am trying to fetch the data using Power BI with a Python script.
     
    I only receive the report that was extracted first, and I don't get the report from the latest run. According to the documentation, when you configure a scheduled export from the Analytics Workspace and enable the Generate Static Link option, each export run should replace the file at the static URL location. However, it still shows the old report that was generated on Day 1. I'm testing this feature under "cac1" org
     
    Has anyone else experienced this issue?
    Regards,
    Adesh

    #API/Integrations
    #Architecture and Design
    #Omni-Channel Desktop/User Interface
    #Reporting/Analytics
    #Roadmap/New Features
    #SystemAdministration
    #Telephony
    #Unsure/Other

    ------------------------------
    Adesh Jadhav
    Orange SA
    ------------------------------


  • 2.  RE: Static Link Problem

    Posted 08-28-2024 11:43
    No replies, thread closed.

    Hello Adesh, 

    Have you tried step 8 in our documentation

    8. To refresh the data, configure an interval. Follow the instructions in the Configure scheduled refresh page so that the interval coincides with the static link report runtime

    Cheers, 



    ------------------------------
    Cameron Tomlin
    Online Community Manager/Moderator
    Genesys - Employees
    ------------------------------



  • 3.  RE: Static Link Problem

    Posted 08-28-2024 11:51
    No replies, thread closed.

    Hi Cameron,

    Thank you for your reply. Yes, I have tried step 8, but no luck.

    By the way, when I test the script, it retrieves the data that needs to be exported  but unfortunately it shows the first report's data rows (not the latest one).

    Regards,
    Adesh



    ------------------------------
    Adesh Jadhav
    Orange SA
    ------------------------------



  • 4.  RE: Static Link Problem

    Posted 08-28-2024 13:04
    No replies, thread closed.

    What time frame did you choose on the scheduled section?  



    ------------------------------
    Robert Wakefield-Carl
    ttec Digital
    Sr. Director - Innovation Architects
    Robert.WC@ttecdigital.com
    https://www.ttecDigital.com
    https://RobertWC.Blogspot.com
    ------------------------------



  • 5.  RE: Static Link Problem

    Posted 08-28-2024 14:12
    No replies, thread closed.

    Hi Robert,

    I'm using daily timeframe for an export.



    ------------------------------
    Adesh Jadhav
    Orange SA
    ------------------------------



  • 6.  RE: Static Link Problem

    Posted 08-28-2024 14:20
    No replies, thread closed.

    Your time period is Yesterday.  That is what I was looking for.  On your export inbox, are you seeing only the same report each day?



    ------------------------------
    Robert Wakefield-Carl
    ttec Digital
    Sr. Director - Innovation Architects
    Robert.WC@ttecdigital.com
    https://www.ttecDigital.com
    https://RobertWC.Blogspot.com
    ------------------------------



  • 7.  RE: Static Link Problem

    Posted 08-28-2024 14:45
    No replies, thread closed.

    Hi Robert,

    Yes, that's correct-the time period is yesterday.

    I can see all the reports in my inbox. When I download the report, it gives the correct version, but when I copy the static link from the same latest report and try to paste it in the web browser to download, it gives me the old report. This means the older report is not being replaced by the latest run.



    ------------------------------
    Adesh Jadhav
    Orange SA
    ------------------------------



  • 8.  RE: Static Link Problem

    Posted 08-28-2024 15:15
    No replies, thread closed.

    I am guessing a glitch in the configuration data.  I would first try removing that putting it back in.  You don't have more than 20 exports scheduled do you?



    ------------------------------
    Robert Wakefield-Carl
    ttec Digital
    Sr. Director - Innovation Architects
    Robert.WC@ttecdigital.com
    https://www.ttecDigital.com
    https://RobertWC.Blogspot.com
    ------------------------------



  • 9.  RE: Static Link Problem

    Posted 08-29-2024 04:34
    No replies, thread closed.

    Hi,

    It appears there is an issue with the CAC1-Canada org. I tested the same configuration under the Frankfurt org, and it is working fine there. I was able to view the latest run report without any problems.



    ------------------------------
    Adesh Jadhav
    Orange SA
    ------------------------------



  • 10.  RE: Static Link Problem

    Posted 08-29-2024 11:35
    No replies, thread closed.

    Hi Adesh.

    Interaction exports are run via the Conversation Detail job endpoint and this pulls data from a datalake that is hydrated by a nightly pipeline run.  If this job has not completed when you run the export, then the data will only be available up until the previous pipeline run.  This could be causing the export to not have all the data or fail. As the nightly pipeline runs based on the off hours of the region, it would be expected for EUC1 to complete earlier than CAC1 and might be why it was working in the Frankfurt region and you may need to change the time your report is running to make sure it can access the previous days data. You can check here for information regarding Data Availability



    ------------------------------
    Sam Jillard
    Online Community Manager/Moderator
    Genesys - Employees
    ------------------------------



  • 11.  RE: Static Link Problem

    Posted 08-29-2024 12:58
    No replies, thread closed.

    Hi Sam,

    I checked my inbox, and it shows all the latest reports correctly. However, when trying the static link, it shows the old report (First Run report).

    I also waited a couple of days, but the issue still appears to be there.

    Thanks.



    ------------------------------
    Adesh Jadhav
    Orange SA
    ------------------------------



  • 12.  RE: Static Link Problem

    Posted 08-29-2024 16:03
    No replies, thread closed.

    Did you try rebuilding that scheduled export?



    ------------------------------
    Robert Wakefield-Carl
    ttec Digital
    Sr. Director - Innovation Architects
    Robert.WC@ttecdigital.com
    https://www.ttecDigital.com
    https://RobertWC.Blogspot.com
    ------------------------------



  • 13.  RE: Static Link Problem

    Posted 08-30-2024 01:34
    No replies, thread closed.

    Hi Robert,

    Yes, I tried rebuilding the report with different time periods and combinations as well, but had no luck.



    ------------------------------
    Adesh Jadhav
    Orange SA
    ------------------------------



  • 14.  RE: Static Link Problem
    Best Answer

    Posted 09-02-2024 04:39
    No replies, thread closed.

    Hey Adesh,

    I would double check that PowerBI has the correct permissions and authorization to access the Static Link: Generate static link

    If it does, I would recommend raising a case with care as they will need to investigate what is happening on the back end to clarify that the report is running, the latest data is available and if there are any other issues.  If you could make sure to provide the Export ID and Static link found in the Inbox > Exports Menu and confirmation of the scheduled runtime in UTC



    ------------------------------
    Sam Jillard
    Online Community Manager/Moderator
    Genesys - Employees
    ------------------------------