assyst Integrations

Hello,I have some questions about DMWs and whether it’s possible to specify that one or more fields should not be overridden unless a value is supplied during the DMW import when using the default Worksheet Channel in ETM. For example, when updating Item Users, there may be some users who already have an existing Item Users record. During import, instead of creating a new record, the existing record is then instead updated. The issue is that if say the original record had data in the Access Note or Remarks fields, and the DMW import file has a blank column for those fields, then the previous data is overwritten with an empty string.If the column is not included in the import file then any existing value is not overwritten, however as long as the column header is present then the original data is blanked if left empty in the import file. We’ve tested applying a default value of Empty_Record to the DMW import file

We are experiencing the error ORA-00001: unique constraint (SA.IRS_2_UX) violated in the Action Processor.Currently, we are using the following script as a workaround, executing it directly in the assyst database:DELETE FROM ext_linkage WHERE external_id = 'ACT_REG_ID' AND external_owner = 'Action_Processor';DELETE FROM integrations_record_status WHERE owner = 'Action_Processor';However, this error has been occurring more and more frequently. When it is not identified and addressed in time, executing this procedure ends up removing the Action Processor backlog, which may result in rules not being executed.We would like to know whether there is a definitive solution for this issue or if it has already been fixed in more recent versions of the Action Processor.Any assistance would be greatly appreciated.

We are pleased to announce that assyst IPaaS ETM 1.11.1 has now been released and is available to download from our CDN. This release contains a fix for the identified problem P16921. The release notes detailing this fix can be viewed here.

We are pleased to announce that assyst Action Processor 1.9.16 has now been released and is available to download from our CDN.Release notes can be viewed via the following link

We are pleased to announce that assyst REST API 1.8.16  has now been released and is available to download from our CDN.The release notes can be viewed via the following link

We are pleased to announce that assyst IPaaS 1.11.0 has now been released and is available to download from our CDN.Release notes can be viewed via the following link

Hello. I am creating some functionality in ETM which updates the description on normal tasks if an attachment is present on the parent. I would like the destination rule to only send the message to the queue if there is actually at least one attachment present. I have tried the following with no luck.  if ($new.eventTypeEnum = "NORMALTASK" and $new.parentEvent.attachments.length >= 0, true, false)-This expression causes an error when the SR is being submitted.  if ($new.eventTypeEnum = "NORMALTASK" and $new.parentEvent.totalAttachmentCount > 0, true, false)-This expression does not cause any errors, but it’s also evaluating to false even if there is an attachment.  The destination entity I am using is Event, on Create only.  Does anyone know i

We work in Assyst on the creation of new objects using a prefix and an index:Is it possible to use this also via the ETM? When I want to import an object through the ETM, the ShortCode is a mandatory field. Unfortunately, I haven’t found a way to read the last count value from the index in order to provide the ShortCode directly from the ETM.Thank you for your help!Jeremias

Hi!I am having some difficulties trying to get the Base64 value from attachments uploaded to Assyst when working from within an ETM data mapper. I’m currently working in IPaaS 1.8 and Assyst 24R2.The issue I’m trying to solve is for an ETM channel to automatically trigger when a new event is created in a specific service offering, and for ETM to then use the event and its uploaded CSV attachment as input for triggering a specialized import.To facilitate this, I’ve created a serialized-CSV-to-JSON mapping function, that works of output from common.decodeBase64ToString so that I can feed this resulting JSON onwards to this specialized data mappers that performs the assyst import.The destination, channel, common.decodeBase64ToString, CSV→JSON parsing function, and subsequent import all work as expecte

Created a channel to update the empty ItemB with ItemA. I have many that have errored out, but the error doesn’t really give me an clue of what needs to be done.  (Error below)Here is the details of the DataMapper: Here is the definition of channel: The Data:id version csgId dateLogg

Hello,I want to create a monthly event for items due to expire within the next 6 months, firslty how would I just display items where the expiry date is in the next 6 months and then how would I add all those items shortcodes into a remarks field? May be missing something obvious here but data only shows when I add the [0] at the end of the variable.Thanks

We have a requirement where we need to get all the answers of the Decision task using ETm.Example: A decision tasks has 2 Answers “Approved” and “Not-Approved”.We want these answers in a variable.Please help

Does ETM/IPaaS support mTLS authentication? The context for this question is the creation of an ETM HTTP source channel and/or HTTP Request Mappers that we wish to authenticate to a suppliers kafka REST proxy. This proxy has a preferred authentication scheme of utilizing mTLS to securely authorize our supplier to our network, and vice versa. The use of passwords is possible, but is less secure and triggers higher levels of scrutiny during risk assessment, and is thus as a general rule not a preferred method.I can only find information about the use of certificates for OAuth, and its lack of inclusion under Authentication would hint at mTLS not being supported. I’m however asking in case there’s something I’ve missed or misunderstood in the possibilities present

The context for this inquiry is a close partner/supplier who uses Kafka as a message broker, and they have a desire to use it to send and recieve event information for events that should be mirrored in their ITSMs and our Assyst without also having to set up a Kafka REST Proxy unless absolutely necessary.AssystETM utilizes ActiveMQ as its message bus and can be set up to consume messages from other ActiveMQ message buses than the dedicated assyst one. However, a pull based message broker such as kafka does not seem to be mentioned in the wiki.I don’t have high hopes this is possible out of the box as of now, and it sounds ill-advised for us to try adding a Kafka client OSGi bundle to IPaaS ourselves😅. That being said, is this something that has been tested or done before, or is native support for using Kafka or another message broker something that is in the works or has been considered?Native support for Kafka sounds like something that could be a common u

Hi all, I am trying to reference an incident (Event) in ETM via the Event Ref and Event Type field (I cannot use the Event ID) but ETM keeps throwing an error … The database and the wiki appear to show the int 4 as a valid value. The domain model refers to getEventTypeEnum. Can anyone tell me what is causing this error?Thanks!Trevor

I’m using ETM 1.10.0 and assyst 11.8.4Within the ETM I want to have additional affected users added to an event after it’s created.  (We’re using the Destination process to feed details in the ETM after the event is created.)The mapper resource is set the Event, and I use ‘Record to Update’ to search for the event.  However, although the ETM datamapper gets the correct additional users to add, the result is always ‘No update needed’.This is the only update required on the mapper.  Is there something else I need to select, or some way to force the update, please?

Hello,I have a question about the use of deep linking to Assyst resources when data mapping in ETM. I’d love some feedback on my current approach,  and whether there are other approaches I haven’t considered. TL;DRIs it possible in ETM to refer to the AssystREST URL that is specified in the IPaaS/ETM installation, as to create deep linking to the same Assyst environment ETM is attached to? Are there other ways to do deep linking in Assyst ETM? BackgroundOur IT users spend a lot of time trying to find the correct menu for a given resource and waiting through load times during manual lookups. Because of this, direct links to resources are almost always preferred to use speed up the process.When working on integrations in Assyst ETM, I thus often find it helpful to add deep links to Assyst resources (e.g., specific actions, events, items), which would normally only be added as plain text shortCode during ma

Hello.We are just beginning to look at using assyst Destination along with ETM to configure some integrations. I have created an ETM channel with a destination source, but the ID of the entity is not being passed through when the entity is being created.  Destination: I know that the destination is working, because when I take the action, an import is coming through to ETM. However, ETM is saying that there are 0 records to import: I have also inspected the message that is coming through ActiveMQ, and the ID is indeed included as part of the message body.  Any help would be appreciated.  assyst Version: 24R2 SU4

So I know I can get an array of the various custom fields with the following query parameter, but there is more benefit to be able to retrieve the value for a custom field by wither Short Code or custom field ID.  Is that even possible?   If so, what is the syntax to do so?returns all single select custom fields for specified event.“.../assystREST/v2/events/7430?fields=customFields.singleSelectValue”looking to return a specific custom field’s value either by ID or Short CodeThanks in advance for any help

hello,I am need of searching for specific action types for a specific event and I cannot get the syntax right for specifying “action type”.   Any help on what is correct syntax and value for searching for actions of a certain action type, is greatly appreciated. Action Type for “ASSIGN” is of greatest interest I can query for all actions for a specific event without issue: but I cannot filter it down for specific “action types”: 

Hello. We have a legacy escalation utility aLua script, which we use to take escalation actions on events when SLA escalations breach. Currently, the aLua script has two parts. The first runs an SQL query to identify which events need which escalation actions. This results in a CSV file being sent to ETM to add the action to the event. No issue with this part, it works well. The second part runs an SQL UPDATE statement to update the intesc1 (or intesc2, depending on escalation type) on the event’s incident data record. I am trying to integrate this second part into the ETM channel, but have not been able to find a field in ETM which will update this column in the database.  For reference, here is the code from the aLua utility: SQL_UPDATE_FIELD_1 =  [[SELECT      i.incident_id ESC_EVENT_ID,    'ESC1' ACTION_TFROM incident i     INNER JOIN inc_data id ON i.incident_id = id.incident_id WHERE

Hello. I am looking for information on how to determine in ETM whether a custom field value brought back from an event is a Shared Field. I have an Event mapper where I am able to bring back the customFieldsMap. One of the fields I happen to know is a Shared Field, but I want to code my mapper to verify that the value is coming from a shared field, but I can’t see any attribute which would identify the field as a Shared Field. This is what I get for the field: "COST-CENTRE": {                "imageId": 0,                "customLookupValueId": 0,                "assystRESTType": "customField",                "assystRESTXMLType": "webCustomPropertyValueDto",                "objectAvailable": true,                "systemRecordFlag": false,                "decimalValue": 0,                "customFieldId": 79913,                "version": 1,                "entityInstanceId": 15400971,

Hi everyone!I'm kind of a newbie on ETM, even reading the documentation I think I need your help.For corporate policy we have to delete all events older than 24 months, no matter the type or the status of the event. Right now we are using the archive/delete function in Assyst where I run a query that I modify every time I need it.Reading the documentation I learnt that with a Datamapper you can perform a delete record so ideally I want to turn it into an automatic operation rather than doing it manually every time, but I'm not sure how I can tell the Datamapper to search only for the logged date older than 24 months (24 older from the actual date, ideally that date dynamically changes to do it automatically).Ideally I would like to run this every night with a CRON function but right now I don't know how manage it.Anyone could help me understand how to do it? If there are some examples or guidelines in the doc that I missed out feel free to point th

Hello everyone 😊I'm at my wits' end and could really use some help with something that feels like it should be obvious—but I just can’t get the hang of it.I’m currently working with assyst24R2 and IPaaS 1.8, and I’ve come across the typeaheadFilter query parameter in AssystREST. I’m trying to understand its intended use case and how (or if) it can be used when datamapping in ETM.My current use case is to return an array of all users whose shortCode starts with ZZ_, but I haven’t found a way to use [like] or [exclude] operators in datamapper fields, and i stumbled upon this query parameter in the search for this funcionality.There doesn’t seem to be any documentation on the wiki regarding the typeaheadFilter parameter—no examples, no reference, or examples of it behaviour, the only thing i could find was it’s mention as a query parameter in the RAML,

Hi everyone,I have a question regarding the use of onBehalfOfUser when datamapping and wonder if anyone else has experienced this issue, and if there are specific considerations or steps that need to be taken when using this?Whenever I try to use onBehalfOfUser in an Assyst Request datamapper, the resource returns as "Update Needed."I have logged a ticket on the IFS assystNet, but I’m wondering if anyone else has experienced this and what workarounds exist, if any.Thanks in advance!