FlowCharts Send Http Request (beforeValue)

[item]

Hello Yuri,

is there any possibility to have the beforeValue of attribute (if you see image, start event is "change") ?
it's important for us

Best Regards

[yuri]

Hi,

You can utilize Workflows instead. Have 2 actions.

The first action (Execute Formula) sets a before-value to a variable.

$myVar = entity\attribute('attributeName');

The second action is Sent HTTP Request that utilizes that variable.

This is possible since the recent version of advanced pack. We added the logic that variables are passed along all actions of a single workflow rule.

[rinorway]

yuri How do you use that variable in the action "Create notification" -> message template?

Like {$myvar}

This would be handy for quick debugging of workflows.

[rinorway]

yuri
Would you anyone be so kind to share a task json example here ?

Whatever I try (simple workflow : onchange of Contact entity) the myVar will not get parsed, when I use

myVar =

not either...

Goal is to post a bunch of data outside for audit purposes and MS Teams notifications.

[
{
"formula": "$myVar = \"123\";\n",
"cid": 0,
"id": "...",
"type": "executeFormula"
},
{
"requestType": "POST",
"contentType": "application/json",
"content": "{\"a\":\"{$$myVar}\",\"b\":\"{$lastName}\"}",
"requestUrl": "https://webhook.site/3d830....",
"headers": [],
"cid": 1,
"id": "...",
"type": "sendRequest"
}
]

[item]

Hello,

not try still .. but maybe this :
$oldValue = entity\attributeFetched('assignedUserId')


MS Teams notifications : waouwww .. it's easy to implement ?

[rinorway]

A bit out of scope, but in teams : Go to : Channel settings -> Connectors -> Add -> Incoming webhook
Then post JSON to this URL. Looks like this : https://messagecardplayground.azurewebsites.net/

[rinorway]

yuri A working example (even a screenshot) of a workflow with a variable assignment and using its value in a HTTP action would be very welcome, or a link to an example in the manual.

So far I have not been able to get any var assigned in "executeFormula" to be available in another task using a placeholder

Thank you

[item]

Hello,
i have try to pass a variable so : $var or $$var.. no luck .. but in BPM work.
so maybe https://docs.espocrm.com/administrat...ula-in-actions
create a custom field .. set your variable then in postHttp use it

And on doc :
Available placeholders:

• {$attribute} – a value of an attribute (field) of a target record; e.g. {$description}, {$assignedUserId} (see info about attributes);
• {$$variable} – a value of a variable (available only in BPM process); e.g. {$$myVariableName}

Thanks for tips for MS Teams.. it's easy

Regards

[rinorway]

Ok, hmm what a pity... i missed the (available only in BPM process) remark, how easy would it be to have that in workflows as well...

[item]

Maybe a feature request .. or a bug, Yuri seemt say "it's possible in workflow" .. and no result in workflow

[yuri]

I will fix for workflows in the next release.

[item]

Many Thanks Yuri ..

[rinorway]

Totally agree, very nice to fix that Yuri,

For others : you should not post issues for advanced pack in github espo repo (like i did), that is only for espo/espo and does not contain the advanced pack.

[rinorway]

Confirmed : Tested with Advanced Pack 2.6.5 Workflows: Fixed a bug that variables not being passed from between actions.

eg : Track changes in contact lastName:

Execute Formula Script
$old=entity\attributeFetched('lastName');
$new=entity\attribute('lastName');

Send HTTP Request
Request Type POST
Content Type application/json
URL: https://webhook.site/xxxxxxxxxxx?oldname={$$old}&newname={$$new}
Payload: {"old name":"{$$old}","new name":"{$$new}"}

[item]

Thanks rinorway,

it's something strange..certainly my fault :
execute formula :
$old= ...
you put one $

and on second action, you put two $

i have not tested your tips but if it's the solution.. perfect.. that's clarify my mistake

[rinorway]

Yes correct, you should use {$$old} : https://docs.espocrm.com/administrat...ula-in-actions

Available placeholders:

{$attribute} – a value of an attribute (field) of a target record; e.g. {$description}, {$assignedUserId} (see info about attributes);
{$$variable} – a value of a variable (available only in BPM process); e.g. {$$myVariableName}

BTW, you could have used the attribute directly like $lastName, but since assigned to $new, it should be $$new

[rodrigocoelho]

Confirmed : Tested with Advanced Pack 2.6.5 Workflows: Fixed a bug that variables not being passed from between actions.

eg : Track changes in contact lastName:

Execute Formula Script
$old=entity\attributeFetched('lastName');
$new=entity\attribute('lastName');

Send HTTP Request
Request Type POST
Content Type application/json
URL: https://webhook.site/xxxxxxxxxxx?oldname={$$old}&newname={$$new}
Payload: {"old name":"{$$old}","new name":"{$$new}"}

Hi, I tried this, but without success.
Sent the image of workflow attached. With different ways to get the value of NAME!

The payload received is below.

{"post":"teste",
"parent":"Opportunity",
"id":"612e5284a16697ca4",
"Nome":"",
"Nome2":"{$$name2}",
"Nome3":"{$$name3}",
"CodigoOportunidade":"{$codproposta}",
"related":"",
"Email":"{$createdBy.emailAddress}",
"createdAt":"2021-09-06 19:15:08"}



any advise? Thanks

[rodrigocoelho]

Hi, I tried this, but without success.
Sent the image of workflow attached. With different ways to get the value of NAME!

The payload received is below.

{"post":"teste",
"parent":"Opportunity",
"id":"612e5284a16697ca4",
"Nome":"",
"Nome2":"{$$name2}",
"Nome3":"{$$name3}",
"CodigoOportunidade":"{$codproposta}",
"related":"",
"Email":"{$createdBy.emailAddress}",
"createdAt":"2021-09-06 19:15:08"}



any advise? Thanks

yuri ?

[rinorway]

Late answer, but here we go :

The trick is to use :

workflow\targetEntity\attributeFetched()

instead of

entity\attributeFetched()