0

Report API

I am looking for a way to generate a report using API that is currently created in Veeva Vault RIM. Is there a direct report API call that can be performed to extract the report? If not does the Vault generates a VQL for the report that I can use in my API call? Thank you.

5 comments

  • Avatar
    Graham G

    Hi Juhi - there is not a direct report API, however we are considering exposing the underlying VQL used in the report as a feature.

    Best, Graham 

  • Avatar
    Juhi Saxena

    Hi Graham, thank you. When can underlying VQL used in the report can be secured? 

  • Avatar
    Graham G

    Hi Juhi - this feature is not currently targeted for a specific release, but we will be keeping it in mind as we plan future releases.

    Best, Graham

  • Avatar
    Juhi Saxena

    Hi Graham, at this point is it possible for you to provide me a report VQL template that has join and filter in it and then I will be able to update that VQL for my report? Thank you.

  • Avatar
    Graham G

    Hi Juhi - your best resource will be VQL documentation: https://developer.veevavault.com/vql/#relationship-queries-joins

    Query with only primary: select id, name__v from registration__rim

    Query with primary and outbound: select name__v, application__rimr.name__v from registration__rim

    Query with primary, outbound and inbound: select name__v, application__rimr.name__v, (select name__v from registered_product_details__rimr) from registration__rim

    Best, Graham

Please sign in to leave a comment.