Pull data from completed forms

Follow

Phread Langford

• March 28, 2023 14:14

I have an Application A that has been running for a while. There is a list of the completed form A's in SharePoint (includes the process ID, form name etc) but not all of the fields in the form.

I want to have an Application B that looks up the information on a specific completed Form A .  I can do the lookup against the SharePoint list for them to pick the specific Form A that they want to pull data from.

How do I lookup the data from the completed Application A to populate fields in the form in Application B?  

0

• 

  Loren Bratzler

  • March 30, 2023 21:28

  Phread,

  You should be able to get variable values from any process using the AgilePoint REST SERVICE activity.  Have a look at this documentation:

  https://documentation.agilepoint.com/8011/developer/restmethodGetCustomAttr.html

  It requires that you first do a query against the AgilePoint database to get the Work Object ID of the Process ID you want to pull data from.  Use a Query Record activity to get the data from your AgilePoint database with this query:

  SELECT WORK_OBJECT_ID
    FROM WF_PROC_INSTS
   WHERE PROC_INST_ID = '${/pd:AP/pd:formFields/pd:ProcessInstance}

  Once you have the Work Object ID, you can use a REST SERVICE activity in your process B to get specific field values from process A.  Below are screen-shots of a REST activity that I use to get a group name that is stored in another process:

  

  

  

  

  

  This particular REST call returns just a single attribute value but I believe there are other REST calls that can return multiple values.

  0

  Comment actions Permalink

Please sign in to leave a comment.