1

How to get list of My Tasks (Open Activities) via Vault API

At our company and we are looking to create a custom mobile app to display pending tasks across all the applications. Since PromoMats is one of the applications used by our end-users, we want to include a list of PromoMats-pending tasks assigned to a user.

Is there a way to retrieve a list of activities assigned to specific user? Using PromoMats user interface, I can do this in the following way. But, I am not sure how to retrieve activities through API. 

1) Going to "Task" page

2) Creating a Flash report on Activity with following Filters

 

4 comments

  • Avatar
    Krishna Kant Saraswat

    You can try querying "workflows" object to pull the report using the query API. Something like below. This will pull all active tasks in your vault.

    https://{vault_domain_name}/api/v19.3/query?q=select workflow_document_id__v, workflow_initiator_name__v, workflow_name__v, task_name__v, task_creationDate__v, task_assignee_name__v from workflows where workflow_status__v='Active' and task_status__v != 'Completed'

     

    All fields that can be queried on workflows are provided in the link here. https://developer.veevavault.com/api/18.3/#retrieve-document-workflow-metadata

     

    Note: I am not from Veeva and these are my individual comments.

  • Avatar
    Rohit Marathe

    Thanks a lot Krishna . This is a great help :)

  • Avatar
    Rohit Marathe

    Hello Krishna ,

    I tested using query API and your solution worked perfect. I am able to query all the pending activities using your query. Thanks again for the help.

  • Avatar
    Krishna Kant Saraswat

    Perfect, Good luck!

Please sign in to leave a comment.