in a Workflow retrieve data from Mongoose with API call and put it into Task notification email

Kirill Kuchumov

Hi,

I need to extract some data from Mongoose in Workflow task and put it into task email.

For example I have three approvers, workflow goes in loops, at loop 1 I send task to approver1, at loop to - to approver2, etc.

Before sending task to an approver, I'd like to extract some data from Mongoose with API (data is updated in Mongoose after each approver approves)

In WF I call API:     MONGOOSE/IDORequestService/ido/load

It returns JSON like this

Is it possible to put returned value into structure and send it as a Content of Task notification?

Thanks

K

Rene Bottern

You can call a Script from the Workflow to extract the JSON values into variable(s) and then attach those to notification.

i.e.

import json

jsonFormat = json.loads(Mongoose_results)

REC0 = jsonFormat[0]["Allocation"]

REC1 = jsonFormat[1]["Allocation"]

OR

Create a script to count number of Records in the Mongoose Resultset and then Loop through them in the Workflow and extract there and insert in the Notification Message dynamically.

Something like:

CurrRec = $.[Counter]

CurrAlloc = CurrRec.Allocation

Haven't tested so not sure if Coding is 100%, but you get the gist I hope.