Validating Excel spreadsheet data in ServiceNow
One of the most common uses of ServiceNow is importing and storing data. Data import is often facilitated through import sets and transform maps. But what if you need to ensure data accuracy before a file is even attached? By validating the contents of an Excel file in advance, you can prevent users from uploading […]
Exporting data that includes the SysID field
You may find yourself in a situation where you are required to update a large quantity of records extracted from a ServiceNow instance, outside of ServiceNow. An important step to completing bulk updates is ensuring you’re updating the correct records. Luckily, ServiceNow already has this problem partially solved for us by making the SysId unique […]
Attaching an Excel attachment via email in ServiceNow
We use transform maps for a lot but there are often times when we need to trigger a transform to occur on command, quite frequently through email. Assume you had a scenario where a client was interested in sending in a data source via email into the instance with the expectation that the data […]
Validating Excel spreadsheet data in ServiceNow
One of the most common uses of ServiceNow is importing and storing data. While import sets and transform maps have their own methods of validating the data before the data is imported into the system, it is also possible to validate the contents of an Excel file before allowing a user to attach it […]
