Home Discussions Questions & Answers API for Mass Importing Discoverer Worksheets

API for Mass Importing Discoverer Worksheets

Avatar photoCustomer January 10, 2021 at 12:16 am

What is the PLSQL procedure for mass importing individual Discoverer Worksheet SQLs into Blitz Report?

Viewing 4 reply threads
  • Author
    Replies
    • Support January 11, 2021 at 9:22 am  

      You need to use the procedure **`xxen_api.import_discoverer_worksheet`**.

    • Avatar photoCustomer January 12, 2021 at 11:07 pm  

      What specific names does this procedure require?

    • Support January 13, 2021 at 2:10 pm  

      The key input parameters are `p_workbook_owner_name`, `p_workbook_name`, and `p_worksheet_name`. It also requires `p_eul`, which defaults to ‘eul_us’ if not specified.

    • Avatar photoCustomer January 14, 2021 at 4:48 am  

      If I need to re-run the import, is there a script to clean up the imported reports first?

    • Support January 14, 2021 at 12:26 pm  

      Yes, to clean up, you can use the script `mass_delete_discoverer_reports.sql` to remove all previously imported Discoverer reports before attempting a re-import.

Viewing 4 reply threads
  • You must be logged in to reply to this post.

Login with: