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 O
    Vera O Member
    edited April 25

    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

  • Vera O
    Vera O Member

    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
  • Vera O
    Vera O Member

    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