Export views, datasets, schedules etc.

Dear All!

Is there an easier way to extract all the views, datasets, schedules etc. information from a space or across different spaces?

I mean what we have in this GRID for examples for the views:

image.png

I need to create different reports and it would be time consuming to select and copy-paste.

Many thanks!

Kind regards,

Vera

Tagged:

Answers

  • Josh Boxer
    Josh Boxer Administrator

    Hello, you can extract all this info via APIs:

    https://docs.experianaperture.io/data-quality/aperture-data-studio/customize/use-the-rest-api

    Another option is to ask your administrator is they can extract it out of the repository database tables for the objects you need:

    https://docs.experianaperture.io/data-quality/aperture-data-studio/installation/install-data-studio-on-windows/#repository-backups

  • Vera Osvath
    Vera Osvath Member
    edited April 2025

    Hi Josh!

    Thanks for these links I will review - actually I supposed to be the admin now 😅 so I need to discover.

    Many thanks!

    Kind regards,

    Vera

  • Hi Josh,

    We've set up the API extractions, so most of the checks should be covered now! However, we couldn't find a way to retrieve data for the Jobs and Schedules.

    It would be helpful to have an overview, similar to the grid view, with the following information:

    Schedules: workflow name, interval, next run

    Jobs: workflow, space, initiated by, status, start time, end time, elapsed time

    The goal is to create a monitoring system to track whether the scheduled runs have been completed or not.

    Let me know your thoughts on this!

    Many thanks!

    Vera

  • Josh Boxer
    Josh Boxer Administrator

    These APIs exist, you might need to upgrade to a later version for Schedules, but Jobs is older

    image.png image.png
  • Hi Josh,

    yes, unfortunately it seems that our version 2.8.8.27 is indeed not supporting this schedule operations API call.

    We were also using this API to get the relations between datasets, view, worfklows:

    image.png

    Although we have found some datasets that were not appearing in the list as "child" element (checked by name and ID as well). The result looks like this:

    image.png

    Although when we were checking in the associations to that particular dataset, it was there:

    image.png

    Do you know a better way/API to check these relations/associations? What could be the issue?

    Many thanks!

    Kind regards,

    Vera