Update Data
In the Workflow Builder, you can add Update Data as a service.
A VM Execution can be used here for each field.
The basic function of the VM is as follows, whereby the return value must always be adapted to the corresponding field:
(function(data){
return "";
})The data object contains the complete relevant data set for which the update is being carried out.
For example, if you want to compose a salutation field from title, first name and surname, it would look like this:
(function(data){
let salutationParts = [];
if (data.title && data.title.length) {
salutationParts.push(data.title);
}
if (data.firstname && data.firstname.length) {
salutationParts.push(data.firstname);
}
if (data.lastname && data.lastname.length) {
salutationParts.push(data.lastname);
}
return salutationParts.join(" ");
})
In addition to the data set, further information can be transferred in data. This information depends on where and how the action is triggered.
When a data record is created or updated, two of these additional pieces of information are available.
data._triggerData: _triggerData contains the information that triggered an action. If the list settings mean that data is not updated automatically, individual pieces of information from the data._triggerData can be checked here in order to create conditions and update fields manually.
data._query: If data is transferred via the API or a form, the URL query parameters can be added, which do not affect the data record, but are available for further processing as data._query parameters. This can be helpful, for example, if data comes from different sources and you want to process it differently via a condition.
If you want to retrieve and process data via a webhook service, data._lastIntegrationData is available.
For example, after a store user has logged in, the API of the store can be addressed with a webhook to generate a voucher and this voucher can then be added to the user with an update data.
Application example: The store's API is addressed with a webhook to generate a voucher after a user has logged in. The voucher is added to the user with Update Data.
Condition: Code Execution
In the conditions, you can also use the VM to execute Javascript based on the data set that returns a true/false to confirm or deny the condition.
(function(data){
return (data.email.substr(-3)==="gov");
})In this VM, you also have access to data._query and data._triggerData.
Additional Information (Metrics & Tags)
There is additional information in the data object, which contains the user's activities and the internal JUNE tags.
data._metrics = {
activity: {
website_tracking: [
{
action:"goal",
created_at:"2023-07-19T11:38:04.408Z",
name:"order-placed",
reference_type:"list",
reference_id:"649ea3eb410bdec9553884b3"
},
...
],
list_action: [
{
trigger:"on_website_goal",
id:"64a6c83489c9f9ef0984a7a9",
created_at:"2023-07-19T11:38:04.753Z"
},
...
],
campaign: [
{
action: "link",
created_at: "2023-07-19T14:46:10.742Z",
id: "64b7f69bc3ac24f1f1f909b8",
value: "https://juneapp.com/"
},
...
]
},
tags: [
"my-first-tag",
...
]
}Working in a VM (Tips & Tricks)
Since you are working in a VM, you do not have access to "normal" globals and prototypes like in a browser. Try to write the code as simply as possible in the ES5 standard.
You cannot use console.log() or similar to debug/test the execution.
To call up chained variables, the optional chaining operator should be used.
let firstname = data?._triggerData?.user?.first_name;
Date fields are saved in ISO format. If you want to work with a date or save a new date, you should therefore restore the ISO format.
let now = new Date().toISOString();
The API behind the VM relies on the return value that is returned. For example, if a NULL or undefined is passed for the firstname:string, a string is cast from it. The data set will then contain "null" or "undefined" for the firstname.