Home › Discussions › Questions & Answers › API for Mass Importing Discoverer Worksheets

5 replies

  • Support Enginatics

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

  • Avatar photoCustomer

    What specific names does this procedure require?

  • Support Enginatics

    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

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

  • Support Enginatics

    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.

  • You must be logged in to reply to this post.