Home Discussions Questions & Answers API for Archiving Previous SQL Definitions

API for Archiving Previous SQL Definitions

Avatar photoCustomer October 26, 2022 at 7:26 am

We need to meet a compliance requirement by archiving all historical SQL definitions. Does the export API support extracting previous versions, and how is that controlled?

Viewing 2 reply threads
  • Author
    Replies
    • Support October 26, 2022 at 3:44 pm  

      Yes, the export function `XXEN_API.export_file_data` supports historical data extraction by setting the parameter `p_type` to ‘SQL Versions’. When using this type, you can further restrict the versions exported based on their creation date using the parameter `p_creation_date`.

    • Avatar photoCustomer October 28, 2022 at 3:04 pm  

      If I simply export a report normally (`p_type`=’Reports’), does that XML include the SQL history?

    • Support October 29, 2022 at 8:14 pm  

      No. Report load scripts and XML files generated by choosing ‘Reports’ contain the current report SQL versions only; they do not include previous version SQL history.

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

Login with: