Skip to main content
D
davida0024
March 8, 2023
Solved

Need to load/update grid interface from Process ID passed into an expression

  • March 8, 2023
  • 7 replies
  • 0 views

Hello Community,

We have a form that we modify to bring in all of our interfaces.  Most of them pull json from a REST api.

This interface will need to GET and UPDATE methods from a SQL table and will trigger off of the process ID.

Expression:

takes 2 inputs: the current process id and a key that will allow me to pull specific data out of the json.

My Question:  How do I pass the forms process ID into the expression?  Here is the start of my rule to pull in the interface into the form:

rule!TEST_ReviewsList(rule!CORE_GetProcessDataByKey(wfProcessId: "47" , key: "comment"))

Thanks,
David

Best answer by abhayd3663

davida0024

Where do you store/hold process ID? E.g. if it is into local variable local!procID then you need to pass that like.

rule!TEST_ReviewsList(rule!CORE_GetProcessDataByKey(wfProcessId: local!procID , key: "comment"))

7 replies

pragnaj0001
pragnaj0001
March 9, 2023

I think. Use process model. Save the processId, comment in process variable. take script task and call ur expression rule. map that variables. 

stefanhelzle0001
stefanhelzle0001
Brainy
March 9, 2023

This is confusing ... You talk about APIs, JSON, SQL, Processes, Interfaces.

Your question: "How do I pass the forms process ID into the expression?"

- A form does not have a process id

- Which expression?

Maybe you can help me understand ...

D
davida0024Author
March 9, 2023

Hello Stefan,

I was trying to explain the details of the form...the APIs may be irrelevant to this question.

I have an expression that I need to use to populate a GRID.  The expression in the screen shot above takes 2 inputs, the ProcessID and a Key word that will allow me to populate a local  variable with a values.

I'm used to working with Forms that have some sort of Process ID to populate the data so some of my wording may not fit the appian model.

Pulling data into an interface with an expression is new to me.  If I have an interface called "rule!TEST_ReviewsList" and I need to use that expression to load the data.

stefanhelzle0001
stefanhelzle0001
Brainy
March 9, 2023

I am still not sure where you are stuck at. But you would use a!queryRecordType to load data.

Terms & ConditionsAccessibility statement